Exam 13: Formatting a Worksheet

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

If a label is too long to fit into a cell it is always truncated.

After a chart is selected, you cannot resize it.

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.

Which of the following is a button that allows you to customize a chart?

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.

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

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

Which of the following buttons should you use to add and remove border lines inside vertical lines?

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

The square handle that appears at the top of a graphic allows you to rotate the graphic.

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

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

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

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

To quickly select all cells in a column, _____.

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.

You can quickly add simple borders using the Borders button in the ____________________ group on the HOME tab.

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

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.