Question 1

What tool in Google Sheets allows you to arrange your data in a specific order?

Accepted Answer

Sort

Answer

Filter

Answer

Column

Answer

Cell

Question 2

Which feature in Google Sheets helps you hide data that you do not want to see temporarily?

Accepted Answer

Filter

Answer

Sort

Answer

Format

Answer

Edit

Question 3

What happens when you apply a filter to a column in Google Sheets?

Accepted Answer

Only the rows that meet the filter criteria are shown.

Answer

All rows are deleted

Answer

The data becomes unreadable

Answer

All data is copied to a new sheet

Question 4

In Google Sheets, what is the purpose of using the 'Sort' function?

Accepted Answer

To arrange data in a specific order.

Answer

To create a new chart

Answer

To insert an image

Answer

To change the font style

Question 5

Which option should you use in Google Sheets to find specific information in a large dataset?

Accepted Answer

Filter

Answer

Sort

Answer

Format

Answer

Delete

Question 6

What is the result of using the 'Sort A-Z' option in Google Sheets?

Accepted Answer

Data is arranged in alphabetical order from A to Z.

Answer

Data is grouped randomly

Answer

Data is deleted

Answer

Data is reversed from Z to A

Question 7

If you want to rearrange numbers in Google Sheets from highest to lowest, which function should you use?

Accepted Answer

Sort Z-A

Answer

Filter

Answer

Average

Answer

Count

Question 8

In Scratch, what block would you use to repeat a set of instructions multiple times?

Accepted Answer

repeat

Answer

say

Answer

wait

Answer

if

Question 9

Which Scratch block is used to make a character move forward?

Accepted Answer

move 10 steps

Answer

slide 10 steps

Answer

go forward

Answer

turn right

Question 10

What type of block in Scratch is used to get input from the user?

Accepted Answer

ask and wait

Answer

forever

Answer

broadcast

Answer

when green flag clicked

Question 11

In Scratch, which block would you use to change a variable's value?

Accepted Answer

change [variable] by [value]

Answer

reset [variable]

Answer

set [variable] to [value]

Answer

increment [variable]

Question 12

What Scratch block would you use to control whether a condition is true or false?

Accepted Answer

if

Answer

repeat

Answer

wait

Answer

broadcast

Question 13

In Scratch, which block would you use to end a program or stop an action?

Accepted Answer

stop all

Answer

pause

Answer

end game

Answer

finish

Question 14

What block would you use to wait for a specific amount of time in Scratch?

Accepted Answer

wait [time] seconds

Answer

delay [time] seconds

Answer

pause [time] seconds

Answer

hold [time] seconds

Question 15

In Scratch, which block is used to change the appearance of a sprite?

Accepted Answer

switch costume to [costume]

Answer

show

Answer

set size to [size]

Answer

change color effect by [value]

Question 16

Which function in Google Sheets adds up a range of numbers?

Accepted Answer

SUM

Answer

AVERAGE

Answer

COUNT

Answer

MAX

Question 17

What does the AVERAGE function do in Google Sheets?

Accepted Answer

Calculates the mean of a set of numbers

Answer

Finds the largest number

Answer

Calculates the total sum

Answer

Counts the number of entries

Question 18

In Google Sheets, which function would you use to count the number of cells that contain numbers?

Accepted Answer

COUNT

Answer

MAX

Answer

SUM

Answer

AVERAGE

Question 19

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

Accepted Answer

MAX

Answer

SUM

Answer

AVERAGE

Answer

MIN

Question 20

What function in Google Sheets can you use to find the smallest number in a range?

Accepted Answer

MIN

Answer

COUNT

Answer

MAX

Answer

SUM

Related quizzes

Related quizzes