placeholder image to represent content

Recap 3

Quiz by Paul

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
12 questions
Show answers
  • Q1
    Which function is used to calculate the sum of a range of cells in a spreadsheet?
    MAX
    SUM
    AVERAGE
    COUNT
    30s
  • Q2
    What 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
  • Q3
    What function would you use to find the largest value in a range of cells?
    SUM
    MIN
    MAX
    AVERAGE
    30s
  • Q4
    Which formula would you use to find the smallest number in a range of cells?
    AVERAGE
    MAX
    MIN
    SUM
    30s
  • Q5
    What 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+B1
    30s
  • Q6
    How do you multiply the values in cells C1 and D1 in a spreadsheet?
    =PRODUCT(C1+D1)
    =C1/D1
    =C1*D1
    =MULTIPLY(C1:D1)
    30s
  • Q7
    What 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
  • Q8
    Which of the following is a way to change the background color of a cell in a spreadsheet?
    Typing a color name in the cell
    Adding an image to the cell
    Using the Fill Color option in the toolbar
    Using a formula to change color
    30s
  • Q9
    Which feature allows you to display data in a vertical format within a spreadsheet cell?
    Merge
    Orientation
    Filter
    Freeze
    30s
  • Q10
    What does the 'Merge Cells' feature do in a spreadsheet?
    Aligns text to the right
    Combines multiple selected cells into one single cell
    Changes the font style of the cells
    Splits a cell into multiple cells
    30s
  • Q11
    Which of the following is a valid way to adjust the width of a column in a spreadsheet?
    Using the 'Format' menu to adjust width
    Dragging the right edge of the column header
    Typing the width value in the cell
    Adding more rows
    30s
  • Q12
    Which keyboard shortcut is commonly used to copy selected cells in a spreadsheet?
    Ctrl + V
    Ctrl + C
    Ctrl + A
    Ctrl + X
    30s

Teachers give this quiz to your class