CBSE Class 12 Accountancy sample paper 2026-27: question 27
From the official CBSE sample question paper for 2026-27, section B-II, question 27, for 1 mark. Try it first; the hints and our step-by-step solution are below.
Q27 · 1 mark · MCQSpreadsheet
Identify the error which will be displayed on screen when the set of co-ordinates that a cell occupies on a worksheet is invalid.
- (A)Correct a # NAME ? Error
- (B)Correct # REF ! Error
- (C)Correct a # N/A Error
- (D)Correct a ##### Error
Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2026-27.
Hints
Open one hint at a time and try again before the next.
Hint 1
Which error mentions a "reference"?
Hint 2
What happens to a formula when the cells it points to are deleted?
Step-by-step solution
Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.
#REF! appears when a formula refers to a cell reference that is not valid, for example after the referred cells are deleted.
- 1 mark
#NAME? is for unrecognised text in a formula, #N/A for a value not available and ##### for a column too narrow. Option (B).
Answer: (B) Correct # REF ! Error
Where the marks are
- Invalid cell reference gives #REF! (1 mark)
Revise the chapter
- Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
More questions from Spreadsheet
- Sample paper 2026-27, Q28 · 1 markHow are 'absolute cell reference' and 'mixed cell reference' identified in Excel ?
- Sample paper 2026-27, Q29 · 1 markWhat is used to build single formula with multiple results in Excel ?
- Sample paper 2026-27, Q33(A) · 4 marksWhat is meant by 'data validation'? What is facilitated by 'Error Alert tab'?
The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.