A
Which function capitalizes the first letter of each word?
PROPER
Which function finds the largest number in a range?
Max
Write a formula to find the average of cells D1 through D10.
=AVERAGE(D1:D10)
What’s wrong with this formula? =SUUM(A1:A10)
The function name is misspelled; it should be =SUM
Which function adds up a range of numbers?
Sum
What’s wrong with this formula?
=SQRT(A1:A5)
The SQRT function only works on a single value, not a range. Correct formula: =SQRT(A1) (for a single cell)
What’s wrong with this formula?
=AVERAGE(A1+A2:A5)
Mixing a single cell (A1) with a range (A2:A5) is incorrect for AVERAGE.
Correct formula: =AVERAGE(A1, A2:A5)
Fill in the blank:
=________(“hello world”) to capitalize all letters.
Upper
Which function finds the smallest number in a range?
Min
What’s wrong with this formula?
=SUM(A1 A2:A5)
The comma is missing between A1 and the range A2:A5.
Correct formula: =SUM(A1, A2:A5)
Fill in the blank:
=________(B1:B5) to add the values in the range.
Sum
Fill in the blank:
=________(D1:D8) to find the smallest value.
Min
Write a formula to find the maximum value of cells B1, B2, and B3.
=MAX(B1, B2, B3)
Fill In the Blank:
=________(A1:A10) to find the highest value.
Max
Write a formula to convert the text in cell C1 to lowercase.
=LOWER(C1)
Which function averages a set of numbers?
Average
Write a formula to calculate the sum of cells A1 through A10.
=SUM(A1:A10)
What’s wrong with this formula?
=MINIMUM(A1:A10)
There is no MINIMUM function in Excel; use MIN.
Correct formula: =MIN(A1:A10)
Which function would you use to calculate the square root of a number?
Sqrt
Write a formula to find the average of cells B2 to B6.
=AVERAGE(B2:B6)