BCIS: Excel Module 4

10 September 2022
4.7 (114 reviews)
15 test answers

Unlock all answers in this set

Unlock answers (11)
question
data labels
answer
____provide descriptive text for the individual data markers, such as pie slices
question
data series
answer
A ________ contains the actual values that are plotted on the chart.
question
only one value
answer
A pie slice is a data marker that represents ____ from a data series
question
either a or b
answer
Category values are usually located in the ____ of the data source.
question
chart sheet
answer
Placing a chart in a ____ displays only the chart and no worksheet cells.
question
legend
answer
The ____ identifies which data markers are associated with each data series.
question
pie
answer
The ____ is the only one of the following charts to compare relative values from different categories to the whole
question
clustered column chart
answer
The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.
question
principal
answer
The amount of money being loaned is known as the ____.
question
scale
answer
The range of values or _______, of an axis is based on the values in the data source.
question
exploded pie chart
answer
To move one slice of a pie chart away from the pie creates a(n) ____.
question
dual axis
answer
When combination charts have data series with vastly different values, you can create ____ charts.
question
T(rue)
answer
A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value TRUE/FALSE
question
T(rue)
answer
Excel charts are either placed in their own chart sheets or embedded in a worksheet. TRUE/FALSE
question
F(alse)
answer
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent TRUE/FALSE