Essentials Excel Level Iii Test Bank

ADVERTISEMENT

ESSENTIALS EXCEL LEVEL III TEST BANK
Project 4 Test
Multiple Choice
1. Which of the following charts displays multiple data series appearing as stacked components
a. Doughnut
b. Column
c. Stacked Column
d. 3-D Stacked Column
Answer: c Lesson: 1
2. To a link cell text to a title within a chart, click within the chart title, click within the formula
bar and
a. type an equal sign(=)
b. select a cell and press $$$Enter$$$
c. select a cell
d. do both a and b
Answer: d Lesson 1
3. A doughnut chart that a data segment and its relationship to the whole is similar to a(n) 2
a. Stacked chart
b. Pie chart
c. Area chart
d. XY Scatter chart
Answer: b Lesson: 2
4. A chart that represents data with shaded areas rather than bars or lines is a(n)
a. Area chart
b. XY Scattered
c. Doughnut chart
d. Trendline
Answer: a Lesson: 3
5. If each data point is reflected in the height of a circular column in relation to the scale on the
Y-Axis, then a(n)
a. Doughnut chart is created.
b. Area chart is created
c. Stacked column chart is created
d. 3-D Cylinder Chart is created
Answer: d Lesson: 4
6. A picture can be added to enhance a chart as
a. data markers
49

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Education
Go
Page of 4