Class Gradebook$1.$ In this exercise, you will do a simple spreadsheet for a highly simplified version of a class gradebook. Read this all through to the end once before you try it$\mathrm{.}2.$ Start Microsoft Excel. $($Microsoft Excel MUST be used, no other apps allowed. $.$xlsx file format only.$)3.$ Save the spreadsheet as a file called Class Gradebook$\mathrm{.}4.$ Select cells A$1$ through G$8\mathrm{.}5.$ Select the font to Ariel and the size to $11\mathrm{.}6.$ Type Class Gradebook into cell A$1.($Never mind if it "extends" into cell A$2)\mathrm{.}7.$ Select cells A$1$ through G$1-$ make sure they are highlighted. Merge and Center the title over that range$\mathrm{.}8.$ Bold Class Gradebook and set its' font to size $18\mathrm{.}9.$ Now add some column headers $-$ in cells A$3$ through G$3,$ enter Student Test$1$ Test$2$ Homework$1$ Homework$2$ Total Average $($Note that some don't quite fit, that's fine for now.$)10.$ Select cells A$3$ through G$3.$ Find the Cells area in the ribbon at top, then find the Format area inside it$.$ Click on Format, a menu pops down, click on Column Width and set it to $16\mathrm{.}11.$ Note how those columns just got wider$\mathrm{.}12.$ Center each row $3$ column header in its column and change the font of all the column headers to Courier New$\mathrm{.}13.$ Change the font of the row $3$ column headers you just added to Courier New$\mathrm{.}14.$ Now you will add some grade data. In cells A$4$ through E$4,$ enter Bill $9587404515.$ Do NOT change the font or alignment, it will be different from the column headers and that's what we want$\mathrm{.}16.$ In cell F$4,$ add up cells B$4$ through E$4$ with the AutoSum function. Look in the Editing area of the ribbon$\mathrm{.}17.$ Click In cell G$4$ and type $=$Average$($B$4$:E$4)$ then press enter. This uses the Average function to get the average$\mathrm{.}18.$ Now, make up data for $3$ more students, and place it in rows $5,6$ and $7.*$ Max test grade is $100*$ Max homework grade is $50*$ First name only for the student $*$ Pick a variety of grades!$19.$ Add functions $($or copy them$)$ to get the Total and Average values for each row you added$\mathrm{.}20.$ Add the text Class Average in cell F$8\mathrm{.}21.$ Set cell F$8$ font to Courier New$\mathrm{.}22.$ Use the average function in cell G$8$ to get the average of the $4$ numbers above it$\mathrm{.}23.$ Select cells G$4$ through G$8,$ and set the numbers in there to all have $2$ decimal points$\mathrm{.}24.$ Select cells A$3$ through G$7\mathrm{.}25.$ Select Insert on the main menu, find the charts area, and find and click on the Insert Column or Bar Chart icon. Then select the first one on the left, at the top in the $2-$D Column area. It's called a Clustered Column$\mathrm{.}26.$ You will see a chart pop up$.$ Click and drag it so it's just below the table. Roughly center it$\mathrm{.}27.$ Change the chart title to Class Gradebook $\mathrm{.}28.$ Save your file$\mathrm{.}29.$ Your project will be graded according to the following rubric:Grading RubricRequirementsMax Points PossibleTable formatting correct$20$Table data correct$10$Table functions correct$20$Chart present and formatted correctly$10$Total$6030.$ Review your work and make any corrections needed to get the highest score possible. Use the following image as a guide. Some items have been blocked out deliberately$\mathrm{.}31.$ Submit your Class Gradebook Excel file with the usual process$\mathrm{.}32.$ Check the gradebook in a few days for your score and Instructor Feedback, if any.