Click on the correct response for each question below.
|
1 | | This is a set of values that you want to chart in Excel. |
| | A) | Object |
| | B) | Numbers |
| | C) | Data series |
| | D) | Formulas |
|
|
2 | | In a chart, this contains the value of data being plotted. |
| | A) | Y-axis |
| | B) | X-axis |
| | C) | Plot area |
| | D) | Range |
|
|
3 | | In an Excel chart, these are extensions of tick marks that help to identify the value of the data markers |
| | A) | Markers |
| | B) | Gridlines |
| | C) | Legends |
| | D) | References |
|
|
4 | | This will indicate which data marker represents each series in a chart of multiple series. |
| | A) | Chart Reference |
| | B) | Chart title |
| | C) | Chart Legend |
| | D) | Chart box |
|
|
5 | | When a chart is placed on this, it is much larger and there is no other data on it. |
| | A) | Chart sheet |
| | B) | Exclusive sheet |
| | C) | Primary sheet |
| | D) | Reference sheet |
|
|
6 | | This dialog box specifies or modifies the worksheet cell range containing data to be charted. |
| | A) | Chart Location |
| | B) | Chart Style |
| | C) | Chart Options |
| | D) | Chart Source Data |
|
|
7 | | When using the Chart Wizard, the way that the data series is represented is modified with this option. |
| | A) | Subtype |
| | B) | Object |
| | C) | Series in |
| | D) | Style |
|
|
8 | | This key is used when snapping an embedded chart into place. |
| | A) | ALT |
| | B) | cTrl |
| | C) | TAB |
| | D) | F4 |
|
|
9 | | The simplest way to add a series to a chart is to |
| | A) | add a range to the worksheet and then drag the new data and label cell range to the embedded chart. |
| | B) | add a cell to the worksheet and then drag the new data and label cell range to the embedded chart. |
| | C) | add a row to the worksheet and then drag the new data and label cell range to the embedded chart. |
| | D) | add a column to the worksheet and then drag the new data and label cell range to the embedded chart. |
|
|
10 | | This is the menu command used to elevate and rotate a pie chart. |
| | A) | Chart/3-D View/Elevation |
| | B) | Format//3-D View/Elevation |
| | C) | Insert/3-D View/Elevation |
| | D) | Tools/3-D View/Elevation |
|
|
11 | | This type of chart is often used to highlight when blood pressure is too high or temperatures are reaching a critical value. |
| | A) | Pie |
| | B) | Bar |
| | C) | Area |
| | D) | XY |
|
|
12 | | Although you can chart as many as 255 data series in a chart, a two-dimensional chart is limited to a total of 32,000 total data points. |
| | A) | True |
| | B) | False |
|
|
13 | | A data marker is a bar, dot, slice, or another symbol in a chart representing a single data point or value. |
| | A) | True |
| | B) | False |
|
|
14 | | By default a chart sheet contains gridlines. |
| | A) | True |
| | B) | False |
|
|
15 | | The chart sheet is particularly useful when printing color transparencies for a presentation. |
| | A) | True |
| | B) | False |
|
|
16 | | When creating a chart, simply select the appropriate data range and launch the Chart Wizard. |
| | A) | True |
| | B) | False |
|
|
17 | | The first step in the Chart Wizard allows you to modify the data series in case an incorrect range was accidentally selected. |
| | A) | True |
| | B) | False |
|
|
18 | | Charts are not automatically linked to the data from which they have been created. |
| | A) | True |
| | B) | False |
|
|
19 | | Any text values in a worksheet that are part of a chart will update automatically when changed. |
| | A) | True |
| | B) | False |
|
|
20 | | When you change the largest data point within a chart, Excel automatically recalibrates an appropriate Y-axis scale. |
| | A) | True |
| | B) | False |
|
|
21 | | One of the most dramatic changes you can make to a chart is to add, delete, or highlight a series in the chart. |
| | A) | True |
| | B) | False |
|