Question:
What is meant by 'Data Validation'? What is facilitated by 'Error Alert Tab'?
What is meant by 'Data Validation'? What is facilitated by 'Error Alert Tab'?
Show Hint
Use Data Validation to ensure data integrity. Always set an Error Alert to inform users.
Updated On: Jul 4, 2025
Hide Solution
Verified By Collegedunia
Solution and Explanation
Data Validation allows you to control the type of data or values users enter into a cell. The Error Alert Tab in the Data Validation dialog helps customize alert messages to guide or warn users when incorrect data is entered.
Was this answer helpful?
0
0
Top Questions on Basic Knowledge of Excel
- As per the requirements of the user, Excel gives an option to change chart elements. State the options available to change the 'Shape Outline'.
- CBSE CLASS XII - 2025
- Accountancy
- Basic Knowledge of Excel
- Name the error which occurs when Excel doesn't recognize a Text formula. Give any two solutions to correct it.
- CBSE CLASS XII - 2025
- Accountancy
- Basic Knowledge of Excel
- State the advantages of 'Pivot Table' report.
- CBSE CLASS XII - 2025
- Accountancy
- Basic Knowledge of Excel
- Explain the 'ROUND' function in Excel.
- CBSE CLASS XII - 2025
- Accountancy
- Basic Knowledge of Excel
- Explain 'ROUND' function of Excel.
- CBSE CLASS XII - 2025
- Accountancy
- Basic Knowledge of Excel
View More Questions
Questions Asked in CBSE CLASS XII exam
Rupal, Shanu and Trisha were partners in a firm sharing profits and losses in the ratio of 4:3:1. Their Balance Sheet as at 31st March, 2024 was as follows:
(i) Trisha's share of profit was entirely taken by Shanu.
(ii) Fixed assets were found to be undervalued by Rs 2,40,000.
(iii) Stock was revalued at Rs 2,00,000.
(iv) Goodwill of the firm was valued at Rs 8,00,000 on Trisha's retirement.
(v) The total capital of the new firm was fixed at Rs 16,00,000 which was adjusted according to the new profit sharing ratio of the partners. For this necessary cash was paid off or brought in by the partners as the case may be.
Prepare Revaluation Account and Partners' Capital Accounts.- CBSE CLASS XII - 2025
- Partnership Accounts
- Explain giving three reasons why tropics show greatest levels of species diversity.
- CBSE CLASS XII - 2025
- Biodiversity
- The element of dilemma, between humanity and patriotism, elevates the character of Dr. Sadao in ‘The Enemy’. Support your answer with evidence from the text.
- CBSE CLASS XII - 2025
- Literature
- Find: \[ \frac{dy}{dx}, \quad \text{if} \quad y = x \tan x + \frac{\sqrt{x^2 + 1}}{2} \]
- CBSE CLASS XII - 2025
- Differentiation
- Solve for \( x \), \[ 2 \tan^{-1} x + \sin^{-1} \left( \frac{2x}{1 + x^2} \right) = 4\sqrt{3} \]
- CBSE CLASS XII - 2025
- Trigonometric Functions
View More Questions