Excel Unit Review

What would be a correct formula for sum in excel?

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

Which symbol must you use to begin a formula?

• +
• =
• /
• *

A workbook is defined as having 1 or more ____________________.

• books
• cells
• blocks
• spreadsheets

B1 would be referred to as a cell __________________.

• mate
• book
• map
• address

What is an active cell?

• The first cell in a database.
• The cell currently selected.
• The cell that all the data goes to.
• The cell that you typed in last.

E44 is an example of a __________________.

• Cell Reference
• Formula Bar
• Active Cell
• Formula

Which one of these formulas uses relative cell references?

• =8/10+3
• =$b4$2/10
• =F6*H7/J2

Which of these formulas uses absolute cell references?

• =8/10+3
• =$B4$D2
• =F6*H7/2

What does this tool do?

• Make a table
• Make a chart
• Make borders
• Make a formula

What term refers to a group of spreadsheets in 1 file?

• Cell range
• Active cells 
• Worksheet
• Workbook