LibreOffice Calc Question Answer

Match the following cell referencing types with their descriptions


<p>Match the following cell referencing types with their descriptions.</p><table class="table table-bordered"><tbody><tr><td><span style="font-size: 14px;"><b>Referencing Type</b></span></td><td><span style="font-size: 14px;"><b>Description</b></span></td></tr><tr><td><span style="font-size: 14px;">A. Relative Reference</span></td><td><span style="font-size: 14px;">1. Does not change when the formula is copied ($A$1)</span></td></tr><tr><td><span style="font-size: 14px;">B. Absolute Reference</span></td><td><span style="font-size: 14px;">2. Changes automatically when the formula is copied to another cell</span></td></tr><tr><td><span style="font-size: 14px;">C. Mixed Reference</span></td><td><span style="font-size: 14px;">3. Refers to cells in a different spreadsheet or workbook</span></td></tr><tr><td><span style="font-size: 14px;">D. External Reference</span></td><td><span style="font-size: 14px;">4. Partially absolute and partially relative (e.g., $A1 or A$1)</span></td></tr></tbody></table><p><br></p>

निम्नलिखित सेल संदर्भ प्रकारों का उनके विवरण के साथ मिलान करें।
Topic : LibreOffice Calc

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




Correct Answer

B. A-2, B-1, C-4, D-3