Use of Data Validation to make forms

Last updated at April 16, 2024 by

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 

DATA VALIDATION ASSIGNMENT.xlsx

 

Q2

Prepare Interest Calculator in following format

 

DATA VALIDATION q2.png

 

 
 

 

Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

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