Skip to content

#NAME? Error indicates : (Class 12 Accountancy 2026, Q30a)

questionbuddy.in/q/cbse-12-accountancy-2026-67-5-1-q30a-name-error-indicates

AccountancyCBSE Class 12 · Board exam 2026, set 67/5/1 · 1 mark · MCQ

CBSE Class 12 Accountancy 2026: question 30(a)

Set in the CBSE Class 12 board exam of 2026, paper 67/5/1, section B-II, question 30(a), for 1 mark. Try it first; the hints and our step-by-step solution are below.

Q30(a) · 1 mark · MCQSpreadsheet

#NAME? Error indicates :

  1. (A)Syntax error in the formula
  2. (B)Missing data in the worksheet
  3. (C)Formula referring to a protected call
  4. (D)Excel does not understand the text used in the formula.

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/5/1.

Hints

Open one hint at a time and try again before the next.

Hint 1

Think of typing =SUMM(A1:A5).

Hint 2

The error name points to a "name" problem.

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.

  1. #NAME? appears when Excel does not recognise text in a formula, such as a misspelt function name or an undefined range name.

  2. That is option (D). Option (D).

    1 mark

Answer: (D) Excel does not understand the text used in the formula

Where the marks are

  • Unrecognised text in formula (1 mark)

Revise the chapter

  • Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
Practise this chapterBoard-style questions from Spreadsheet, one at a time, marked against the answer key and marking points.Back to the full paper2026 board paper, set 67/5/1: every question, by section.

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.