Excel Unit C

Front 1

What allows the user to add information specific to a cell through a floating text box?

Back 1

Comment

Front 2

Comments can be shown on the worksheet, edited, printed, or ______ from a worksheet.

Back 2

hidden or also deleted

Front 3

Conditional Formatting- If data meets _______, Excel applies the _________ you specify.

Back 3

If data meets criteria, Excel applies the formats you specify.

Front 4

Formatting changes only the way a value of label ________. It doesn't alter cell data.

Back 4

appears

Front 5

A ________ is equal to 1/72 of an inch

Back 5

point

Front 6

Excel has how many predefined table styles to improve the appearance of the worksheets.

Back 6

60

Front 7

If ####### signs appear in a column of values, the column is too what to display the contents?

Back 7

narrow

Front 8

Excel inserts rows ______ the cell pointer and inserts columns to ______ of the cell pointer.

Back 8

rows above the cell pointer and columns left of the cell pointer.

Front 9

The Manage Rules feature in conditional formatting allows you to _____, ________, or _______ rules for cells in Excel?

Back 9

create, edit, or delete

Front 10

Auto-Fit resizes a column based on the ________ entry in the column.

Back 10

widest

Front 11

________ or coloring worksheet tabs allows you to identify worksheets easier.

Back 11

Renaming

Front 12

What button centers text horizontally within a cell?

Back 12

Center

Front 13

THe _____ and ________ button merges cells together and centers the contents within the newly created cell.

Back 13

merge and center

Front 14

The default _______ width in Excel is 8.43 characters wide.
~ an inch

Back 14

column

Front 15

Overuse of any font attribute or random formatting can make a worksheet _ to read.

Back 15

hard

Front 16

Using the _____ button on the Keyboard only removes the contents of a selected row or column.

Back 16

delete

Front 17

Using the delete command on the ____ group of the ____ tab deletes the row and column headings as well as its contents. Also, rows shift ____ that were below the data and ______ shift left that were to the right of the data.

Back 17

Using the delete command on the cells group of the home tab deletes the row and column headings as well as its contents. Also, rows shift up that were below the data and columns shift left that were to the right of the data.