Question 1

What function would you use to find the average of a range of numbers in Google Sheets?

Accepted Answer

AVERAGE

Answer

SUM

Answer

COUNT

Answer

MIN

Question 2

Which formula would you use to add up all the values in cells A1 to A10 in Google Sheets?

Accepted Answer

SUM(A1:A10)

Answer

TOTAL(A1:A10)

Answer

SUMALL(A1:A10)

Answer

ADD(A1:A10)

Question 3

Which function would you use to find the largest number in a set of values in Google Sheets?

Accepted Answer

MAX

Answer

BIGGEST

Answer

LARGE

Answer

HIGHEST

Question 4

What function can you use to count the number of cells that contain numbers in a range in Google Sheets?

Accepted Answer

COUNT

Answer

TALLY

Answer

SUM

Answer

NUMBER

Question 5

In Google Sheets, what symbol is used to start a formula?

Accepted Answer

=

Answer

@

Answer

#

Answer

$

Question 6

Which function would you use to find the smallest number in a range of values in Google Sheets?

Accepted Answer

MIN

Answer

LOWEST

Answer

SMALLEST

Answer

LEAST

Question 7

In Scratch, what is a variable used for?

Accepted Answer

To store and change values

Answer

To create sound effects

Answer

To draw shapes

Answer

To control sprite movement

Question 8

What does the 'repeat' block do in Scratch?

Accepted Answer

It repeats a set of actions a specified number of times

Answer

It stops all actions immediately

Answer

It plays a sound repeatedly

Answer

It creates a new sprite

Question 9

In Scratch, what is the purpose of using the 'set variable' block?

Accepted Answer

To assign a specific value to a variable

Answer

To delete a variable

Answer

To display a variable value

Answer

To copy a variable

Question 10

How can you change the value of a variable in Scratch?

Accepted Answer

By using the 'change variable' block

Answer

By connecting the variable to an event

Answer

By using the 'set variable' block

Answer

By deleting the variable block

Question 11

What is the function of a sequence of blocks in Scratch?

Accepted Answer

To execute actions in a specific order

Answer

To stop all actions at once

Answer

To create a random action

Answer

To loop actions indefinitely

Question 12

What type of value can a variable hold in Scratch?

Accepted Answer

Numbers, strings, or Boolean values

Answer

Only lists

Answer

Only numbers

Answer

Only strings

Question 13

Which block would you use to display the current value of a variable on the Scratch stage?

Accepted Answer

The 'show variable' block

Answer

The 'set variable' block

Answer

The 'hide variable' block

Answer

The 'change variable' block

Related quizzes

Related quizzes