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 



Prepare Interest Calculator in following format





Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.