CCC Online Test
Menu mobile
Home
About
About CCC
CCC Syllabus
FAQs
Question Bank
Introduction to Computer
Introduction to Operating System
LibreOffice Writer
LibreOffice Calc
LibreOffice Impress
Introduction to Internet and WWW
Email Social Networking and eGovernance Services
Digital Financial Tools and Applications
Overview of Future Skills and Cyber Security
Study Material
Flash Card
Tutorial
Abbreviation
CCC Blog
O Level Online Test
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