Apply the data-validation tool to the Bank Data Excel file with an error alert message box to

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 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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics

ISBN: 9781292095448

2nd Global Edition

Authors: James R. Evans

Question Posted: