Understanding Data in Spreadsheets

What is a cell in a spreadsheet?

• A place where you can store a single piece of data

• A group of cells in a row

• A type of chart

• A type of graph

What is a row in a spreadsheet?

• A vertical line of cells

• A horizontal line of cells

• A type of data

• A type of graph

Which of the following is a data type you can use in a spreadsheet?

• Colour

• Text

• Size

• Chart

What type of data is the number 42 in a spreadsheet?

• Text

• Number

• Graph

• Chart

Which of the following is used to visually represent data in a spreadsheet?

• Cells

• Rows

• Graphs

• Text

What is a bar graph used for in a spreadsheet?

• To show data in rows

• To show data in columns

• To compare different categories

• To store text data

Which of the following is NOT a type of graph you can create in a spreadsheet?

• Line graph

• Pie chart

• Text graph

• Bar chart

What is the main purpose of using graphs in a spreadsheet?

Evaluate responses using AI:

OFF

Which data type would you use to store the name of a person in a spreadsheet?

• Number

• Text

• Chart

• Graph

What is a pie chart best used for in a spreadsheet?

• To show changes over time

• To show parts of a whole

• To list data in rows

• To store numerical data