Quizalize logo
placeholder image to represent content

Google Sheets

Quiz by Alaina Pecora

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
20 questions
Show answers
  • Q1
    True or False: Google Sheets saves your changes automatically.
    False
    True
    30s
  • Q2
    A group of cells is called a ________.
    multicell
    cell cluster
    chart
    cell range
    30s
  • Q3
    Which of the following features allows you to narrow down the data in your worksheet?
    Merge cells
    Sorting
    Relative cell references
    Filters
    30s
  • Q4
    Why would you want to freeze rows in your spreadsheet?
    To modify only the frozen rows
    To limit the data that can be entered
    To scroll while continuing to see the frozen rows
    To prevent editng
    30s
  • Q5
    Formulas should always begin with a(n) ________.
    hashtag
    equals sign
    header
    dollar sign
    30s
  • Q6
    What symbol is used to represent multiplication in a formula?
    *
    +
    -
    /
    30s
  • Q7
    What does the AVERAGE function do?
    Divides a range of values
    Adds a range of values
    Multiplies a range of values
    Returns the average of a range of values
    30s
  • Q8
    Which of the following symbols is NOT recognized as a mathematical operator within Google Sheets?
    +
    ^
    /
    X
    30s
  • Q9
    What is the difference between "edit" and "comment" access in Google Sheets?
    "Edit" and "comment" provide the same level of access to the file.
    "edit" access can only leave comments, "comment" access can make changes
    Only the file owner can leave comments or make changes
    "edit" access can make changes, "comment" access can only leave comments
    30s
  • Q10
    Which function would you use to add the values of several cells?
    MAX
    AVERAGE
    TOTAL
    SUM
    30s
  • Q11
    Which of the following is an absolute cell reference?
    A2
    #A2

    $A2

    A:2
    30s
  • Q12
    According to the order of operations, which calculation comes first in the following formula? =3^2/5+(12-3)
    3^2
    2/5
    5+12
    12-3
    30s
  • Q13
    How can you see who has access to a Google Sheets file?
    Click on the "Share" button in the toolbar.
    Open the file and look at the list of collaborators in the sidebar.
    Hover over the file's name in Google Drive and select "Share."
    Click on the "Settings" button in the toolbar.
    30s
  • Q14
    Most functions contain one or more ________ in parentheses.
    arguments
    plus signs
    sentences
    sub-functions
    30s
  • Q15
    How can you print a specific range of cells in a Google Sheets file?
    Right-click on the range of cells you want to print and select "Print."
    There is no way to print a specific range of cells in Google Sheets.
    Select the range, then click on "File" in the toolbar and select "Print."
    Select the range of cells you want to print, then click on "Print" in the toolbar.
    30s

Teachers give this quiz to your class