Skip to content

Explain the use… (Class 12 Accountancy SQP 2023-24, Q33a)

questionbuddy.in/q/cbse-12-accountancy-2023-24-sqp-q33a-use-conditional-formatting

AccountancyCBSE Class 12 · Sample paper, session 2023-24 · 4 marks · Long answer

CBSE Class 12 Accountancy sample paper 2023-24: question 33(a)

From the official CBSE sample question paper for 2023-24, section B-II, question 33(a), for 4 marks. Try it first; the hints and our step-by-step solution are below.

Q33(a) · 4 marks · Long answerSpreadsheet

Explain the use of 'Conditional Formatting'.

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

What happens to a cell's format when its value meets a rule?

Hint 2

Think of colour scales and highlighted exceptions.

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. Conditional formatting changes the look of a cell or range automatically when a condition on its value is met.

    1 mark

  2. It highlights the information needed, for example values above a limit or overdue amounts.

    1 mark

  3. It can apply colour scales, data bars and icon sets to show the size of values at a glance.

    1 mark

  4. By drawing attention to exceptions and trends, it helps decision making.

    1 mark

Answer: Conditional formatting changes the appearance of cells that meet a condition: it highlights needed information, applies colour scales/data bars/icons, and helps decision making

Where the marks are

  • 1 mark for each use explained (4 marks)

Revise the chapter

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.