Excel in 30 Minutes – Text and Number Formats

Formatting applies to cells, not data.

True

False

Format Painter:

Pastes formulas in other cells

Copies and pastes formatting to other cells

Can copy formatting to be pasted in multiple cells if you double-click the icon

B, C only

What does it mean if you see ###### in a cell?

The number is too large to display in the current column width

The text is too large to display in the current column width

The formula in the cell has an error in it

The cell is locked so you cannot enter any data into it

Information