| A | B |
|---|
| A pie chart can include only one series of data. | True |
| If a value in a chart data series is changed, the chart automatically reflects the new data. | True |
| A chart that appears as an object in a worksheet is printed when the worksheet is printed. | True |
| A chart can include a non-adjacent data series. | True |
| A range of cells can be copied to another sheet by | using the Copy and Paste buttons. |
| Which type of chart would best illustrate each department's sales as a percentage of the overall store sales? | pie |
| Which can be used in a formula to refer to cell B3 on sheet Sales 2002? | 'Sales 2002'!B3 |
| A sheet can be renamed by | double-clicking its tab to select it, typing a new name, and then pressing Enter. |
| The first step in creating a bar or line chart is | selecting the data to be charted. |
| A chart's title can be modified by clicking the chart title to select it, then | clicking again to place the insertion point, typing new text, and pressing the Enter key. |
| A chart is sized proportionately by dragging | a corner handle. |
| An adjacent data series can be added to a selected chart by | dragging one of the handles of the outlined original data series to include the new series. |
| The portion of the worksheet to be charted is called the | data range. |
| Which option in the Print dialog box prints only the sheet that is displayed? | Active sheet(s) |
| Which type of chart is best for displaying the differences of data over time? | line |
| How does clicking the button on the Chart toolbar affect the selected axis label? | it angles it clockwise |
| Changing the data on one sheet automatically updates the data on the other sheet when the cells are | linked |
| Which type of chart is best for comparing the differences between values? | bar |
| Sheet order can be changed by | dragging a sheet tab to a new location. |
