Quizalize logo
placeholder image to represent content

Revision session on spreadsheet functions and scratch programming

Quiz by Paul

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
17 questions
Show answers
  • Q1
    Which function in a spreadsheet adds up a range of cells?
    COUNT
    AVERAGE
    SUM
    MAX
    30s
  • Q2
    In Scratch programming, which block is used to repeat a set of instructions multiple times?
    forever
    if
    repeat
    wait
    30s
  • Q3
    What formula would you use to find the average of numbers in cells A1 to A5 in a spreadsheet?
    SUM(A1:A5)
    AVERAGE(A1:A5)
    MIN(A1:A5)
    COUNT(A1:A5)
    30s
  • Q4
    Which Scratch block would you use to make a sprite move forward a certain number of steps?
    hide
    wait
    turn
    move
    30s
  • Q5
    In a spreadsheet, which function would you use to find the highest number in a range of cells?
    MAX
    MIN
    SUM
    AVERAGE
    30s
  • Q6
    In Scratch, which block would you use to check if a condition is true or false?
    repeat
    wait
    if
    broadcast
    30s
  • Q7
    What function would you use in a spreadsheet to count the number of cells that contain numbers in a range?
    AVERAGE
    MAX
    COUNT
    SUM
    30s
  • Q8
    In Scratch programming, which block is used to get user input through a prompt?
    ask
    when clicked
    broadcast
    say
    30s
  • Q9
    What is the primary purpose of the 'forever' block in Scratch programming?
    To repeat actions indefinitely
    To stop the program
    To create a variable
    To make a sprite jump
    30s
  • Q10
    Which of the following functions in a spreadsheet calculates the total of a range of numbers?
    SUM
    MIN
    AVERAGE
    COUNT
    30s
  • Q11
    In Scratch programming, what is the purpose of a 'sprite'?
    A character or object that performs actions
    A sound effect
    A coding block
    A type of background
    30s
  • Q12
    What does the 'IF' block do in Scratch programming?
    It plays a sound
    It changes the background
    It checks a condition and performs actions based on whether it's true or false
    It creates a new sprite
    30s
  • Q13
    Which function in a spreadsheet would you use to find the average of a set of numbers?
    SUM
    MAX
    AVERAGE
    TOTAL
    30s
  • Q14
    In Scratch, what does the 'repeat' block do?
    It changes colors randomly
    It adds new sprites
    It loops a set of actions a specified number of times
    It stops the program
    30s
  • Q15
    In a spreadsheet, which function would you use to count how many cells in a range contain numbers?
    COUNT
    AVERAGE
    MAX
    SUM
    30s

Teachers give this quiz to your class