Deck 10: Analyzing and Charting Financial Data

Full screen (f)
exit full mode
Question
A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________
Use Space or
up arrow
down arrow
to flip the card.
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._________________________
Question
When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________
Question
Line charts are best suited for representing data that follows some nonsequential order.___________
Question
In a line chart,the data markers are the points connected by the line._________________________
Question
Interest is the amount of money being loaned.___________
Question
In pie charts,it's best to make the slice colors as similar as possible.___________
Question
Interest is the amount added to the principal by the lender._________________________
Question
A ________ contains the actual values that are plotted on the chart.

A)data source
B)data series
C)category values
D)legend
Question
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.___________
Question
Combination charts enable you to show three sets of data using the chart type that is best for each data set._________________________
Question
You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________
Question
A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.___________
Question
Every chart contains elements that can be formatted,added to the chart,or removed from the chart.__________
Question
Each slice in a pie chart represents a single value from a data series.____________
Question
Pie charts are most effective with ten or fewer slices._________________________
Question
Excel charts are either placed in their own chart sheets or embedded in a worksheet.____________
Question
By default,Excel inserts a chart as an embedded chart._________________________
Question
You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________
Question
The PMT function calculates the payment required in each period to pay back the loan.___________
Question
Excel supports all of the following  types of sparklines EXCEPT ____.

A)A win/loss sparkline for highlighting positive and negative values
B)A column sparkline used for column charts
C)A line sparkline for highlighting trends
D)a true/false sparkline for help making decisions
Question
To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

A)CREATE
B)VIEW
C)LAYOUT
D)DESIGN
Question
Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

A)espionage
B)clutter
C)confusion
D)junk
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.

A)Legend
B)Chart Elements
C)Formatting
D)Layout
Question
You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

A)Format Data Labels
B)Format Legend
C)Format Chart Area
D)Format Axis
Question
To move one slice of a pie chart away from the pie creates a(n)____.

A)spontaneous pie chart
B)perfect pie chart
C)exploded pie chart
D)exponential pie chart
Question
You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

A)Change Chart Type
B)New Chart
C)Alter Existing Chart
D)Modify Chart
Question
The ____ is the only one of the following charts to compare relative values from different categories to the whole.

A)pie
B)column
C)line
D)area
Question
Category values are usually located in the ____ of the data source.

A)first row
B)first column
C)either a or b
D)neither a nor b
Question
To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

A)CHART TOOLS LAYOUT
B)CHART TOOLS DESIGN
C)INSERT
D)HOME
Question
To resize an embedded chart,____.

A)select the chart and drag the corner sizing handle of the selection box
B)right click the chart and then click Resize on the shortcut menu
C)select the chart and press Tab
D)both a and b
Question
A pie slice is a data marker that represents ____ from a data series.

A)only one value
B)at least one value
C)no more than three values
D)no more than five values
Question
The range of values or _______,of an axis is based on the values in the data source.

A)scale
B)defined range
C)series
D)length
Question
A chart sheet can contain ____.

A)only one chart
B)one or two charts
C)one to four charts
D)one to six charts
Question
____provide descriptive text for the individual data markers,such as pie slices

A)Asset labels
B)Legend values
C)Data labels
D)Leader lines
Question
Which of the following shows the correct order of steps for adding a data series to a chart?

A)Select the chart, Click the Add button, Click the Select Data button, Select the range
B)Select the chart, Click the Select Data button, Click the Add button, Select the range
C)Select the range, Click the Select Data button, Click the Add button, Select the chart
D)Select the range, Select the chart, Click the Select Data button, Click the Add button
Question
The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

A)INSERT and DESIGN
B)DESIGN and FORMAT
C)INSERT and FORMAT
D)FORMAT and PRINT
Question
Placing a chart in a ____ displays only the chart and no worksheet cells.

A)new worksheet
B)tabbed view
C)graph display
D)chart sheet
Question
The ____ dialog box provides options for moving charts between worksheets and chart sheets.

A)Insert New
B)Tab
C)Move Chart
D)Change Chart
Question
A chart that compares three set of values in a three-dimensional chart is _____.

A)Stock
B)Radar
C)Surface
D)Scatter
Question
____ is the amount added to the prinicpal of a loan by the lender.

A)Rate
B)Simple
C)Interest
D)Maximum
Question
The FV function stands for ____.

A)function value
B)future value
C)financial value
D)formulated value
Question
It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

A)a legend
B)major tick marks
C)colors
D)more numbers
Question
The ____ identifies which data markers are associated with each data series.

A)x-axis
B)y-axis
C)chart area
D)legend
Question
Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

A)line chart
B)exploded pie chart
C)scatter chart
D)banded chart
Question
Simon has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

A)Delete parts of the data
B)Delete the legend
C)Delete the title
D)Overlay the legend in areas without data
Question
In the figure above,pv stands for the ____.

