Quizalize logo
placeholder image to represent content

Excel Lesson 12 Part 1

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
17 questions
Show answers
  • Q1
    Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?
    Bar
    Pie
    Line
    Column
    60s
  • Q2
    Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify?
    Chart Title
    Axis Title
    Gridlines
    Plot Area
    60s
  • Q3
    Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
    Rotate Table
    PivotChart
    PivotTable
    PivotDate
    60s
  • Q4
    Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
    PivotTable
    PivotDate
    PivotChart
    Rotate Table
    60s
  • Q5
    When creating a PivotTable, which are drawn in columns in the worksheet data?
    Ranges
    Fields
    Cells
    Records
    60s
  • Q6
    John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
    Format
    Analyze
    Design
    Layout
    60s
  • Q7
    John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?
    Linked Chart
    PivotChart
    Embedded Chart
    Line Chart
    60s
  • Q8
    Which of the following is the default method for summarizing data in a PivotTable?
    Sum
    Count
    Max
    Average
    60s
  • Q9
    What ribbon contains the commands used to create a chart in Excel?
    Data Ribbon
    Insert Ribbon
    Home Ribbon
    Formulas Ribbon
    60s
  • Q10
    In order to directly report the data, what must a PivotChart always be associated with?
    Range
    Worksheet
    PivotTable
    Table
    60s
  • Q11
    What graphically represents trends in plotted data and predicts future values?
    Sparkline
    Error bar
    Chartline
    Trendline
    60s
  • Q12
    What is the process of viewing a PivotTable report for a subset that meets the criterion only?
    Sorting
    Arranging
    Positioning
    Filtering
    60s
  • Q13
    Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
    Options
    Layout
    Format
    Design
    60s
  • Q14
    Which is a tiny chart that provides a visual representation of data in a worksheet cell?
    Flash point
    Sparkline
    Dataline
    Trendline
    60s
  • Q15
    Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?
    Layout
    Format
    Style
    Design
    60s

Teachers give this quiz to your class