Exam 6: Formatting a Worksheet

To change the width of a cell, you must increase the width of the entire column .

You can apply number formats to any cell.

Which of the following is aligned on the left edge of a cell by default?

Case-Based Critical Thinking Questions Case 6-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 he can resize a graphic inserted into his worksheet. Kyra says he can _____.

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

In general, you begin most modifications on the chart by _____ the chart element you want to change.

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

The _____ button displays formatting options that you can apply to sections of a worksheet.

_____ can be inserted from a file or imported directly from imaging devices.

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

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.

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

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

You can change to a different chart type clicking the FORMAT tab, then clicking the Change Chart Type button.

To add borders around the outside and inside edges of selected cells, click both the Outside and Inside border buttons in the Preset section.

To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a shape. _____ while you drag the vertical line left or right to manually adjust the width of the column.

To delete a row, first click _____.

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

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

By default, values are always centered within the cell.