placeholder image to represent content

Quick Recap

Quiz by Paul

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
16 questions
Show answers
  • Q1
    What function would you use in a spreadsheet to calculate the sum of a range of cells?
    SUM
    AVERAGE
    MAX
    COUNT
    30s
  • Q2
    Which function is used to find the average value of a range of cells in a spreadsheet?
    MEDIAN
    SUM
    COUNT
    AVERAGE
    30s
  • Q3
    What function would you use to count the number of cells that contain numerical data?
    AVERAGE
    SUM
    COUNT
    MAX
    30s
  • Q4
    Which function would you use to find the highest value in a range of cells?
    MIN
    SUM
    MAX
    AVERAGE
    30s
  • Q5
    Which function allows you to search for a value in a vertical column and return a corresponding value from another column?
    SEARCH
    VLOOKUP
    HLOOKUP
    INDEX
    30s
  • Q6
    What function would you use to find the smallest value in a set of numbers within a spreadsheet?
    MIN
    AVERAGE
    SUM
    MAX
    30s
  • Q7
    Which function would you use to check if a condition is true or false in a spreadsheet?
    AND
    NOT
    OR
    IF
    30s
  • Q8
    In a spreadsheet, which formula would you use to count the number of cells in a range that meet multiple criteria?
    AVERAGEIF
    COUNTIFS
    COUNTIF
    SUMIF
    30s
  • Q9
    Which function would you use to calculate the average of a range of cells that meet specific criteria?
    COUNTIFS
    AVERAGEIF
    SUMIFS
    AVERAGEIFS
    30s
  • Q10
    When formatting a spreadsheet, which of the following options can you use to change the appearance of text?
    Font
    Cell Address
    Formula Bar
    Data Range
    30s
  • Q11
    What is the purpose of the COUNTIF function in a spreadsheet?
    To format cells based on conditions
    To sum values in a range
    To count the number of cells that meet a single criterion
    To average values in a range
    30s
  • Q12
    Which option in a spreadsheet would allow you to visually represent data in a graph or chart?
    Sort Data
    Insert Chart
    Add Formula
    Format Cells
    30s
  • Q13
    In a spreadsheet, what does the function SUMIFS do?
    Calculates the average of values
    Formats cells based on conditions
    Sums values based on multiple criteria
    Counts cells based on one criterion
    30s
  • Q14
    Which of the following formats can you apply to a cell to display numbers as currency in a spreadsheet?
    Text Format
    Currency Format
    Date Format
    Percentage Format
    30s
  • Q15
    In which part of a spreadsheet can you view and edit the formula of a selected cell?
    Status Bar
    Cell Grid
    Menu Bar
    Formula Bar
    30s

Teachers give this quiz to your class