Understanding Spreadsheets Quiz

What is a spreadsheet used for?

• Writing stories

• Storing and calculating data

• Drawing pictures

• Playing music

Which of these is an example of spreadsheet software?

• Microsoft Word

• Google Docs

• Microsoft Excel

• Adobe Photoshop

What is the name of a single box in a spreadsheet?

• Square

• Cell

• Box

• Graph

How are columns labeled in a spreadsheet?

• Numbers (1,2,3...)

• Letters (A, B, C...)

• Symbols (*, &, %)

• Colors

How are rows labeled in a spreadsheet?

• Letters (A, B, C...)

• Numbers (1, 2, 3...)

• Symbols (*, &, %)

• Colors

Which of these is a correct cell reference?

• 5A

• A5

• Row 3

• Column B

What does a cell reference tell you?

• The name of a person

• The color of the cell

• The exact location of a cell

• The font size in the cell

What does the SUM function do in a spreadsheet?

• Multiplies numbers

• Adds up numbers

• Sorts numbers

• Deletes numbers

Which formula correctly adds up the numbers in cells A1 to A5?

• =ADD(A1:A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

• =PLUS(A1:A5)

What does the AVERAGE function do?

• Finds the biggest number

• Adds all numbers together

• Finds the middle value

• Finds the average value