Spreadsheet Formula
Quiz by Ms J. Davies
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
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
8 questions
Show answers
- Q1What formula calculates the sum of a range of cells in Excel?AVERAGECOUNTSUMMAX30s
- Q2What formula returns the largest value in a range of cells in Excel?MAXSUMAVERAGEMIN30s
- Q3What formula is used to count the number of cells in a range that meet a certain criteria in Excel?AVERAGEIFSUMIFMAXIFCOUNTIF30s
- Q4What formula is used to find the average value in a range of cells in Excel?COUNTMAXAVERAGESUM30s
- Q5What formula is used to round a number to a specified number of decimal places in Excel?AVERAGEROUNDSUMCOUNT30s
- Q6What formula is used to find the highest value that is less than or equal to a lookup value in a sorted table in Excel?VLOOKUPINDEXMATCHHLOOKUP30s
- Q7What does the COUNTIF formula count?Cells that meet a certain criteriaCells with errorsAll cells within a rangeCells with text30s
- Q8What formula would you use to add a range of cells that meet a certain criteria?MAX()SUMIF()COUNTA()MIN()30s