EXCEL

Part # 523456 is entered on a spreadsheet, is this a label or a value?

• Label
• Value

When is a cell considered active?

• it is never considered active
• when you click on it
• cells can't be active

Rows are which of the following:

• vertical
• horizontal

Columns are vertical.

• True
• False

What does every formula or function start with?

• !
• @
• #
• =

What is the formula for =sum(B2:B9)

• B1+B2+B3+B4
• =B2+B3+B4+B5+B6+B7+B8+B9
• B2+B3+B4+B5+B6+B7+B8+B9
• =B1+B2+B3+B4

What is the formula to find the lowest number in cells C1:C4?

• =average(C1:C4)
• =max(C1:C4)
• =min(C1:C4)
• =sum(C1:C4)

What would I use to combine cells A1:A9?

• adjust column width
• merge
• wrap text

$5.25 is entered on a spreadsheet, is this a label or a value?

• label
• value

What should you do if you see #### on your spreadsheet?

• merge cells
• wrap text
• adjust column width