STEP1, In cell C9, use the IF function to determine the class year for the credits given in cell C6. NOTE: Use "First-year", "Sophomore", "Junior", "Senior" as class years in the arguments of the IF function. STEP2, in cells D13:D16, enter the left-hand endpoints for the ranges given in cells C13:C16. In cells E13:E16, enter the class years corresponding to ranges given in cells C13:C16. STEP3, In cell C20, use the VLOOKUP function to determine the class year for the credits given in cell C6. (I need a step by step with formulas for cells)

c moowowmnwwn L _1_| do 12 13 14 15 16 17 18 19 20 21 22 Credits V Last First Student: Credits: 3.) Year: (using the IF function) VLOOKUP Table Intervals for Left Hand Credits Endpoints Class Year 0.. 32 b.) 31.64 b.) 6536 b.) 97.. b.) c.) Year: (using the VLOOKUP function)