A)payments verified
B)principal value of the loan
C)present value of the loan
D)primary interest rate of the loan
Question
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.

A)clustered column chart
B)stacked column chart
C)100% stacked column chart
D)column chart
Question
Since Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

A)paste her chart in as a picture
B)do nothing since charts in Excel remain linked to data sources
C)manually adjust data in a chart
D)create a new chart each time she modifies her data
Question
Since it's important for Mya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Mya? _____

A)bar
B)column
C)scatter
D)pie
Question
Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

A)select the chart
B)hold down the SHIFT key
C)adjust the sizing handles
D)move the mouse pointer to the center of the chart.
Question
Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

A)search
B)filter
C)find
D)examine
Question
In the figure above,nper stands for the ____.

A)total number of payment periods
B)total number of payments that have already been made
C)number of payments per year
D)number of interest payments per year
Question
The amount of money being loaned is known as the ____.

A)mortgage
B)principal
C)loan amount
D)proposed principal
Question
Mya has asked for your advice.A colleague told her to remove the legend from her pie chart because it takes up too much space.What would be a better piece of advice to give Mya?

A)Resize the legend to be as tiny as possible.
B)Remove data from the legend.
C)Overlay the legend on a part of the chart that's empty.
D)You agree with the colleague; Mya should remove the legend.
Question
When combination charts have data series with vastly different values,you can create ____ charts.

A)dual axis
B)secondary
C)multivalued
D)multiple axis
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
In the figure above,fv and type are ____.

A)financial functions
B)required arguments
C)comparison operators
D)optional arguments
Question
Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

A)FORMAT
B)EDIT
C)DESIGN
D)LAYOUT
Question
The possible values for the type argument in the function above are.

A)0 or null
B)0 or 1
C)0, 1, or 2
D)0, 1, 2, or 3
Question
A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.
Question
Each value from a data series is represented by a ________.
Question
An _______ chart takes up less space than a chart sheet.
Question
The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.
Question
Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Question
Describe the some of the concepts and definitions associated with loans before using a PMT function.
Question
The range of values,or ___________________,of an axis is based on the values in the data source.
Question
A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.
Question
Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.
Question
Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.
Question
A ____________ displays data values as columns with the height of each column based on the data value.
Question
The goal of a ______ is to convey the maximum amount of information within a very small space.
Question
______ are horizontal and vertical lines that help you compare data and category values.
Question
To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.
Question
You can add ___________________ to identify smaller intervals between the major tick marks.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/75
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 10: Analyzing and Charting Financial Data
1
A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________
False - data
2
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 - data bar
3
When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________
False - location
4
Line charts are best suited for representing data that follows some nonsequential order.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
5
In a line chart,the data markers are the points connected by the line._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
6
Interest is the amount of money being loaned.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
7
In pie charts,it's best to make the slice colors as similar as possible.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
8
Interest is the amount added to the principal by the lender._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
9
A ________ contains the actual values that are plotted on the chart.

A)data source
B)data series
C)category values
D)legend
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
10
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
11
Combination charts enable you to show three sets of data using the chart type that is best for each data set._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
12
You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
13
A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
14
Every chart contains elements that can be formatted,added to the chart,or removed from the chart.__________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
15
Each slice in a pie chart represents a single value from a data series.____________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
16
Pie charts are most effective with ten or fewer slices._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
17
Excel charts are either placed in their own chart sheets or embedded in a worksheet.____________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
18
By default,Excel inserts a chart as an embedded chart._________________________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
19
You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
20
The PMT function calculates the payment required in each period to pay back the loan.___________
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
21
Excel supports all of the following  types of sparklines EXCEPT ____.

A)A win/loss sparkline for highlighting positive and negative values
B)A column sparkline used for column charts
C)A line sparkline for highlighting trends
D)a true/false sparkline for help making decisions
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
22
To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

A)CREATE
B)VIEW
C)LAYOUT
D)DESIGN
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
23
Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

A)espionage
B)clutter
C)confusion
D)junk
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
24
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.

A)Legend
B)Chart Elements
C)Formatting
D)Layout
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
25
You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

A)Format Data Labels
B)Format Legend
C)Format Chart Area
D)Format Axis
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
26
To move one slice of a pie chart away from the pie creates a(n)____.

A)spontaneous pie chart
B)perfect pie chart
C)exploded pie chart
D)exponential pie chart
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
27
You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

A)Change Chart Type
B)New Chart
C)Alter Existing Chart
D)Modify Chart
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
28
The ____ is the only one of the following charts to compare relative values from different categories to the whole.

A)pie
B)column
C)line
D)area
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
29
Category values are usually located in the ____ of the data source.

A)first row
B)first column
C)either a or b
D)neither a nor b
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
30
To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

A)CHART TOOLS LAYOUT
B)CHART TOOLS DESIGN
C)INSERT
D)HOME
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
31
To resize an embedded chart,____.

