6) Use one of the Lookup functions (i.e., LOOKUP, VLOOKUP, or HLOOKUP) to automatically assess and assign final grades based on the total points column. You should find this data on the “Grade Table” worksheet in the spreadsheet. Make sure the data in the worksheet is correct, and use this worksheet to assign final grades. (Using a LOOKUP function is one of the required tasks.) 7) Using the IF function, format the workbook so each student’s information also shows either a

Question

6)	Use one of the Lookup functions (i.e., LOOKUP, VLOOKUP, or HLOOKUP) to automatically assess and assign final grades based on the total points column. You should find this data on the “Grade Table” worksheet in the spreadsheet.  Make sure the data in the worksheet is correct, and use this worksheet to assign final grades.  (Using a LOOKUP function is one of the required tasks.) 7)	Using the IF function, format the workbook so each student’s information also shows either a