Quizalize logo
placeholder image to represent content

Excel Lesson 12 Part 2

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
18 questions
Show answers
  • Q1
    Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include?
    Axis
    Chart title
    Legend
    Data label
    60s
  • Q2
    Leigh designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
    Axis
    Chart title
    Legend
    Data label
    60s
  • Q3
    What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
    Slivers
    Movers
    Partials
    Slicers
    60s
  • Q4
    Joe has created a PivotChart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
    Legend fields
    Values
    Report filter
    Axis fields
    60s
  • Q5
    Efram would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?
    Line
    Bar
    Column
    Pie
    60s
  • Q6
    Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
    Layout
    Design
    Format
    Style
    60s
  • Q7
    Jason wants to identify the exact value that each column in his chart represents. Which option should he choose?
    Labels
    Pictures
    Arrows
    Gridlines
    60s
  • Q8
    What term refers to an Excel Chart with offset pieces?
    Separated
    Shattered
    Exploded
    Detached
    60s
  • Q9
    Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
    Analyze
    Design
    Format
    Layout
    60s
  • Q10
    Jeff would like to display the count of employee last names on the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly?
    Axis fields
    Values
    Legend fields
    Report filter
    60s
  • Q11
    Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
    Layout
    Design
    Format
    Style
    60s
  • Q12
    What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
    Decrease/Increase
    Reduce/Add
    Collapse/Expand
    Subtract/Add
    60s
  • Q13
    What can you use to easily filter PivotTables and cube functions interactively in a worksheet?
    Sliver
    Slicer
    Division
    Cutter
    60s
  • Q14
    What is typically included in the range of data selected to create a chart?
    Numeric data, totals, and titles
    Numeric data and totals only
    Numeric data and titles
    Titles only
    60s
  • Q15
    Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
    Design
    Layout
    Format
    Analyze
    60s

Teachers give this quiz to your class