Exam 8: Excel Lesson 2: Changing the Appearance of a Worksheet

FIGURE EX 2-1 In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.

The default number format is General, which displays numbers the way you type them.

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

Horizontal alignments do NOT include ____.

To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the Home tab of the Ribbon.

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

As you format cells, ____ shows the results of the different formatting options you can choose.

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh previews some of the styles and clicks one to apply it to the cell. He now wants to remove it. To remove a style from the selected cell, he should simply click ____ in the Good, Bad and Neutral section of the Cell Styles gallery.

A ____ is a preset collection of design elements, including fonts, colors, and other effects.

Number fills change the way data looks in a cell.

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Press the Ctrl+B keys to apply bold.

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Numbers that do not fit in the cell are shown as a series of question marks (??????).

____ determines the best width for a column or the best height for a row, based on its contents.

If you want to specify a precise column width, use the Column Width ____.