Understanding Spreadsheets Basics

What is a spreadsheet primarily used for?

• Writing essays

• Organising and analysing data

• Drawing pictures

• Playing games

Which of the following is a common feature of spreadsheet software?

• Spell check

• Formula calculations

• Video editing

• Web browsing

In a spreadsheet, what is a cell?

• A type of graph

• A single box where a row and column intersect

• A collection of data

• A type of formula

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

• #

• @

• =

• $

If you want to add the values in cells A1, A2, and A3, which formula would you use?

What is the purpose of a 'pivot table' in a spreadsheet?

• To create a chart

• To summarise and analyse data

• To format text

• To insert images

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

• Bar chart

• Line chart

• Pie chart

• Flowchart

What is the function of the 'fill handle' in a spreadsheet?

• To copy data to adjacent cells

• To delete data

• To change cell colour

• To insert a new row

If you want to find the average of numbers in cells B1 to B5, which formula would you use?

Which of the following is a benefit of using spreadsheets?

• They are only useful for small data sets

• They require no training to use

• They allow for easy data manipulation and visualisation

• They are only available on desktop computers