You need to provide a rate for each customer based on their credit score. Any user who has a score less than 600 should be denied. 1. Open case_study1_data and save as case_study1_LastFirst (use your own Last and First name). IF Function - Use the IF Function to figure out if an applicant is eligible for a personal loan. 2. Display the Approval Form worksheet and create an IF statement in cell I3 to determine if the applicant is eligible for a personal loan. Use the criteria below as part of your logic statement: Credit Score < 600 = "Denied" Credit Score >= 600 = "Approved 3. Copy using the Fill Handle the IF statement in cell I3 to into the Range I4:I10. VLOOKUP Function - Use the VLOOKUP Function to determine the rate of for those customers that were approved based on their credit scores. 4. Create a VLOOKUP function in cell J3 that uses the Credit Score in cell F3 to generate a rate based on the array in cells N4:O10. NOTE - Make sure to use the correct cell referencing. 5. Copy using the Fill Handle the VLOOKUP statement in cell J3 to into the Range J4:J10. 6. Delete out any Rate value for those customers that were denied