Quizalize logo
placeholder image to represent content

Spreadsheets and Scratch 2

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
14 questions
Show answers
  • Q1
    What formula would you use in Google Sheets to add the values in cells A1 and A2?
    =A1+A2
    =A1-A2
    =A1*A2
    =A1/A2
    30s
  • Q2
    Which formula would return the average of the numbers in cells B1 to B10 in Google Sheets?
    =SUM(B1:B10)
    =AVERAGE(B1:B10)
    =COUNT(B1:B10)
    =MAX(B1:B10)
    30s
  • Q3
    What formula is used to find the maximum value in a range of cells from C1 to C5 in Google Sheets?
    =MIN(C1:C5)
    =SUM(C1:C5)
    =AVERAGE(C1:C5)
    =MAX(C1:C5)
    30s
  • Q4
    What formula do you use to find the total sum of the values in cells G1 to G15 in Google Sheets?
    =TOTAL(G1:G15)
    =ADD(G1:G15)
    =SUMIF(G1:G15)
    =SUM(G1:G15)
    30s
  • Q5
    Which formula can you use to find the minimum value in a range of cells from H1 to H10 in Google Sheets?
    =AVERAGE(H1:H10)
    =LOW(H1:H10)
    =MIN(H1:H10)
    =SUM(H1:H10)
    30s
  • Q6
    What is the purpose of a repeat loop in Scratch programming?
    To execute a block of code multiple times
    To end the program
    To pause the program
    To create a new variable
    30s
  • Q7
    What does the order of blocks in Scratch programming determine?
    The speed of the animation
    The colors of the sprites
    The graphics used in the project
    The sequence in which instructions are executed
    30s
  • Q8
    What is the effect of using an 'if' block in Scratch programming?
    To repeat a set of instructions
    To delay the program's execution
    To make decisions based on conditions
    To create a new sprite
    30s
  • Q9
    What does the 'wait' block do in Scratch programming?
    Pauses the execution of the script for a specified time
    Changes the color of the stage
    Saves the project automatically
    Makes the sprite grow larger
    30s
  • Q10
    What is the function of a 'forever' loop in Scratch?
    To continuously repeat a block of code indefinitely
    To create a pause in the program
    To change the background
    To run code only once
    30s
  • Q11
    What happens if you place a block inside a repeat loop in Scratch?
    The block will execute only once
    The project will crash
    The block will execute multiple times
    The block will not run at all
    30s
  • Q12
    How can you change the direction of a sprite in Scratch?
    By using the 'say' block
    By using the 'turn' block
    By using the 'wait' block
    By using the 'repeat' block
    30s
  • Q13
    What is the purpose of the 'change color by' block in Scratch?
    To delete the sprite
    To modify a sprite's color effect
    To change the sprite's size
    To move the sprite to a new location
    30s
  • Q14
    What does the 'stop all' block do in Scratch programming?
    It changes the sprite's costume
    It starts all scripts at once
    It pauses the animation
    It stops all scripts from running in the project
    30s

Teachers give this quiz to your class