Each cell in the worksheet of MS-Excel 365 is identified by a cell
Show answer & explanation
Correct answer: D
Explanation
The correct answer is Option 4 i.e. reference
- Each cell in the worksheet of Microsoft Excel 365 is identified by a cell reference. A cell reference is a combination of letters and numbers that specifies the location of a cell within the spreadsheet. There are two types of cell references:
- Relative Cell Reference: This type of reference changes when you copy it to another cell. For example, if you copy a formula with a relative reference from cell A1 to cell A2, the reference will automatically adjust to A2.
- Absolute Cell Reference: This type of reference does not change when you copy it to another cell. It is denoted by a "$" symbol. For example, if you have an absolute reference to cell A1 as $A$1 and you copy it to cell A2, it will still refer to cell A1.
- Cell references are crucial in Excel for creating formulas and performing calculations based on the values in different cells