<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

It is normally used to create forms for others to fill.

It can be used to ensure that the user enters correct value.

If wrong value entered by user,then it can show error or warning message

 

Question 1

Prepare Interest Calculator in following format

 

 Use of Data Validation to make forms - Data Validation

 

User has to fill just white colored cells,it should automatically calculate Interest

Download and try 

 

Q2

Prepare Interest Calculator in following format

 

DATA VALIDATION q2.png

 

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail