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.

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'.

What is a formula in a spreadsheet?

• A formula is a type of chart in a spreadsheet.
• A formula is a calculation that is automatically worked out for you.

• A formula is a predefined template for data entry.

What is a value in a spreadsheet?

• The numbers

• The text that tells you what the numbers mean

• Calculations that are done using cells

What is a label in a spreadsheet?

• The numbers

• The text that tells you what the numbers mean

• Calculations that are done using cells

Which of the following is an example of an if function

• IF(A2>4, "YES", "NO")

• IF("YES", "NO", A2>4)

• IF(A2 and 4 are the same, Say yes, Say no)