Essentials Excel Level Iii Test Bank Page 4

3. A(n) ______ chart represents data with shaded areas rather than bars or lines.

Answer: area

Lesson: 3

4. A 3-D chart includes a depth dimension as well as height and ____ dimensions.

Answer: width

Lesson: 4

5. In the ____ view dialog box, you can click to apply a setting and view the results in the chart.

Answer: 3-D

Lesson: 4

6. You can use a ______ for the data markers in a variety of chart types, including area and

column.

Answer: picture

Lesson: 5

7. A _____ bar means that the closing price was lower than the opening price.

Answer: black

Lesson: 6

8. One of the most useful charts for statistical purposes is the _____ chart that plots two groups

of numbers as one series of xy coordinates.

Answer: XY Scatter

Lesson: 7

9. A _______ is a graphical representation of the direction or trend of data.

Answer: trendline Lesson: 8

10. ______ is a measure of how well the line fits the data points.

Answer: R-squared Lesson: 8

0 votes

Parent category: Education