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

Essentials Excel Level Iii Test Bank Page 2

b. the chart area

c. the plot area

d. all of the above

Answer: d Lesson: 5

7. A stock that has data for Open, High, Low, and Close values at the end of each day for a

month can be plotted using

a. Stock chart option

b. XY Scatter chart

c. Doughnut chart

d. Trendlines

Answer: a Lesson: 6

8. The vertical likes on the Stock Chart option are High and Low values and the bars are the

a. data series

b. Open values

c. Close values

d. both b and c

Answer: d Lesson: 6

9. A chart type that plots two groups of numbers as one series of xy coordinates and shows a

relationship between two variables is

a. Doughnut

b. XY Scattered

c. 3-D Stacked Column

d. Area

Answer: b Lesson: 7

10. If the measure of how well the line fits the data points is .2501, then the fit is

a. poor

b. good

c. moderate

d. very good

Answer: a Lesson: 8

True/False

1. A chart is a graphical representation of data that makes it easy for users to see trends and

make comparisons.

Answer: True

Lesson: Introduction

Essentials Excel Level Iii Test Bank Page 2