Analyzing and Charting Financial Data
Quiz by Lisa DeCastillia
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
11 questions
Show answers
- Q1Excel supports all of the following types of sparklines EXCEPTA column sparkline used for column chartsa true/false sparkline for help making decisionsA line sparkline for highlighting trendsA win/loss sparkline for highlighting positive and negative values30s
- Q2To 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.LegendChart ElementsFormattingLayout30s
- Q3A pie slice is a data marker that represents ____ from a data series.only one valueno more than three valuesat least one valueno more than five values30s
- Q4To move one slice of a pie chart away from the pie creates a(n) ____.exponential pie chartspontaneous pie chartexploded pie chartperfect pie chart30s
- Q5You 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.Change Chart TypeNew ChartModify ChartAlter Existing Chart30s
- Q6When combination charts have data series with vastly different values, you can create ____ charts.SecondaryMultivaluedMultiple axisDual axis30s
- Q7The FV function stands for ____.Formulate valueFuture ValueFunction valueFinancial value30s
- Q8PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure to the left, nper stands for the ____.number of payments per yeartotal number of payments that have already been madetotal number of payment periodsnumber of interest payments per year30s
- Q9In the PMT function, pv stands for the ____.primary interest rate of the loanpresent value of the loanpayments verifiedprincipal value of the loan30s
- Q10The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series100% Stacked column chartStacked column chartClustered column chartColumn chart30s
- Q11Simon wants to change the chart’s border. To do this, he should select the CHART TOOLS ____ tab.FormatEditLayoutDesign30s