Quizalize logo
placeholder image to represent content

Recap Google Spreadsheets EOT

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 can you use in Google Sheets to return the current date?
    CURRENT
    DATE
    TODAY
    NOW
    30s
  • Q2
    Which function would you use in Google Sheets to search for a specific value in a column and return a corresponding value from another column?
    HLOOKUP
    INDEX
    MATCH
    VLOOKUP
    30s
  • Q3
    What function would you use in Google Sheets to find the average of a range of numbers?
    COUNT
    AVERAGE
    MAX
    SUM
    30s
  • Q4
    Which function in Google Sheets is used to count the number of cells that contain numeric values?
    COUNTA
    COUNT
    SUM
    AVERAGE
    30s
  • Q5
    What function would you use in Google Sheets to concatenate (join together) two text strings?
    CONCATENATE
    JOIN
    SUM
    COMBINE
    30s
  • Q6
    Which Google Sheets function would you use to determine the total number of entries in a range, including text and numbers?
    AVERAGE
    COUNT
    SUM
    COUNTA
    30s
  • Q7
    Which formula would you use to add the values in cells A1 to A5 in Google Sheets?
    SUM(A1:A5)
    ADD(A1:A5)
    TOTAL(A1:A5)
    SUMMATION(A1:A5)
    30s
  • Q8
    What function would you use to find the maximum value in a range of cells in Google Sheets?
    HIGHEST
    MAX
    MAXIMUM
    TOP
    30s
  • Q9
    What is the correct formula to find the smallest number in the range B1 to B10 in Google Sheets?
    SMALLEST(B1:B10)
    LEAST(B1:B10)
    MIN(B1:B10)
    MINIMUM(B1:B10)
    30s
  • Q10
    In Google Spreadsheets, which function would you use to find the sum of all cells in the range A1:A10 that are greater than 5?
    COUNTIF(A1:A10,">5")
    AVERAGEIF(A1:A10,">5")
    SUM(A1:A10)
    SUMIF(A1:A10,">5")
    30s
  • Q11
    What is the correct formula to find the average of values in the range C1:C15 that are less than or equal to 10?
    COUNTIF(C1:C15,"<=10")
    SUMIF(C1:C15,"<=10")
    AVERAGEIF(C1:C15,"<=10")
    AVERAGE(C1:C15)
    30s
  • Q12
    In Google Spreadsheets, which function would you use to sum all numeric values in the range D1:D30 that are exactly equal to 100?
    SUM(D1:D30)
    AVERAGEIF(D1:D30,"=100")
    SUMIF(D1:D30,"=100")
    COUNTIF(D1:D30,"=100")
    30s
  • Q13
    Which function would you use in Google Spreadsheets to find the number of cells in the range E1:E25 that are greater than 50?
    COUNTIF(E1:E25,">50")
    SUMIF(E1:E25,">50")
    COUNT(E1:E25)
    AVERAGEIF(E1:E25,">50")
    30s
  • Q14
    In Google Spreadsheets, how can you calculate the average of values in the range F1:F10 that are not equal to zero?
    AVERAGE(F1:F10)
    SUMIF(F1:F10,"<>0")
    COUNTIF(F1:F10,"<>0")
    AVERAGEIF(F1:F10,"<>0")
    30s
  • Q15
    Which function would you use in Google Sheets to find the total sales for a specific product from a sales dataset?
    SUMIFS
    AVERAGEIFS
    SUMIF
    COUNTIFS
    30s

Teachers give this quiz to your class