placeholder image to represent content

Spreadsheet Formula

Quiz by Ms J. Davies

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