Spreadsheets Lesson 5&6

What is a spreadsheet?

• A digital tool used for organising, calculating, and analysing data

• A software for editing photos

• A tool for drawing diagrams

What is the purpose of formatting in spreadsheets?

• To calculate data

• To delete data

• To improve readability and presentation

How can you identify a cell in a spreadsheet?

• By its cell reference

• By its colour

• By its size

What type of graph shows trends over time?

• Bar chart

• Line graph

• Pie chart

What is a common format for numerical data in spreadsheets?

• Currency

• Image

• Text

How do you enter data in a spreadsheet cell?

• By clicking the cell and typing

• By dragging a cell

• By using a formula

What is the main purpose of formatting a spreadsheet?

• To hide data

• To improve readability and presentation

Which type of graph is best used to show proportions?

• Bar graph

• Line graph

• Pie chart

How does conditional formatting help in data analysis?

• It changes data values

• It deletes irrelevant data

• It highlights important data points

Why is it important to label the axes on a graph?

• To add colour

• To ensure data is clearly understood

• To make the graph look complete