Q$1.$ Generate random grades for HW$01,$ HW$02,$ HW$03,$ HW$-$Bonus, Midterm and Final in columns D$,$ E$,$ F$,$ G$,$ I, J using RANDBETWEEN function. Range values are defined $.$ above the columns. For example; defined mininum and maximum ranges for HW$01$ is in cells D$3,$ and D$4$

Q$2.$ Calculate average homework grade of top three homeworks using the LARGE function in column $H$

Q$3.$ Calculate Weighted$-$Grade in column K using the weights defined in cells K$1,$ K$2$ and K$3$ for HW$-$Average, Midterm and Final, respectively.

Q$4.$ Compute the letter grade per student using IFIFS by referencing the IF table in Grade$-$Catalog in the other sheet. Please do this calculation in column L$.$

Q$5.$ Compute the letter grade per student using VLOOKUP by referencing the VLOOKUP table in Grade$-$Catalog in the other sheet. Please do this calculation in column M$.$

Q$6.$ Color the Weighted$-$Grades that are FF in red and AA in green using Conditional Formatting.

HW$-$Bonus

Grade$-$Catalog