alleryMatch each spreadsheet cell reference type with its behavior when copied:
A1-A, 2-B, 3-C
B1-B, 2-A, 3-C
C1-C, 2-B, 3-A
D1-A, 2-C, 3-B
Answer & Solution
Correct answer: A. 1-A, 2-B, 3-C
Relative adjusts on copy. Absolute ($A$1) stays locked. Mixed locks one dimension.
Keep practising Spreadsheet Basics
Browse all Spreadsheet Basics questions for ICSE Class 8, or explore more Computer Applications topics.
Related questions
Match each spreadsheet data type with its default alignment in a cell:Match each spreadsheet formula or function with its syntax rule:Match each spreadsheet component with its standard grid definition:What is the column label for the final 16384th column in modern Excel?What condition is required for automatic recalculation in a sheet?What rule governs cell names within a single spreadsheet?In the mixed reference $A1, which coordinate is kept absolute?Where can a generated chart component be placed in a spreadsheet?