HELP ME FOR RISK LEVEL $,$ RATE CHARGED, DISCOUNT

(range_lookupl) I table_array, & _ index_num Fly-By-Night Autos Fly-3M-Night Autos, sells used Cars. They help Customers Obtain credit from a local credit union The credit union provided the information below With the "Car Loan Interest Rates" table below that outlines a Of Credit score Cat*OrieS with corresponding credit Scores and interest rates. The Can Offer Customers a loan based on their credit Scores. Complete the "Applicant Information" table to include the risk and rate Charged for if an licant u alif Applicant 108-95-6833 427-78-9221 663-30-1549 965-75-9201 954-324100 950-50-7544 399-334698 486-66-2868 627-904115 444-964839 448-91-9215 829-61-8895 851-82-2783 318-52-7960 718-314886 863-21-8561 516-144871 114-94-8347 325-95-5596 696-14-9890 292-25-3863 600-68-2551 169-92-2691 586-35-2423 263-76-3025 647-28-9552 740-99-2570 34645-9618 114-80-5364 713-784199 Additionally, the has used some target marketing techniques to Offer interest rate promotions for three Zip codes. the "Zip Code Discount" table to a discount based on their address. Applicant Informa tion zip code Risk Level 84578 84602 84043 84003 84003 84003 84578 84604 84003 84578 84003 84043 84578 84003 84043 84003 84602 84604 84602 84003 84578 84604 84043 84578 84578 84604 84604 84604 84578 84602 Rate Charge d Car Loan Interest Rates Zip Code Discount Credit *ore Risk Category Interen 8.50% 7.50% 6.50% Zip Code 84043 0.40% 84604 0.25% 84003 0.10% 500 700 Hint NO Loan Extremely High Very High High Very LOW Extrem LOW 1. VLOOKUP to determine the Risk Level and Rate Charged from Loan Interest Rates" table. 2. H LOOKUP to determine the from "Zip Code Discount" table 3. I FNA function to display NO Discount"