Check sibling questions

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

 

 

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.