Match the LIST-I with LIST-II in the context of MS-Excel:
LIST-I
(Cell Reference)LIST-II
(Definition and Feature)A. $ E $ 5 I. Absolute reference. Column and row are fixed when fill handle is used. B. E$5 II. Mixed reference. Row is fixed and column is changeable when fill handle is used. C. E5 III. Relative reference. Column and row are changeable when fill handle is used. D. $E5 IV. Mixed reference. Column is fixed and row is changeable when fill handle is used.
Choose the correct answer from the options given below:
MS Excel Cell Reference Matching
This question tests the understanding of different cell reference types in MS-Excel and how they behave when copied using the fill handle.
Understanding Cell References
In MS-Excel, cell references tell formulas which cells to use. The '$' symbol is used to make references absolute or mixed.
- Relative Reference (E5): Both the column (E) and row (5) are not prefixed with '$'. When copied, both the column and row adjust relative to the new location.
- Absolute Reference ($E$5): Both the column (E) and row (5) are prefixed with '$'. When copied, both remain fixed to the original cell (E5).
- Mixed Reference (E$5 or $E5): One part (column or row) is prefixed with '$', making it fixed, while the other part is not, making it changeable.
Matching LIST-I with LIST-II
Let's match each cell reference from LIST-I with its correct definition from LIST-II:
- A. $E$5$: The '$' symbol before both 'E' (column) and '5' (row) indicates that both are fixed. This is an Absolute Reference. Matches with I.
- B. $E$5$: The '$' symbol is only before '5' (row). This means the row is fixed, but the column 'E' can change if the formula is copied. This is a Mixed Reference where the row is fixed. Matches with II.
- C. $E5$: No '$' symbol is used. Both the column 'E' and row '5' are changeable. This is a Relative Reference. Matches with III.
- D. $E5$: The '$' symbol is only before 'E' (column). This means the column is fixed, but the row '5' can change if the formula is copied. This is a Mixed Reference where the column is fixed. Matches with IV.
Correct Combination
Based on the matching:
- A matches with I
- B matches with II
- C matches with III
- D matches with IV
Therefore, the correct option is A-I, B-II, C-III, D-IV.
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?
