Office Productivity Final Exam

What would be a correct formula for SUM in excel?

• =SUM(B3-B9)

• =SUMB3+B9

• =SUM(B3:B9)

• =SUM[B3:B9]

Which symbol must all formulas begin with?

• +

• =

• /

• -

What command means combining two or more cells?

• conjoin

• add

• join

• merge

Which response best completes the following statement: A formula is used to ____________________.

• add data

• find averages

• make presentations

• perform calculations

Excel follows the ____________________ and first adds the values inside the parentheses.

• Order of Formulas

• Formula Guidelines

• Order of Operations

• Operation Guidelines

How would you write a cell reference formula for cell C3 subtracted from Cell A1?

• A1-C3

• C3-A1

• =A1-C3

• =C3-A1

What is this symbol?

• less than

• greater than

• less than or equal to

• greater than or equal to

What is the function of this symbol?

• division

• addition

• subtraction

• multiplication

What is the symbol used in a Cell Range?

• 
• 
• 
• 

What is the function of this symbol?

• division

• addition

• subtraction

• multiplication