Exam 6: Formatting a Worksheet

Which of the following chart types is used to show data that changes over time?

If your computer is configured for use in the U.S., the Comma Style button adds a comma every three digits to the left of the decimal point and displays _____ digits to the right of the decimal point.

Which of the following is displayed in the cell if the value is too long to fit into a cell?

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.

You can use buttons in the Font group on the _____ tab to select different font attributes for any data in worksheet cells.

If a label is too long to fit into a cell and the next cell is empty, _____.

Which of the following buttons displays one more digit after the decimal point?

Excel gives you the ability to chart or graph data in your worksheet. Describe the main chart types (line, pie, and bar) and their purpose. Also describe how to insert a chart in your worksheet.

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 where he can find tools that will allow him to draw simple lines and shapes. She advises him to use the _____.

Borders and background colors define areas of a worksheet and call attention to important information.

In the accompanying figure, which callout points to the button that is used to change the source cells for a chart?

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

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.

A(n) _____ chart (sometimes called a column chart) is used to show comparisons.