Skip to content

What is used to… (Class 12 Accountancy SQP 2026-27, Q29)

questionbuddy.in/q/cbse-12-accountancy-2026-27-sqp-q29-used-build-single-formula-multiple

AccountancyCBSE Class 12 · Sample paper, session 2026-27 · 1 mark · MCQ

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

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

Q29 · 1 mark · MCQSpreadsheet

What is used to build single formula with multiple results in Excel ?

  1. (A)Derived value
  2. (B)Vectors
  3. (C)Round()
  4. (D)Array

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 feature works on many cells in one formula?

Hint 2

ROUND() returns only one value.

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. An array formula works on a range of values at once and can return several results from a single formula.

  2. So a single formula with multiple results is built with an array. Option (D).

    1 mark

Answer: (D) Array

Where the marks are

  • Array formulas return multiple results (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.