Question 1 is using iferror and data validation

Exercise 1: Contributions are classified as follows: Under $100: Supporter $100 to $399: Patron $400 to $999: Fellow $1000 or more: Elite Create a worksheet which allows you to enter a contribution amount (input) and then will automatically display the contributor's classification (output). Use a lookup table (you create the table). Also, if the user enters an invalid contribution amount, the worksheet should display the error message 'Please enter a valid contribution amount". Exercise 2: You are employed as a work study student on campus and have been asked by a professor to create a spreadsheet to help with final grade reporting. The professor would like to record final grades for 10 students. The first column should contain the student's last name (input), the second column should contain the student's first name (input), and the third column should contain the student's final course percentage grade (input) --enter as a whole number, not a percent...ie: 85 not .85 or 85%. The fourth column will be the output and will use a LOOKUP formula to calculate the letter grade earned in the course. The professor's grading scale is as follows: A 90-100 B 80-89 70-79 60-69 F Below 60 C D