alleryIn the mixed reference $A1, which coordinate is kept absolute?
AThe column letter
BThe row number
CBoth coordinates
DNeither coordinate
Answer & Solution
Correct answer: A. The column letter
In the mixed reference $A1, the dollar sign fixes the column A as absolute.
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?Where can a generated chart component be placed in a spreadsheet?