alleryWhat occurs to a relative reference when copied across a sheet?
AIt locks automatically
BIt remains unmodified
CIt causes syntax error
DIt changes its position
Answer & Solution
Correct answer: D. It changes its position
A relative cell reference updates relative to its new position when copied.
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 cell reference type with its behavior when copied: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?