Spreadsheet Basics Quiz

What is a spreadsheet used for?

• Writing stories

• Solving maths and organizing data

• Drawing pictures

• Playing music

What symbol is used to start a formula in a spreadsheet?

• +

• =

• $

• #

Which of the following adds up numbers in a spreadsheet?

• =ADD()

• =TOTAL()

• =SUM()

• =COUNT()

What function finds the biggest number?

• =MIN()

• =MAX()

• =AVG()

• =TOTAL()

What does the function =AVERAGE(A1:A5) do?

• Finds the smallest number

• Multiplies the numbers

• Adds the numbers

• Finds the average

Which function gives the smallest number in a range?

• =LOW()

• =MIN()

• =SMALL()

• =LESS()

What is a cell in a spreadsheet?

• A row of data

• A box where a row and column meet

• A column of text

• A title

Which of these is a correct cell reference?

• A10

• 10A

• ColumnA

• A-10

What does the formula =A1+B1 do?

• Subtracts the values

• Multiplies the values

• Adds the values

• Deletes the values

What does the formula =A2/B2 do?

• Adds the values

• Multiplies the values

• Subtracts the values

• Divides the values