MS Excel - Quiz 1

If you click on a letter at the top of an Excel spreadsheet, what have you done?

• selected a cell

• selected a range of cells

• selected a row of data

• selected a column of data

A four-sided arrow does what in Excel?

• copies the contents of one cell to others around it

• moves the contents of one cell to another location

• selects the cell

Every formula starts with what?

• =

• +

• -

• ( )

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

• cell bar

• formula bar

• status bar

• name box

If you click a number at the left of an Excel spreadsheet, what have you done?

• selected a cell

• selected a range of cells

• selected a row of data

• selected a column of data

To exit an active formula, you always click out of the current cell?

• True

• False

If you see the following, what does it mean? ######

• the formula has an error

• the contents are too large to display

• text was entered where numbers should be

Select all of the following that are available under the Autosum button:

• sum

• minimum

• average

• maximum

• division

What are the two (2) ways to display a spreadsheet in Microsoft Excel?

• fixed

• value

• variable

• formula

If you center or merge and center it does exactly the same thing.

• True

• False