Google Sheets - Retrieval Quiz

What is Google Sheets used for?

• Creating slideshows

• Writing long stories

• Organising and analysing data

• Drawing pictures

Which symbol is used to start a formula in Google Sheets?

• #

• =

• @

• +

What is a ‘cell’ in a spreadsheet?

• A single box where you can enter data

• A group of numbers

• A type of computer virus

• A whole sheet of data

What happens when you type text that is too long for a cell?

• It disappears

• It moves to the next row

• It overflows into the next cell unless that cell has data

• It turns into a number

Which tool is used to quickly copy a formula to other cells?

• The paintbrush

• The fill handle

• The eraser

• The highlighter

What does the SUM function do?

• Adds up a range of numbers

• Finds the biggest number

• Counts the number of words in a cell

• Changes numbers into percentages

Which of these is a correct cell reference?

• 5B

• B5

• #B5

• B-5

How do you select an entire column in Google Sheets?

• Click the column letter at the top

• Click the first cell in the column

• Click and drag across all rows

• Press the spacebar

What happens when you merge cells in Google Sheets?

• The cells disappear

• The data is deleted

• The selected cells become one large cell

• The spreadsheet closes

What shortcut can you use to undo a mistake in Google Sheets?

• Ctrl + Z

• Ctrl + X

• Ctrl + Y

• Ctrl + U