EXCEL

Front

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

Back

Label

Front

When is a cell considered active?

Back

when you click on it

Front

Rows are which of the following: vertical, horizontal

Back

horizontal

Front

Are columns vertical?

Back

True

Front

What does every formula or function start with?

Back

=

Front

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

Back

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

Front

What is the formula to find the lowest number in cells C1:C4? Options: =average(C1:C4), =max(C1:C4), =min(C1:C4), =sum(C1:C4)

Back

=min(C1:C4)

Front

What would I use to combine cells A1:A9? Options: adjust column width, merge, wrap text

Back

merge

Front

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

Back

value

Front

What should you do if you see #### on your spreadsheet? Options: merge cells, wrap text, adjust column width

Back

adjust column width