Microsoft Excel

To arrange data in alphabetical or numerical order is what?

• coding

• sorting

• graphing

• grouping

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

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

• True

• False

Margins are the white space on the spreadsheet where nothing prints.

• 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

If you change the value in a cell then the associated graph will NOT change.

• True

• False

What happens to a spreadsheet when you use the Ctrl~ command on a PC?

• calculates the values in formulas

• autofits the columns and rows

• displays the formulas

• nothing

Every formula starts with what?

• =

• +

• -

• ( )

What tool allows you to capture the formatting in one location and easily format other cells the same way?

• copy and paste

• cut and paste

• format painter

• alignment tool