Skip to content

What are the uses… (Class 12 Accountancy SQP 2025-26, Q33b)

questionbuddy.in/q/cbse-12-accountancy-2025-26-sqp-q33b-uses-error-alert-tab

AccountancyCBSE Class 12 · Sample paper, session 2025-26 · 4 marks · Long answer

CBSE Class 12 Accountancy sample paper 2025-26: question 33(b)

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

Q33(b) · 4 marks · Long answerSpreadsheet

What are the uses of ‘Error Alert tab’?

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

Hints

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

Hint 1

The tab belongs to the Data Validation dialog.

Hint 2

Recall the three alert styles and how strict each is.

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. The Error Alert tab (in Data Validation) shows an alert when invalid data is typed into a validated cell.

    1 mark

  2. It lets the user type a title and an error message that the person entering data will see.

    1 mark

  3. Its Style list sets how strict the check is: Stop blocks the invalid entry.

    1 mark

  4. Warning shows a warning but lets the user go ahead; Information only informs and accepts the entry.

    1 mark

Answer: Shows an alert on invalid entry, with a custom title and message; style Stop (blocks), Warning (warns, allows) or Information (informs, allows)

Where the marks are

  • Displays alert on invalid data (1 mark)
  • Custom title and message (1 mark)
  • Stop style (1 mark)
  • Warning and Information styles (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 2025-26: 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.