1
What does the formula =SUM(A1:B5) calculate?
It calculates the sum of the values in cells A1 through B5.
How do you find the minimum value in the range A1 to A20?
You can use the formula =MIN(A1:A20).
What result does =MAX(B1:B10) produce?
It calculates the maximum value in the range B1:B10.
=SUM(A1 A10)
Missing the colon between cell references.
What is the result of =AVERAGE(C2:D10,E1)?
It calculates the average of the values in the range C2:D10 and the single value in cell E1.
What result does =AVERAGE(B2:D2) produce?
It calculates the average of the values in cells B2, C2, and D2.
How would you find the sum of values in columns C and D for rows 1 to 20?
You can use the formula =SUM(C1:D20).
=COUNT("A1:A10")
Including range reference within quotation marks, which treats it as a text string rather than a range.
How can you find the maximum value in a range A1:A10?
use the formula =MAX(A1:A10).
How do you find the maximum value in columns F and G for rows 1 to 10?
You can use the formula =MAX(F1:G10).
=COUNT(A1:B5, C1:C10) count?
It counts the number of cells containing numbers in the range A1:B5 and the range C1:C10.
=SU(A1:A10)
Misspelling "SUM" as "SU".
What does =COUNT(B2:B8,C3:D6) count?
It counts the number of cells containing numbers in the range B2:B8 and the range C3:D6.
What does =COUNT(A1:A5, B2:D2) count?
It counts the number of cells containing numbers in the range A1:A5 and the range B2:D2.
How do you find the average of values in cells E1 to E50?
You can use the formula =AVERAGE(E1:E50).
=MAX(A1+A10)
Using arithmetic operator '+' instead of colon ':' for defining the range.
How would you calculate the total of values in columns F and G for rows 1 to 10?
You can use the formula =SUM(F1:G10).
How would you calculate the sum of values in cells A1 to A100?
You can use the formula =SUM(A1:A100).
if you write =MAX(A1:A10, B1), correct the error
=MAX(A1:A10)
=AVERAGE(A1, A2, A3)
missing commas to separate individual cell references within the same range instead of using a colon.