alleryWhich symbol designates an absolute cell reference in a formula?
ADollar sign ($)
BAmpersand (&)
CPercent sign (%)
DAsterisk symbol (*)
Answer & Solution
Correct answer: A. Dollar sign ($)
An absolute reference is indicated by placing a dollar sign ($) before coordinates.
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?