Question 1

What formula would you use in Google Sheets to add the values in cells A1 and A2?

Accepted Answer

=A1+A2

Answer

=A1-A2

Answer

=A1*A2

Answer

=A1/A2

Question 2

Which formula would return the average of the numbers in cells B1 to B10 in Google Sheets?

Accepted Answer

=AVERAGE(B1:B10)

Answer

=SUM(B1:B10)

Answer

=COUNT(B1:B10)

Answer

=MAX(B1:B10)

Question 3

What formula is used to find the maximum value in a range of cells from C1 to C5 in Google Sheets?

Accepted Answer

=MAX(C1:C5)

Answer

=MIN(C1:C5)

Answer

=SUM(C1:C5)

Answer

=AVERAGE(C1:C5)

Question 4

What formula do you use to find the total sum of the values in cells G1 to G15 in Google Sheets?

Accepted Answer

=SUM(G1:G15)

Answer

=TOTAL(G1:G15)

Answer

=ADD(G1:G15)

Answer

=SUMIF(G1:G15)

Question 5

Which formula can you use to find the minimum value in a range of cells from H1 to H10 in Google Sheets?

Accepted Answer

=MIN(H1:H10)

Answer

=AVERAGE(H1:H10)

Answer

=LOW(H1:H10)

Answer

=SUM(H1:H10)

Question 6

What is the purpose of a repeat loop in Scratch programming?

Accepted Answer

To execute a block of code multiple times

Answer

To end the program

Answer

To pause the program

Answer

To create a new variable

Question 7

What does the order of blocks in Scratch programming determine?

Accepted Answer

The sequence in which instructions are executed

Answer

The speed of the animation

Answer

The colors of the sprites

Answer

The graphics used in the project

Question 8

What is the effect of using an 'if' block in Scratch programming?

Accepted Answer

To make decisions based on conditions

Answer

To repeat a set of instructions

Answer

To delay the program's execution

Answer

To create a new sprite

Question 9

What does the 'wait' block do in Scratch programming?

Accepted Answer

Pauses the execution of the script for a specified time

Answer

Changes the color of the stage

Answer

Saves the project automatically

Answer

Makes the sprite grow larger

Question 10

What is the function of a 'forever' loop in Scratch?

Accepted Answer

To continuously repeat a block of code indefinitely

Answer

To create a pause in the program

Answer

To change the background

Answer

To run code only once

Question 11

What happens if you place a block inside a repeat loop in Scratch?

Accepted Answer

The block will execute multiple times

Answer

The block will execute only once

Answer

The project will crash

Answer

The block will not run at all

Question 12

How can you change the direction of a sprite in Scratch?

Accepted Answer

By using the 'turn' block

Answer

By using the 'say' block

Answer

By using the 'wait' block

Answer

By using the 'repeat' block

Question 13

What is the purpose of the 'change color by' block in Scratch?

Accepted Answer

To modify a sprite's color effect

Answer

To delete the sprite

Answer

To change the sprite's size

Answer

To move the sprite to a new location

Question 14

What does the 'stop all' block do in Scratch programming?

Accepted Answer

It stops all scripts from running in the project

Answer

It changes the sprite's costume

Answer

It starts all scripts at once

Answer

It pauses the animation

Related quizzes

Related quizzes