Essentials Excel Level Iii Test Bank (Page 3 of 4) in pdf

Essentials Excel Level Iii Test Bank Page 3

2. To emphasize the difference in measurement between each series, you add data markers that

connect the data series.

Answer: False

Lesson: 1

3. A doughnut chart is a circular chart with a blank center.

Answer: True

Lesson: 2

4. Only selected slices in a single-series doughnut chart can be pulled out of the chart.

Answer: False

Lesson: 2

5. A data table is a grid attached to a chart that displays the data used to create the chart.

Answer: True

Lesson: 3

6. In the Format Data Series dialog box, a setting to increase the depth is set at a default of 50.

Answer: False

Lesson: 4

7. A picture can be used for the chart area, the plot area or the legend in 3-dimensional charts.

Answer: False

Lesson: 5

8. Excel has a stock chart option to monitor stock prices.

Answer: True

Lesson: 6

9. If there is only one series plotted in a XY Scatter Chart then there is no need for a legend.

Answer: True

Lesson: 7

10. A linear trendline is a best-fit straight line applied to simple linear data.

Answer: True

Lesson: 8

Fill-In-the-Blanks

1. A data _____ is an area, bar, dot, slice or other symbol that represents a data point or value

originating from a worksheet cell.

Answer: marker

Lesson: 1

2. A doughnut chart is similar to a ____ chart because each part shows a data segment and its

relationship to the whole.

Answer: pie

Lesson: 2

Essentials Excel Level Iii Test Bank Page 3