Question 15.

How does Excel distinguish between vertical and horizontal bar charts?

Excel distinguishes between vertical and horizontal bar charts, calling the former column charts and the latter bar charts.

A clustered column chart compares values across categories using vertical rectangles; a stacked column chart displays the contribution of each value to the total by stacking the rectangles

a 100% stacked column chart compares the percentage that each value contributes to a total.

I

II

III

I and II

I and III

II and III

I, II and III

None of the above

Question 16

To select data bars in Excel from the Home tab, which command would have to be accessed?

Find & Select under Editing group

Conditional Formatting under Styles group

Format under Cell group

None of the above

Question 17

You may not display data bars without the data in the cells.

True

False

Question 18

Color Scales are one of the options under Conditional Formatting.

TRUE

FALSE

Question 11

Andrew wishes to understand the relative proportion of each data source to the total. Which of the following charts must Andrew use?

Scatter diagram

Bubble chart

Orbit chart

Line chart

Pie chart

Clustered column chart

Combination chart

None of the above

Question 12.

Observations consisting of pairs of variable data are required to construct a .

Scatter diagram

Bubble chart

Orbit chart

radar chart

Pie chart

Clustered column chart

Combination chart

None of the above

Question 13

Elizabeth, a stock broker, has data consisting of price, price/earnings ratio, and market capitalization for seven different stocks on one particular day. She wishes to plot these three variables in two dimensions. Which of the following charts must Elizabeth use?

Scatter diagram

Bubble chart

Orbit chart

Stock chart

Pie chart

Clustered column chart

Combination chart

None of the above