Exam 13: Formatting a Worksheet

After you've finished formatting a worksheet cell, click inside the cell to complete the process.

The formula =D3+D4 changes to _____ if the original column C is deleted.

To add borders around the outside and inside edges of selected cells, click both Outline and Inside buttons in the _____ section in the Format Cells dialog box.

Excel gives you the ability to apply number formats to your values. Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

Case-Based Critical Thinking Questions Case 13-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra how to insert clip art. She tells him to _____.

In the accompanying figure, which callout points to the charting tabs?

In the accompanying figure, which callout points to the button used to center cell contents?

As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.

To delete a row, first click _____.

To add a colored background to a selected cell or cells, click the _____ tab in the Format Cells dialog box.

To display the Format Cells dialog box you also can use the Format Cells Dialog Box Launcher in the _____ group.

The Percent Style button displays cell contents as a percentage, which means .35 is displayed as _____.

To put borders between individual cells you should click the _____ button in the Format Cells dialog box.

In the accompanying figure, which callout points to the Merge and Center button?

You can use the Charts group on the _____ tab to chart or graph data in your worksheet.

A variety of predefined themes that improve the appearance of your worksheets are located on the _____ tab.

When you click the ____________________ Decimal button, one fewer digit is displayed after the decimal point.

Font ____________________ are typically applied to the entire contents of a cell.

Photographs can be inserted only from a file.

You have to manually modify your formulas if blank rows or columns are inserted or deleted.