Skip to content

=SUM(B2B3) will… (Class 12 Accountancy SQP 2026-27, Q34)

questionbuddy.in/q/cbse-12-accountancy-2026-27-sqp-q34-sum-b2b3-give-error-using

AccountancyCBSE Class 12 · Sample paper, session 2026-27 · 6 marks · Long answer

CBSE Class 12 Accountancy sample paper 2026-27: question 34

From the official CBSE sample question paper for 2026-27, section B-II, question 34, for 6 marks. Try it first; the hints and our step-by-step solution are below.

Q34 · 6 marks · Long answerSpreadsheet

=SUM(B2B3) will give an error while using spreadsheet. Identify the error and state the steps to correct it.

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

What separates the start and end of a range in Excel?

Hint 2

Excel reads text it does not recognise as a name.

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. =SUM(B2B3) shows the #NAME? error.

    1 mark

  2. Reason: Excel cannot recognise "B2B3": the range operator (:) between the two cell references is missing, so the text is read as an unknown name.

    2 marks

  3. Steps to correct: (1) select the cell showing the error; (2) click in the Formula Bar; (3) insert a colon between the references to make =SUM(B2:B3); (4) press Enter.

    2 marks

  4. The corrected formula =SUM(B2:B3) now adds the values in B2 and B3.

    1 mark

Answer: #NAME? error, because the colon is missing; correct it to =SUM(B2:B3) via the Formula Bar and press Enter

Where the marks are

  • Identifies #NAME? (1 mark)
  • Reason: missing range operator (2 marks)
  • Steps to correct (2 marks)
  • Correct 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 paperSample paper 2026-27: 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.