
Recap 3
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
12 questions
Show answers
- Q1Which function is used to calculate the sum of a range of cells in a spreadsheet?MAXSUMAVERAGECOUNT30s
- Q2What formula would you use to find the average value of numbers in cells A1 to A10?SUM(A1:A10)MAX(A1:A10)COUNT(A1:A10)AVERAGE(A1:A10)30s
- Q3What function would you use to find the largest value in a range of cells?SUMMINMAXAVERAGE30s
- Q4Which formula would you use to find the smallest number in a range of cells?AVERAGEMAXMINSUM30s
- Q5What formula would you use to add the values in cells A1 and B1 in a spreadsheet?=SUM(A1, B1)=ADD(A1:B1)=A1*B1=A1+B130s
- Q6How do you multiply the values in cells C1 and D1 in a spreadsheet?=PRODUCT(C1+D1)=C1/D1=C1*D1=MULTIPLY(C1:D1)30s
- Q7What formula would you use to divide the value in cell E5 by the value in cell F5?=E5*F5=E5-F5=E5/F5=DIVIDE(E5,F5)30s
- Q8Which of the following is a way to change the background color of a cell in a spreadsheet?Typing a color name in the cellAdding an image to the cellUsing the Fill Color option in the toolbarUsing a formula to change color30s
- Q9Which feature allows you to display data in a vertical format within a spreadsheet cell?MergeOrientationFilterFreeze30s
- Q10What does the 'Merge Cells' feature do in a spreadsheet?Aligns text to the rightCombines multiple selected cells into one single cellChanges the font style of the cellsSplits a cell into multiple cells30s
- Q11Which of the following is a valid way to adjust the width of a column in a spreadsheet?Using the 'Format' menu to adjust widthDragging the right edge of the column headerTyping the width value in the cellAdding more rows30s
- Q12Which keyboard shortcut is commonly used to copy selected cells in a spreadsheet?Ctrl + VCtrl + CCtrl + ACtrl + X30s