From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Change the parameters of a data validation

Change the parameters of a data validation - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Change the parameters of a data validation

“

- [Instructor] We have applicants that we are evaluating here, and we need your help to modify our setup. Alright so, first of all, put the data into a table. And then next, the creativity technical skill experience in portfolio columns, right now they accept one through three. Your help is needed to change this to accept whole numbers zero through five. Then in the returning column, you see all these crazy stuff. Peta as a returning applicant, I think so. We can't use that. Please use data validation to change this to a lowercase y, or a lowercase n as the only acceptable inputs. Then clean up that column, meaning get rid of that I think so. And then turn TJ's uppercase Y into a lowercase y. Then always test you work and then finally, center the values in columns D through G. Pause the video, work it out, come back, and I'll show you a solution. All right. Let's get at it so we can let the applicants know…

Contents