HomeTestsSearchRankProfile
easyMCQCUET Accountancy2026Computerised Accounting
1 mark

4 is an example of a __________ reference.

  1. A
    Fixed
  2. B
    Mixed
  3. C
    Relative
  4. D
    Absolute

Solution & Step-by-step Explanation

In spreadsheet software (like MS Excel or Google Sheets):Relative reference (C4): Changes both column and row when copied.Absolute reference ( 4): Keeps both column and row locked.Mixed reference ( 4): Locks either the column or the row while leaving the other free to change.Since only one coordinate uses the absolute dollar sign symbol (\ $
), it is a Mixed Reference.

Practice this question

Try it yourself before checking the explanation above.

4 is an example of a __________ reference.
A
Fixed
B
Mixed
C
Relative
D
Absolute

Share This Question

Related Questions

Ready for a Full Test?

Practice with timed mock tests and track your performance across Computerised Accounting.

Discussion