Question

A block of adjacent cells, that are selected is called ________.

• A. Active cell
• B. Cell
• C. Cell address
• D. Range of cells

Hint:

Whenever a spreadsheet formula needs to perform calculations over multiple cells (like adding numbers), it always requests a range (for example, =SUM(A1:A10)). This confirms that a block of selected cells is a cell range.

Answer 1

The Correct Option is D

Step 1: Understanding the Question:
The question asks for the correct technical term used in spreadsheet programs (like MS Excel or LibreOffice Calc) to describe a contiguous group of selected adjacent cells.

Step 2: Key Formula or Approach:
- An individual box is a Cell.
- The cell currently highlighted for editing is the Active cell.
- The coordinates of a cell (e.g., B4) make up its Cell address.
- A group of two or more adjacent cells selected together forms a rectangular block, which is defined as a Range of cells.

Step 3: Detailed Explanation:
When you click and drag across several adjacent cells in a spreadsheet, you select a contiguous rectangular block. In spreadsheet terminology, this selection is known as a Range of cells. It is written using the top-left cell address and bottom-right cell address separated by a colon (e.g., A1:C5). This matches option (D).

Step 4: Final Answer:
A selected block of adjacent cells is called a range of cells, matching option (D).