Excel Quiz 4

Unlock all answers in this set

question
Each slice in a pie chart represents a single value from a data series. ____________
True
question
Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________
Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________
question
A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value. ___________
True
question
You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet. ____________
True
question
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. ___________
False
question
Line charts are best suited for representing data that follows some nonsequential order. ___________
False
question
Interest is the amount of money being loaned. ___________
False
question
The PMT function calculates the payment required in each period to pay back the loan. ___________
True
question
Interest is the amount added to the principal by the lender. _________________________
True
question
A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value. _________________________
False
question
Pie charts are most effective with ten or fewer slices. _________________________
False
question
By default, Excel inserts a chart as an embedded chart. _________________________
True
question
When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. _________________________
False
question
The cell with the largest value contains a data marker that extends across the entire width of the cell, and the lengths of the other bars in the selected range are determined relative to that bar. _________________________
False
question
In a line chart, the data markers are the points connected by the line. _________________________
True
question
Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________
False
question
A ________ contains the actual values that are plotted on the chart.
data series
question
The ____ is the only one of the following charts to compare relative values from different categories to the whole.
pie
question
The ____ dialog box provides options for moving charts between worksheets and chart sheets.
Move Chart
question
Placing a chart in a ____ displays only the chart and no worksheet cells.
chart sheet
question
To resize an embedded chart, ____.
select the chart and drag the corner sizing handle of the selection box
question
To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.
Chart Elements
question
____provide descriptive text for the individual data markers, such as pie slices
Data labels
question
A pie slice is a data marker that represents ____ from a data series.
only one value
question
To move one slice of a pie chart away from the pie creates a(n) ____.
exploded pie chart
question
A chart that compares three set of values in a three-dimensional chart is _____.
Surface
question
The ____ identifies which data markers are associated with each data series.
legend
question
____ is the amount added to the prinicpal of a loan by the lender.
Interest
question
The FV function stands for ____.
future value
question
The amount of money being loaned is known as the ____.
principal
question
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____.
total number of payment periods
question
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the ____.
present value of the loan
question
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____.
optional arguments
question
PMT(rate, nper, pv [, fv=0] [, type=0]) The possible values for the type argument in the function above are.
0 or 1
question
In cases where a label placed outside a pie might appear farther from its slice than is easily readable, a(n) ____________________ might be added to connect the data to its corresponding slices.
question
The range of values, or ___________________, of an axis is based on the values in the data source.
scale
question
A chart that combines two or more chart types into a single graph is called a(n) ____________________ chart.