For each one, type your name in cell Al$,$ your class in cell A$2,$ the project number in cell F$1,$ and the date in cell F$2.$ Do not change column widths for these four labels, but allow the longer labels to spill over into the next cell.Project $1$ Class Grades I: Create a class report with headings and columns of proper width for STUDENT NAME, TESTL, TEST $2,1$ED $3,$ and AVERAGE. Lype six names into the worksheet, with three test scores each. Have the spreadsheet automatically calculate and display in the AVERAGE column the average of the three scores for each student.Format all numbers to show no decimal places. Save the workbook as SHEET$1$ and print it$.$Project $2$ Class Grades II: Open SHEET$1.$ Add four names to the list of six and three test scores for each new name. Copy the average formula so that all students show averages. Create a class average row along the bottom. Have the worksheet calculate and display the average for each test column and an overall average in the average column. Format the average column $($not row$)$ to show one decimal. Save the workbook as SHEET$2$ and print it$.$Project $3$ Class Grades III: Open SHEET$2.$ Delete the second student row. Create conditional formatting in the Average COLUMN that will change the font color to red for those students whose average is less than the class average $($at the bottom of the column$).$Create a bar chart that displays each student's name and overall average. Add titles. Label