Quizalize logo
placeholder image to represent content

Y7: Spreadsheet Basics

Quiz by Teran Subasinghe

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
14 questions
Show answers
  • Q1
    What is the result of the formula =A1+B1 when A1 contains 5 and B1 contains 3?
    53
    2
    15
    8
    30s
  • Q2
    Which mathematical operator is used to multiply values in a spreadsheet formula?
    /
    -
    *
    +
    30s
  • Q3
    If you have a cell named 'Total' that contains the value 20, what will be the result of the formula =Total/4?
    15
    5
    10
    25
    30s
  • Q4
    What does the formula =A2-A1 do in a spreadsheet?
    Divides A2 by A1
    Multiplies A1 and A2
    Subtracts the value in A1 from the value in A2
    Adds A1 and A2
    30s
  • Q5
    If cell B3 contains the value 10 and cell B4 contains the value 2, what is the result of the formula =B3*B4?
    8
    12
    20
    5
    30s
  • Q6
    In a spreadsheet, what happens if you use the formula =SUM(A1:A3)?
    It subtracts A3 from A1
    It multiplies the values in A1, A2, and A3
    It adds the values in cells A1, A2, and A3
    It finds the average of A1, A2, and A3
    30s
  • Q7
    What does the formula =AVERAGE(C1:C5) calculate?
    The minimum value in C1 to C5
    The sum of the values in C1 to C5
    The maximum value in C1 to C5
    The average of the values in cells C1 to C5
    30s
  • Q8
    If you input the formula =B1/B2 in a spreadsheet and B1 has the value 50 while B2 has the value 5, what will be the result?
    10
    2
    55
    25
    30s
  • Q9
    What is the correct operator for subtracting values in a spreadsheet formula?
    -
    +
    /
    *
    30s
  • Q10
    What does the formula =B3+B4+B5 do in a spreadsheet?
    It finds the minimum value in B3, B4, and B5
    It adds the values in cells B3, B4, and B5
    It calculates the product of B3, B4, and B5
    It subtracts B4 and B5 from B3
    30s
  • Q11
    Which of the following can you use a spreadsheet for?
    Creating a budget plan
    Playing a video game
    Drawing a picture
    Writing a story
    30s
  • Q12
    Which feature of a spreadsheet allows you to create a visual representation of data?
    Cell
    Chart
    Header
    Font
    30s
  • Q13
    Which of the following is a common way to organize data in a spreadsheet?
    As a story
    In a circle
    Using rows and columns
    By colors only
    30s
  • Q14
    In a spreadsheet, what does the term 'cell' refer to?
    A color in the spreadsheet
    A type of formula
    A chart that displays data
    An individual box in the grid where data can be entered
    30s

Teachers give this quiz to your class