Unit 1 - Understanding Spreadsheets and Visualisations

What is the fundamental unit of a spreadsheet where data is stored?

• Row

• Column

• Cell

• Chart

Which of the following is a predefined operation in spreadsheets used to perform common tasks?

• Formula

• Function

• Graph

• Table

What type of chart is best used for showing proportions?

• Bar Chart

• Line Graph

• Pie Chart

• Column Chart

Which formula would you use to calculate the mean value of a data set in a spreadsheet?

What is the unique reference of a cell based on?

• Its row number only

• Its column letter only

• Its row number and column letter

• Its data type

Which function would you use to find the middle value in a sorted data set?

What is the purpose of using consistent naming conventions in spreadsheets?

• To make the spreadsheet look colourful

• To ensure data is entered correctly

• To reflect the purpose and improve clarity

• To increase the size of the file

Which of the following is NOT a type of chart used in data visualisation?

• Bar Chart

• Line Graph

• Pie Chart

• Text Box

• Counts all cells in a range

• Counts cells that meet a specific condition

• Adds all numbers in a range

• Finds the average of numbers in a range

Which component of data visualisations provides context through titles, labels, and legends?

• Tables

• Text and Graphics

• Charts

• Cells