Match the LIST-I with LIST-II in the context of MS-EXCEL Choose the correct answer from the options given below:LIST-I (Cell Reference) LIST-II (Definition and Features) A. $D$5 I. Mixed reference. Row is fixed and column is changeable when fill handle is used B. D$5 II. Mixed reference. Column is fixed and row is changeable when fill handle is used C. D5 III. Absolute reference. Column and row are fixed when fill handle is used D. $D5 IV. Relative reference. Column and row are changeable when fill handle is used
Understanding MS Excel Cell References
MS Excel uses different types of cell references to manage how formulas behave when copied or filled across cells. Understanding these is key for effective spreadsheet management.
- Absolute Reference: Uses the $ symbol before both the column letter and the row number (e.g., $D$5$). This ensures that the reference remains fixed regardless of where the formula is copied.
- Relative Reference: Has no $ symbol (e.g., $D5$). The reference changes based on the relative position of the copied formula to the original cell.
- Mixed Reference: Uses the $ symbol before either the column letter or the row number, but not both (e.g., $D5$ or $D$5$). This fixes one part (column or row) while allowing the other to change.
Matching Cell References with Definitions
The question asks to match specific cell references (LIST-I) with their definitions and features (LIST-II).
| LIST-I (Cell Reference) | LIST-II (Definition and Features) | Correct Match |
| A. $D$5$ | III. Absolute reference. Column and row are fixed when fill handle is used | A-III |
| B. $D$5$ | I. Mixed reference. Row is fixed and column is changeable when fill handle is used | B-I |
| C. $D5$ | IV. Relative reference. Column and row are changeable when fill handle is used | C-IV |
| D. $D5$ | II. Mixed reference. Column is fixed and row is changeable when fill handle is used | D-II |
Final Answer Combination
Combining the matches derived from the definitions of cell references:
- A matches with III (Absolute Reference).
- B matches with I (Mixed Reference, Row Fixed).
- C matches with IV (Relative Reference).
- D matches with II (Mixed Reference, Column Fixed).
The correct combination is A-III, B-I, C-IV, D-II.
Important Questions from Microsoft Office
To adjust the screen resolution or change the desktop background in Windows, which of the following would a user typically access?
- Which of the following steps correctly describes how to rename a file or folder using the File menu?
- In Slide Show, which option ensures that only a specific set of slides is played during an MS PowerPoint $2019$ presentation without creating a new file?
- In Microsoft Excel, a workbook is a collection of:
- Which one of the following software applications is NOT a part of Microsoft Office?
