Match the following cell referencing types with their descriptions.
Referencing Type | Description |
A. Relative Reference | 1. Does not change when the formula is copied ($A$1) |
B. Absolute Reference | 2. Changes automatically when the formula is copied to another cell |
C. Mixed Reference | 3. Refers to cells in a different spreadsheet or workbook |
D. External Reference | 4. Partially absolute and partially relative (e.g., $A1 or A$1) |
Qusनिम्नलिखित सेल संदर्भ प्रकारों का उनके विवरण के साथ मिलान करें।
A. A-1, B-2, C-3, D-4
B. A-2, B-1, C-4, D-3
C. A-3, B-4, C-1, D-2
D. A-4, B-3, C-2, D-1