Exam 6: Formatting a Worksheet

To quickly select all cells in a column, click the column _____ at the top of the column.

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 to insert clip art. She tells him to _____.

Like Word, Excel allows you to work with styles.

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

An effectively formatted worksheet is more approachable and helps readers understand the meaning of values and formulas.

Photographs can be inserted only from a file.

The buttons that allow you to customize a chart appear in the _____ of the chart.

To quickly select all cells in a column, _____.

Which of the following chart types is used to illustrate the proportion of parts to a whole?

The formula =D5+D6 changes to _____ if rows 1 and 2 are deleted.

A(n) line chart is used to show the proportions of parts to a whole.

To delete more than one row at a time, drag down over the rows you want to delete. Click the down-arrow button next to Delete in the _____ group, then click Delete Sheet Rows to delete the rows.

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

Predefined _____ are built into the software, and include formats for displaying currency, percentages, and general numbers.

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

Excel automatically adjusts the height and width of selected cells when you use the _____ command located in the HOME tab's Format button.

The most commonly used number formats are available as buttons in the _____ group on the HOME tab.

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

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

To change the font for a range of cells, click the _____ cell, then drag the mouse to select the cells.