HomeTestsSearchRankProfile
easyMCQCUET Accountancy 2025 30 May Shift 22026Accountancy
1 mark

What happens when you select "Warning" style in the Error Alert tab during Data Validation in Excel?

  1. A
    It stops invalid data from being entered
  2. B
    It displays a warning but allows invalid data entry
  3. C
    It ignores invalid data entry silently
  4. D
    It deletes the invalid data entered

Solution & Step-by-step Explanation

In Excel's Data Validation settings, there are three types of Error Alerts:Stop: Completely blocks the user from saving invalid data.Warning: Flags a dialog box pointing out the mismatch with choices like "Continue? Yes/No", which allows the user to override and enter the invalid data anyway if they click Yes.Information: Advises the user without restricting their input.

Practice this question

Try it yourself before checking the explanation above.

What happens when you select "Warning" style in the Error Alert tab during Data Validation in Excel?
A
It stops invalid data from being entered
B
It displays a warning but allows invalid data entry
C
It ignores invalid data entry silently
D
It deletes the invalid data entered

Share This Question

Computerised AccountingSpreadsheetData Validation

Related Questions

easyMCQ

Which one of the following statements is true?

easyMCQ

Which of the following statements is not correct?

easyMCQ

Which one of the following statements is correct?

easyMCQ

The product formed by the reaction of an aldehyde with a primary amine is:

easyMCQ

Which part of the tobacco plant is infected by Meloidogyne incognita?

easyMCQ

The term ecosystem was coined by:

Ready for a Full Test?

Practice with timed mock tests and track your performance across Accountancy.

Browse TestsLeaderboard

Discussion