Basic Formulas In Excel Review

Front

What does the SUM function do in Excel?

Back

Adds up all the numbers in a range of cells.

Front

What symbol is used for division in Excel formulas?

Back

/

Front

In Excel, how do you multiply two values using a formula?

Back

Use the '*' operator in a formula.

Front

What is the purpose of the MAX function in Excel?

Back

To find the highest number in a range of numbers

Front

What is the formula to find the sum of cells A1 to A10 in Excel?

Back

=SUM(A1:A10)

Front

When typing formulas, they must begin with an __ sign.

Back

=

Front

What is the name of this cell? Options: B10, 5B, B5, A5

Back

B5

Front

What is the symbol to subtract in Excel?

Back

-

Front

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written? Options: =SUM(C1-C5), =SUM(C1,C5), =SUM(C1:C5), =SUM(C1*C5)

Back

=SUM(C1:C5)

Front

What would be a correct formula for SUM in excel?

Back

=SUM(B3:B9)