Quizalize logo
placeholder image to represent content

Spreadsheets and Scratch 4

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
20 questions
Show answers
  • Q1
    What formula would you use in a spreadsheet to add the values in cells A1 and A2?
    =A1/A2
    =A1-A2
    =A1+A2
    =A1*A2
    30s
  • Q2
    If you want to find the average of the numbers in cells B1 to B5, which formula should you use?
    =AVERAGE(B1:B5)
    =AVG(B1:B5)
    =TOTAL(B1:B5)
    =SUM(B1:B5)/5
    30s
  • Q3
    Which function would you use to find the highest number in a range of cells from C1 to C10?
    =MAX(C1:C10)
    =TOP(C1:C10)
    =MIN(C1:C10)
    =HIGH(C1:C10)
    30s
  • Q4
    What formula would you use to calculate the total of numbers in cells D1, D2, and D3?
    =ADD(D1:D3)
    =SUM(D1:D3)
    =TOTAL(D1,D2,D3)
    =SUM(D1+D2+D3)
    30s
  • Q5
    To count how many cells are filled with numbers in the range E1 to E10, which formula should you use?
    =TOTAL(E1:E10)
    =COUNT(E1:E10)
    =SUM(E1:E10)
    =NUMCOUNT(E1:E10)
    30s
  • Q6
    If you want to find the smallest number in a range of cells from H1 to H10, which formula should you use?
    =SMALLEST(H1:H10)
    =MINIMUM(H1:H10)
    =MIN(H1:H10)
    =LOWEST(H1:H10)
    30s
  • Q7
    In Scratch, what is the purpose of a variable?
    To change the background
    To create graphics
    To store and keep track of data
    To control the sound
    30s
  • Q8
    What does the term 'sequence' mean in Scratch programming?
    A background animation
    A specific order in which blocks are executed
    A collection of sounds
    A type of sprite
    30s
  • Q9
    Which block would you use to change the value of a variable in Scratch?
    Hide [variable]
    Show [variable]
    Set [variable] to [number]
    Change [variable] by [number]
    30s
  • Q10
    What type of programming language is Scratch considered to be?
    Visual programming language
    Compiled programming language
    Text-based programming language
    Markup language
    30s
  • Q11
    In Scratch, which block would you use to begin a script that runs when the green flag is clicked?
    When Green Flag clicked
    When I receive [message]
    When space key pressed
    Forever
    30s
  • Q12
    What is the purpose of the 'If...Then' block in Scratch?
    To loop a section of code
    To create a variable
    To execute code based on a condition
    To end a program
    30s
  • Q13
    What is a 'sprite' in Scratch?
    A programming block
    A type of background
    A character or object that performs actions
    A sound effect
    30s
  • Q14
    What does the 'Set [variable] to [number]' block do in Scratch?
    It assigns a specific value to a variable
    It deletes the variable
    It increases the variable value
    It displays the variable value
    30s
  • Q15
    Which block would you use to repeat an action a specific number of times in Scratch?
    Forever
    When I receive [message]
    Repeat [number] times
    Repeat until [condition]
    30s

Teachers give this quiz to your class