A)select the chart and drag the corner sizing handle of the selection box
B)right click the chart and then click Resize on the shortcut menu
C)select the chart and press Tab
D)both a and b
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
32
A pie slice is a data marker that represents ____ from a data series.

A)only one value
B)at least one value
C)no more than three values
D)no more than five values
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
33
The range of values or _______,of an axis is based on the values in the data source.

A)scale
B)defined range
C)series
D)length
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
34
A chart sheet can contain ____.

A)only one chart
B)one or two charts
C)one to four charts
D)one to six charts
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
35
____provide descriptive text for the individual data markers,such as pie slices

A)Asset labels
B)Legend values
C)Data labels
D)Leader lines
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
36
Which of the following shows the correct order of steps for adding a data series to a chart?

A)Select the chart, Click the Add button, Click the Select Data button, Select the range
B)Select the chart, Click the Select Data button, Click the Add button, Select the range
C)Select the range, Click the Select Data button, Click the Add button, Select the chart
D)Select the range, Select the chart, Click the Select Data button, Click the Add button
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
37
The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

A)INSERT and DESIGN
B)DESIGN and FORMAT
C)INSERT and FORMAT
D)FORMAT and PRINT
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
38
Placing a chart in a ____ displays only the chart and no worksheet cells.

A)new worksheet
B)tabbed view
C)graph display
D)chart sheet
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
39
The ____ dialog box provides options for moving charts between worksheets and chart sheets.

A)Insert New
B)Tab
C)Move Chart
D)Change Chart
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
40
A chart that compares three set of values in a three-dimensional chart is _____.

A)Stock
B)Radar
C)Surface
D)Scatter
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
41
____ is the amount added to the prinicpal of a loan by the lender.

A)Rate
B)Simple
C)Interest
D)Maximum
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
42
The FV function stands for ____.

A)function value
B)future value
C)financial value
D)formulated value
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
43
It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

A)a legend
B)major tick marks
C)colors
D)more numbers
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
44
The ____ identifies which data markers are associated with each data series.

A)x-axis
B)y-axis
C)chart area
D)legend
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
45
Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

A)line chart
B)exploded pie chart
C)scatter chart
D)banded chart
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
46
Simon has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

A)Delete parts of the data
B)Delete the legend
C)Delete the title
D)Overlay the legend in areas without data
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
47
In the figure above,pv stands for the ____.

A)payments verified
B)principal value of the loan
C)present value of the loan
D)primary interest rate of the loan
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
48
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.

A)clustered column chart
B)stacked column chart
C)100% stacked column chart
D)column chart
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
49
Since Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

A)paste her chart in as a picture
B)do nothing since charts in Excel remain linked to data sources
C)manually adjust data in a chart
D)create a new chart each time she modifies her data
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
50
Since it's important for Mya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Mya? _____

A)bar
B)column
C)scatter
D)pie
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
51
Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

A)select the chart
B)hold down the SHIFT key
C)adjust the sizing handles
D)move the mouse pointer to the center of the chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
52
Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

A)search
B)filter
C)find
D)examine
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
53
In the figure above,nper stands for the ____.

A)total number of payment periods
B)total number of payments that have already been made
C)number of payments per year
D)number of interest payments per year
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
54
The amount of money being loaned is known as the ____.

A)mortgage
B)principal
C)loan amount
D)proposed principal
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
55
Mya has asked for your advice.A colleague told her to remove the legend from her pie chart because it takes up too much space.What would be a better piece of advice to give Mya?

A)Resize the legend to be as tiny as possible.
B)Remove data from the legend.
C)Overlay the legend on a part of the chart that's empty.
D)You agree with the colleague; Mya should remove the legend.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
56
When combination charts have data series with vastly different values,you can create ____ charts.

A)dual axis
B)secondary
C)multivalued
D)multiple axis
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
57
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.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
58
In the figure above,fv and type are ____.

A)financial functions
B)required arguments
C)comparison operators
D)optional arguments
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
59
Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

A)FORMAT
B)EDIT
C)DESIGN
D)LAYOUT
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
60
The possible values for the type argument in the function above are.

A)0 or null
B)0 or 1
C)0, 1, or 2
D)0, 1, 2, or 3
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
61
A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
62
Each value from a data series is represented by a ________.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
63
An _______ chart takes up less space than a chart sheet.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
64
The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
65
Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
66
Describe the some of the concepts and definitions associated with loans before using a PMT function.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
67
The range of values,or ___________________,of an axis is based on the values in the data source.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
68
A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
69
Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
70
Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
71
A ____________ displays data values as columns with the height of each column based on the data value.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
72
The goal of a ______ is to convey the maximum amount of information within a very small space.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
73
______ are horizontal and vertical lines that help you compare data and category values.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
74
To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
75
You can add ___________________ to identify smaller intervals between the major tick marks.
Unlock Deck
Unlock for access to all 75 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 75 flashcards in this deck.