Skip to content

Which function… (Class 12 Accountancy SQP 2023-24, Q28b)

questionbuddy.in/q/cbse-12-accountancy-2023-24-sqp-q28b-function-results-can-displayed-auto

AccountancyCBSE Class 12 · Sample paper, session 2023-24 · 1 mark · MCQ

CBSE Class 12 Accountancy sample paper 2023-24: question 28(b)

From the official CBSE sample question paper for 2023-24, section B-II, question 28(b), for 1 mark. Try it first; the hints and our step-by-step solution are below.

Q28(b) · 1 mark · MCQSpreadsheet

Which function results can be displayed in Auto Calculate?

  1. (A)SUM and AVERAGE
  2. (B)MAX and LOOK
  3. (C)LABEL and AVERAGE
  4. (D)MIN and BLANK

Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2023-24.

Hints

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

Hint 1

Look at the status bar when you select a range of numbers.

Hint 2

LOOK, LABEL and BLANK are not functions shown there.

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. Auto Calculate shows quick results for the selected cells in the status bar without entering a formula.

  2. It shows functions such as SUM and AVERAGE (along with COUNT, MIN and MAX). Option (A).

    1 mark

Answer: (A) SUM and AVERAGE

Where the marks are

  • Status bar shows SUM and AVERAGE (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 2023-24: 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.