Exam 24: Changing the Appearance of a Worksheet

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

The default ____________________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

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

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.

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.

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Once the Find and Replace dialog box appears, with the Replace tab displayed, what button should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.

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

Press the ____ keys to apply underlining.

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

Horizontal alignments do NOT include ____.

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

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

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

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.

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

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