Checkpoint - Spreadsheet Basics

The primary purpose of using a spreadsheet is to

• create presentations.

• manage and analyse data.

• edit photos.

• browse the internet.

Answer explanation

The primary purpose of using a spreadsheet is to manage and analyse data, making it the correct choice among the options provided.

The intersection of a row and column in a spreadsheet is called a

• cell.

• formula.

• label.

• value.

Answer explanation

The intersection of a row and column in a spreadsheet is called a cell, making it the correct choice.

In spreadsheets, columns are marked with

• letters.

• numbers.

• a letter and a number.

• a cell reference.

Answer explanation

In spreadsheets, columns are marked with letters, not numbers, a letter and a number, or a cell reference.

Which of the following is an example of a cell reference?

• C

• B4

• 9

• A1 + A2

Answer explanation

A cell reference in Excel is typically represented by a combination of a letter and a number, such as B4. Therefore, B4 is an example of a cell reference in the given options.

Which symbol is used to multiply cell values?

• /

• +

• -

• *

Answer explanation

The symbol used to multiply cell values is '*'. It is the correct choice for multiplication in Excel or other spreadsheet applications.

A cell in a spreadsheet column contains the word “internal”. The column should be formatted as

• text.

• number.

• date.

• string.

Answer explanation

The correct choice is 'text' because the word 'internal' is a text data type, not a number, date, or string.

In the cell reference A1, the letter represents

• the row.

• the column.

• the worksheet reference.

• the type of filter.

Answer explanation

In the cell reference A1, the letter represents the column, not the row, worksheet reference, or type of filter.

Which of these ranges spans two columns?

• A1:A78

• C5:D24

• A1:C2

• E34:G36

Answer explanation

The range C5:D24 spans two columns, from column C to column D, covering rows 5 to 24, making it the correct choice.

Which of the following tasks would be best suited to a spreadsheet?

• the presentation of information about a new television channel

• managing the details of members at a gym

• keeping track of the money raised at a charity event

• sharing information about the ratings of different resturants

Answer explanation

Keeping track of the money raised at a charity event is best suited to a spreadsheet as it involves organizing and calculating financial data efficiently.

The term used to describe the re-organising data in a spreadsheet column is

• search.

• fill.

• sort.

• filter.

Answer explanation

The term used to describe the re-organising data in a spreadsheet column is 'sort' because it arranges the data in a specific order based on certain criteria.