Spreadsheet Recap Quiz

What is a spreadsheet used for?

• To view, analyse and interpret data

• To make data pretty

• To perform calculations

Answer explanation

A spreadsheet is primarily used to view, analyze, and interpret data, making it a powerful tool for data management. While it can also perform calculations and format data, its main function is data analysis.

How is a column identified in a spreadsheet?

• A letter, for example Column A

• A number, for example Column 5

• A letter followed by a number. For example, Column B4

Answer explanation

In a spreadsheet, columns are identified by letters, starting with A for the first column, B for the second, and so on. Therefore, the correct answer is 'A letter, for example Column A', not numbers or letter-number combinations.

How is a row identified in a spreadsheet?

• A letter, for example Row A

• A number, for example Row 5

• A letter followed by a number. For example, Row B4

Answer explanation

In a spreadsheet, rows are identified by numbers, such as Row 5. Columns are identified by letters, like Column A. Therefore, the correct choice is a number, as it specifically denotes a row.

How is a cell identified in a spreadsheet?

• A letter, for example Cell A

• A number, for example Cell 5

• A letter followed by a number. For example, Cell B4

Answer explanation

A cell in a spreadsheet is identified by a combination of a letter and a number, such as Cell B4. The letter represents the column, while the number indicates the row, making this the correct format for cell identification.

What is an active cell?

• A cell with a calculation in?

• A cell that moves about

• A cell with some data in

Answer explanation

An active cell is defined as a cell that contains data. This distinguishes it from cells that may be empty or contain only calculations, making 'A cell with some data in' the correct choice.

Label the following formatting tools.

a

b

c

Font Size

Add Borders

Merge and Center

Fill Cell Colour

Font colour

Text Align

What does the merge and centre tool do?

• Combines two different cells together and centres the data

• Splits a cell into two different cells

• Centres all the cells in the spreadsheet

Answer explanation

The 'merge and centre' tool combines two or more selected cells into one cell and centers the content within that merged cell. This is why the correct answer is 'Combines two different cells together and centres the data'.

Conditional formatting changes the​ (a)   of a cell based on a condition being ​ (b)  

• appearance

• True

• Size

• Shape

• False

Answer explanation

Conditional formatting changes the appearance of a cell based on a condition being True. This means that when a specified condition is met, the visual style of the cell is altered.

Put the steps in order to conditionally format the cells based on the score.

• Select the colour green and press enter

• Highlight the cells you wish to be conditionally formatted

• Select "Greater than" and type in the number 5

• Click the "conditional formatting" button

• Go to "highlight cell rules"

Conditional formatting allows us to quickly read a spreadsheet by looking at the ​ (a)  

• different colours

• different images

• different shapes

• different data

Answer explanation

Conditional formatting uses different colours to highlight data, making it easier to read and interpret the information in a spreadsheet at a glance. This visual distinction is key to quickly understanding the data.