Question: Apply the data-validation tool to the Bank Data Excel file with an error alert message box to ensure that a two-digit number is correctly entered
Apply the data-validation tool to the Bank Data Excel file with an error alert message box to ensure that a two-digit number is correctly entered under Age, the data entered under ZipCode should not exceed 5 digits, and the Education field takes the values 1, 2 and 3 for ‘undergraduate’, ‘graduate’ and ‘post graduate’
respectively. Enter some fictitious additional data to verify that your results are correct.
Step by Step Solution
3.44 Rating (151 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
