Basic Spreadsheet and Database Terms Quiz

What is the term used for the vertical cells in a spreadsheet that are identified by letters?

• Row

• Column

• Cell

• Range

Answer explanation

In a spreadsheet, vertical cells are organized into columns, which are identified by letters (A, B, C, etc.). Rows, on the other hand, are horizontal and identified by numbers. Therefore, the correct term is 'Column'.

Tags

DOK Level 1: Recall

Which of the following best describes a cell in a spreadsheet?

• The intersection between a row and a column

• A group of cells within a row

• A vertical line of cells

• A horizontal line of cells

Answer explanation

A cell in a spreadsheet is defined as the intersection between a row and a column, making the first choice the correct answer. The other options describe groups or lines of cells, not individual cells.

Tags

DOK Level 1: Recall

What is the function of the fill handle in Excel?

• To delete data in cells

• To fill data based on an existing pattern

• To format cells

• To sort data

Answer explanation

The fill handle in Excel allows users to extend a series or pattern in adjacent cells, making it easy to fill data based on existing values. This is why the correct answer is 'To fill data based on an existing pattern'.

Tags

DOK Level 1: Recall

What is an active cell in a spreadsheet?

• A cell that is locked

• A cell that is ready to input data

• A cell that contains a formula

• A cell that is hidden

Answer explanation

An active cell in a spreadsheet is the one that is currently selected and ready for data entry. This means it is highlighted and allows the user to input or edit data, making 'A cell that is ready to input data' the correct choice.

Tags

DOK Level 1: Recall

Which of the following is a predefined calculation in a spreadsheet?

• Formula

• Function

• Legend

• Query

Answer explanation

A function is a predefined calculation in a spreadsheet that performs specific operations on data, such as SUM or AVERAGE. In contrast, a formula is a user-defined calculation, while legend and query are not calculations.

Tags

DOK Level 1: Recall

What is a spreadsheet?

• A file that consists of cells in rows and columns to arrange, calculate, and sort data

• A software used for databases

• A request for information from a database table

• A single piece of data

Answer explanation

A spreadsheet is defined as a file made up of cells organized in rows and columns, which allows users to arrange, calculate, and sort data effectively. This distinguishes it from other options that do not accurately describe a spreadsheet.

Tags

DOK Level 1: Recall

What is a cell range in a spreadsheet?

• A single cell

• A group of cells within a row and/or column

• A vertical line of cells

• A horizontal line of cells

Answer explanation

A cell range refers to a group of cells that can span multiple rows and/or columns, making it the correct choice. It is not limited to a single cell, nor is it restricted to just vertical or horizontal lines.

Tags

DOK Level 1: Recall

What is the purpose of a legend in a chart?

• To display the title of the chart

• To contain small samples of each color and a description of what each color means

• To show the data values

• To calculate the total of the data

Answer explanation

The purpose of a legend in a chart is to contain small samples of each color and a description of what each color means, helping viewers understand the data represented visually.

Tags

DOK Level 1: Recall

What is the term for the horizontal cells in a spreadsheet that are identified by numbers?

• Column

• Row

• Cell

• Range

Answer explanation

In a spreadsheet, rows are the horizontal cells identified by numbers. Each row runs from left to right, while columns are vertical and identified by letters. Therefore, the correct term for horizontal cells is 'Row'.

Tags

DOK Level 1: Recall

What is a formula in a spreadsheet?

• A predefined calculation

• Any calculation

• A request for information

• A single piece of data

Answer explanation

A formula in a spreadsheet can be any calculation, allowing users to perform various mathematical operations. This makes 'Any calculation' the correct choice, as it encompasses all types of formulas used in spreadsheets.

Tags

DOK Level 1: Recall