Basic Formulas In Excel Review

What does the SUM function do in Excel?

• Divides the numbers in a range of cells.

• Adds up all the numbers in a range of cells.

• Subtracts the numbers in a range of cells.

• Multiplies all the numbers in a range of cells.

What symbol is used for division in Excel formulas?

• //

• -

• /

• :

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

• Use the '*' operator in a formula.

• Use the '/' operator in a formula.

• Use the '+' operator in a formula.

• Use the '-' operator in a formula.

What is the purpose of the MAX function in Excel?

• To find the average of a range of numbers

• To find the highest number in a range of numbers

• To multiply all numbers in a range

• To divide all numbers in a range

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

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1:A10)

• =SUM(A1,A10)

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

• =

• &

• ~

• < >

What is the name of this cell?

• B10
• 5B
• B5
• A5

What is the symbol to subtract in Excel?

• ^
• /
• -
• =

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?

• =SUM(C1-C5)

• =SUM(C1,C5)

• =SUM(C1:C5)

• =SUM(C1*C5)

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)