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

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

When you wrap text, the column width changes to accommodate the text.

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

A cell theme is a collection of formatting characteristics you apply to a cell or range of data.

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

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

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.

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

Horizontal alignments do NOT include ____.

Excel ____ all numbers.

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

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.

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

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.

One way to see all the text stored in a cell is to wrap text. The ____ adjusts  automatically to include additional lines until all the text is visible.

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

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

By default, the ____ theme is applied to each workbook.

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

FIGURE 2-1




Excel Case 2-1
Tessa’s boss gave her the spreadsheet above. She is working on changing the formatting. Please refer to the figure above while answering the questions below.

Tessa wants to find and replace italic text with bold text.  Where can she find the dialog box to do this?

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?

Excel Case 2-2
Josh wants to apply a cell style to certain cells in his worksheet.  Please answer the questions below.

Josh wants to get to the Cell Style gallery.  How does he navigate to the Cell Style gallery?

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.