Spreadsheet Formulas,Charts,Formatting

1. Which of the following charts uses vertical bars to display data?

• a. Bar

• b. Pie

• c. Area

• d. Column

Which of the following charts uses horizontal bars to display data?

• a. Bar

• b. Pie

• c. Area

• d. Column

4. Which of the following charts is used to compare a single category of values as parts of a whole?

• a. Bar

• b. Pie

• c. Scatter

• d. Column

5. A chart ________________ identifies which data series each color represents.

• a. legend

• b. vertical axis

• c. title

• d. horizontal axis

What information appears most commonly on the horizontal axis?

• a. Quantities

• b. Time frames

• c. Data series color definitions

• d. Titles

What information appears on the vertical axis?

• Data series headings or time frames

• Data series color definitions

• Even counts of all the values in your data series

• TITLES

3. A ___________________ is a graphical representation of data.

• a. spreadsheet

• b. border

• c. chart

• d. table

9. Which type of chart assigns a color to each data point instead of series?

• a. Column

• b. Area

• c. Pie

• d. Scatter

Which two chart types are the most interchangeable?

• a. Pie and Area

• b. Bar and Column

• c. Line and Scatter

• d. Pie and Bar

11. What command enables you to change the location of your chart?

• a. Cut

• b. Copy

• c. Move

• d. Delete