Quizalize logo
placeholder image to represent content

Spreadsheet Formula

Quiz by Ms J. Davies

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
8 questions
Show answers
  • Q1
    What formula calculates the sum of a range of cells in Excel?
    AVERAGE
    COUNT
    SUM
    MAX
    30s
  • Q2
    What formula returns the largest value in a range of cells in Excel?
    MAX
    SUM
    AVERAGE
    MIN
    30s
  • Q3
    What formula is used to count the number of cells in a range that meet a certain criteria in Excel?
    AVERAGEIF
    SUMIF
    MAXIF
    COUNTIF
    30s
  • Q4
    What formula is used to find the average value in a range of cells in Excel?
    COUNT
    MAX
    AVERAGE
    SUM
    30s
  • Q5
    What formula is used to round a number to a specified number of decimal places in Excel?
    AVERAGE
    ROUND
    SUM
    COUNT
    30s
  • Q6
    What formula is used to find the highest value that is less than or equal to a lookup value in a sorted table in Excel?
    VLOOKUP
    INDEX
    MATCH
    HLOOKUP
    30s
  • Q7
    What does the COUNTIF formula count?
    Cells that meet a certain criteria
    Cells with errors
    All cells within a range
    Cells with text
    30s
  • Q8
    What formula would you use to add a range of cells that meet a certain criteria?
    MAX()
    SUMIF()
    COUNTA()
    MIN()
    30s

Teachers give this quiz to your class