
Quick Recap
Quiz by Paul
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
16 questions
Show answers
- Q1What function would you use in a spreadsheet to calculate the sum of a range of cells?SUMAVERAGEMAXCOUNT30s
- Q2Which function is used to find the average value of a range of cells in a spreadsheet?MEDIANSUMCOUNTAVERAGE30s
- Q3What function would you use to count the number of cells that contain numerical data?AVERAGESUMCOUNTMAX30s
- Q4Which function would you use to find the highest value in a range of cells?MINSUMMAXAVERAGE30s
- Q5Which function allows you to search for a value in a vertical column and return a corresponding value from another column?SEARCHVLOOKUPHLOOKUPINDEX30s
- Q6What function would you use to find the smallest value in a set of numbers within a spreadsheet?MINAVERAGESUMMAX30s
- Q7Which function would you use to check if a condition is true or false in a spreadsheet?ANDNOTORIF30s
- Q8In a spreadsheet, which formula would you use to count the number of cells in a range that meet multiple criteria?AVERAGEIFCOUNTIFSCOUNTIFSUMIF30s
- Q9Which function would you use to calculate the average of a range of cells that meet specific criteria?COUNTIFSAVERAGEIFSUMIFSAVERAGEIFS30s
- Q10When formatting a spreadsheet, which of the following options can you use to change the appearance of text?FontCell AddressFormula BarData Range30s
- Q11What is the purpose of the COUNTIF function in a spreadsheet?To format cells based on conditionsTo sum values in a rangeTo count the number of cells that meet a single criterionTo average values in a range30s
- Q12Which option in a spreadsheet would allow you to visually represent data in a graph or chart?Sort DataInsert ChartAdd FormulaFormat Cells30s
- Q13In a spreadsheet, what does the function SUMIFS do?Calculates the average of valuesFormats cells based on conditionsSums values based on multiple criteriaCounts cells based on one criterion30s
- Q14Which of the following formats can you apply to a cell to display numbers as currency in a spreadsheet?Text FormatCurrency FormatDate FormatPercentage Format30s
- Q15In which part of a spreadsheet can you view and edit the formula of a selected cell?Status BarCell GridMenu BarFormula Bar30s