Quizalize logo
placeholder image to represent content

Excel Unit 7

Quiz by Jennifer Michaels

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
  • view complete results in the Gradebook and Mastery Dashboards
  • 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
9 questions
Show answers
  • Q1
    Tables include ________________________ by default. This is shown by the drop down arrows in the column headings.
    a total row
    number formatting
    sorting
    filtering
    30s
  • Q2
    What is the purpose of a pivot table?
    To summarize large quantities of data into a meaningful and useful form
    To confuse poor, unsuspecting students
    To flip the rows and columns
    To create a chart that you can use in reports
    30s
  • Q3
    One of the benefits of formatting your data as a table is that it lets you easily sort and filter your data.
    False
    True
    30s
  • Q4
    When you want to sort on more than one column in your worksheet you must
    Use Custom Sort
    Sort the first column, then go back and sort the second column
    Filter on the first column and sort the second
    You can't sort on more than one column
    30s
  • Q5
    You always have to print your entire worksheet.
    True
    False
    30s
  • Q6
    If you have a spreadsheet that is more than one page long, you can use _________________ to have the column headings print on all pages
    Print Titles
    Margins
    Print Area
    Sorting
    30s
  • Q7
    _________________________ lets you print a subsection of your spreadsheet
    Print Titles
    Print Area
    Margins
    Orientation
    30s
  • Q8
    If you want to pull a subset of data from a column of data that is formatted consistently (for example last name from a column of email addresses), you can use ___________________________________.
    Flash Fill
    A Text Function
    The Data Range
    Copy Data
    30s
  • Q9
    Once you set a Pivot Table up you can't change the fields that it is based on.
    True
    False
    30s

Teachers give this quiz to your class