Each cell in the worksheet of MS-Excel 365 is identified by a cell_________?

Correct option is D

In MS-Excel 365, each cell in a worksheet is identified by a cell reference. A cell reference is the combination of the column letter and the row number where the cell is located. For example:

• A1: Represents the cell in Column A, Row 1.
• B2: Represents the cell in Column B, Row 2.

This unique identification system allows users to refer to specific cells while performing calculations, creating formulas, or analyzing data.

Important Key Points:

1. Cell Reference:
• A cell reference consists of the column letter (A, B, C...) and the row number (1, 2, 3...).
• Examples: C3, D10, E15.
2. Types of Cell References:
• Relative Reference: Changes when copied or moved (e.g., A1).
• Absolute Reference: Remains fixed using $ (e.g., $A$1).
• Mixed Reference: Combination of relative and absolute (e.g., $A1 or A$1).
3. Purpose:
• Used in formulas, functions, and data navigation to identify and manipulate data within specific cells.

Knowledge Booster:

1. Why Not Other Options?
• a) Color:
• Incorrect. Cell color is for formatting purposes and does not uniquely identify cells.
• b) Size:
• Incorrect. Cell size refers to dimensions (row height, column width) but does not identify cells.
• c) Rounding:
• Incorrect. Rounding relates to numerical formatting, not cell identification.
2. Example of Cell Reference in Formulas:
• To add values in A1 and B1, you use the formula:
  =A1 + B1
3. Shortcut to Identify a Cell:
• Click on any cell, and its reference will appear in the Name Box (top-left corner of the worksheet).