Skip to content

What is meant by… (Class 12 Accountancy SQP 2026-27, Q33A)

questionbuddy.in/q/cbse-12-accountancy-2026-27-sqp-q33a-meant-data-validation-facilitated-error

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

CBSE Class 12 Accountancy sample paper 2026-27: question 33(A)

From the official CBSE sample question paper for 2026-27, 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

What is meant by 'data validation'? What is facilitated by 'Error Alert tab'?

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

How would you stop someone typing text into an amount column?

Hint 2

The Error Alert tab decides what happens after a wrong entry.

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. Data validation is an Excel feature that controls what can be entered in a cell, according to rules set in advance.

    1 mark

  2. Examples: only whole numbers between 1 and 100, only dates in a range, or a drop-down list of allowed values. It keeps data accurate and consistent.

    1 mark

  3. The Error Alert tab shows an error message when invalid data is entered and so prevents wrong entries.

    1 mark

  4. It lets you choose the alert style: Stop (blocks the entry), Warning (allows it after a warning) or Information (shows a message and allows it).

    1 mark

Answer: Data validation restricts cell entries to set rules (whole numbers, date ranges, lists); the Error Alert tab shows a message on invalid entry with Stop, Warning or Information styles

Where the marks are

  • Meaning of data validation (1 mark)
  • Examples / purpose (1 mark)
  • Error Alert purpose (1 mark)
  • Alert styles (1 mark)

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 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.