Quizalize logo
placeholder image to represent content

Analyzing and Charting Financial Data

Quiz by Lisa DeCastillia

Feel free to use or edit a copy

includes Teacher and Student dashboards

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

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
11 questions
Show answers
  • Q1
    Excel supports all of the following types of sparklines EXCEPT
    A column sparkline used for column charts
    a true/false sparkline for help making decisions
    A line sparkline for highlighting trends
    A win/loss sparkline for highlighting positive and negative values
    30s
  • Q2
    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.
    Legend
    Chart Elements
    Formatting
    Layout
    30s
  • Q3
    A pie slice is a data marker that represents ____ from a data series.
    only one value
    no more than three values
    at least one value
    no more than five values
    30s
  • Q4
    To move one slice of a pie chart away from the pie creates a(n) ____.
    exponential pie chart
    spontaneous pie chart
    exploded pie chart
    perfect pie chart
    30s
  • Q5
    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.
    Change Chart Type
    New Chart
    Modify Chart
    Alter Existing Chart
    30s
  • Q6
    When combination charts have data series with vastly different values, you can create ____ charts.
    Secondary
    Multivalued
    Multiple axis
    Dual axis
    30s
  • Q7
    The FV function stands for ____.
    Formulate value
    Future Value
    Function value
    Financial value
    30s
  • Q8
    PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure to the left, nper stands for the ____.
    number of payments per year
    total number of payments that have already been made
    total number of payment periods
    number of interest payments per year
    30s
  • Q9
    In the PMT function, pv stands for the ____.
    primary interest rate of the loan
    present value of the loan
    payments verified
    principal value of the loan
    30s
  • Q10
    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
    100% Stacked column chart
    Stacked column chart
    Clustered column chart
    Column chart
    30s
  • Q11
    Simon wants to change the chart’s border. To do this, he should select the CHART TOOLS ____ tab.
    Format
    Edit
    Layout
    Design
    30s

Teachers give this quiz to your class