Quizalize logo
placeholder image to represent content

Recap Google Spreadsheets

Quiz by Paul

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
25 questions
Show answers
  • Q1
    What function would you use in Google Sheets to calculate the average of a range of numbers?
    AVERAGE
    MAX
    COUNT
    SUM
    30s
  • Q2
    Which function would you use to find the highest number in a range in Google Sheets?
    AVERAGE
    MIN
    MAX
    SUM
    30s
  • Q3
    What formula would you use to count the number of cells that contain numbers in a range in Google Sheets?
    AVERAGE
    COUNTA
    COUNT
    SUM
    30s
  • Q4
    Which function can you use in Google Sheets to find the minimum value in a range of cells?
    MIN
    MAX
    COUNT
    AVERAGE
    30s
  • Q5
    Which function would you use to return the number of non-empty cells in a range in Google Sheets?
    COUNTA
    SUM
    COUNT
    COUNTIF
    30s
  • Q6
    Which formula would you use to add numbers in cells B1 and B2 in Google Sheets?
    ADD(B1, B2)
    SUM(B1, B2)
    B1 + B2
    TOTAL(B1, B2)
    30s
  • Q7
    What function would you use to count how many cells in the range C1 to C10 contain numeric values?
    SUM(C1:C10)
    COUNTA(C1:C10)
    COUNT(C1:C10)
    TOTAL(C1:C10)
    30s
  • Q8
    Which formula would you use to find the difference between the values in cells F1 and F2 in Google Sheets?
    MINUS(F1, F2)
    F1 - F2
    SUBTRACT(F1, F2)
    DIFFERENCE(F1, F2)
    30s
  • Q9
    What function would you use to calculate the square root of a number in cell H1 in Google Sheets?
    ROOT(H1)
    POWER(H1, 0.5)
    SQUARE(H1)
    SQRT(H1)
    30s
  • Q10
    What function can you use in Google Sheets to find a value in a table based on a key?
    SUM
    HLOOKUP
    VLOOKUP
    MATCH
    30s
  • Q11
    In the VLOOKUP function, what does the 'range' parameter specify?
    The table from which to retrieve data
    The number of rows to return
    The name of the spreadsheet
    The key to search for
    30s
  • Q12
    What does the 'col_index_num' argument in the VLOOKUP function specify?
    The total number of columns
    The column number from which to return the value
    The row number to search in
    The search key
    30s
  • Q13
    What will VLOOKUP return if it does not find the specified key?
    An #N/A error
    The last value in the column
    A blank cell
    A zero
    30s
  • Q14
    What is a common use of the VLOOKUP function in Google Sheets?
    To create charts
    To send emails
    To format text
    To retrieve information from a database
    30s
  • Q15
    Which of the following is a requirement for the first column in a range used with VLOOKUP?
    It can contain duplicates
    It must be the last column
    The first column must contain unique keys
    It must be sorted in descending order
    30s

Teachers give this quiz to your class