CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Browse all papers
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

What happens when you select "Warning" style in the Error Alert tab?

What happens when you select "Warning" style in the Error Alert tab?

Answer & explanation+

Correct answer: option 2

The correct answer is Option (2) → It displays a warning but allows invalid data entry

The Error Alert tab of data validation decides what Excel does when a user types data that breaks the rule. It offers three styles, from the mildest to the strictest: Information, Warning and Stop. The Warning style shows a message but still lets the user keep the invalid entry if he chooses to.

Why the other options are incorrect

  • Option (1) It stops invalid data from being entered — Incorrect. Blocking the entry is what the Stop style does, not the Warning style.

  • Option (3) It ignores invalid data entry silently — Incorrect. Every error alert style shows a message; none of them accepts wrong data without a word.

  • Option (4) It deletes the invalid data entered — Incorrect. Data validation never deletes what was typed; it only warns or refuses the entry.

NCERT (2026-27 edition):
Data Validation – “… (c) In Style drop-down menu select Information, Warning or Stop as per the severity and accuracy requirement for data where. (i) Information: displays a message but will prevent entry of invalid data. (ii) Warning: displays a warning message but will not prevent entry of invalid data. (iii) Stop: will prevent invalid entry of data.”

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. The focus on identification of uniqueness of any region and understanding the reason for the same is called _____.Geography · Fundamentals of Human Geography: Human Geography-Nature and Scope
  2. For the given five values, 3.6, 4.3, 4.3, 3.4, 4.4, the three years moving averages are:Applied Maths. Section B2 · Index Numbers and Time Based Data
  3. Identify the concept of Financial Management being mentioned in the above case.Business Studies · Financial Management
  4. Select the most appropriate ANTONYM of the underlined word. His explanation is always concise.English · Antonyms
  5. Identify the painting:Fine Arts · The Rajasthani Schools of Painting
  6. Which of the following is most harmful for life on earth?General Aptitude Test · General Knowledge
  7. The correct order of the electrical conductivity of the different types of solids is :Physics · Semiconductors and Electronic Devices
  8. A boy increases his speed to 9/5 times of his original speed. By doing this, he reaches his school 40 minutes before the usual time. How mu…General Aptitude Test · Numerical Ability
  9. In which year was the ASEAN Regional Forum established?Political Science · Contemporary World Politics: Contemporary Centres of power
  10. Which of the following statements regarding Genetically Modified Organisms are correct? (A) Reduced reliance on chemical pesticides (B) Red…Biology · Biotechnology and its Applications