Use of Data Validation to make forms

Last updated at July 28, 2026 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

 

 
 

 

Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.