SAM Project 1aCassandra’s

Illustrated Excel 2016 | Module 3: SAM Project 1aCassandra’s GradesFORMATTING A WORKSHEETGETTING STARTEDOpen the file IL_EX16_3a_FirstLastName_1.xlsx, available for download fromthe SAM website.Save the file as IL_EX16_3a_FirstLastName_2.xlsx by changing the “1” to a “2”.oIf you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.With the file IL_EX16_3a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.oIf cell B6 does not display your name, delete the file and download a new copy from the SAM website.PROJECT STEPS1.Cassandra will finish her Spring classes in the coming weeks. She is using an Excel workbook to analyze her grades to help her focus on the classes that needmore improvement. Cassandra has asked you to format her workbook to make the analysis clearer and easier to understand.Switch to the Grades worksheet. Use AutoFit to resize column A to fit its contents.2.Set the width of column E to approximately 14.00, so that the word “Composition”is completely visible in cell E4.3.Apply the Accent5 cell style to the range A1:E1, then increase the font size in that range to 15 pt.4.Merge and center the range A3:E3, then bold the cell contents. 5.Center the text in the range B4:E4 and change the font color of the range to White, Background 1 (1st column, 1st row of the Theme Colors palette).6.Use the Format Painter to apply the format from the range A7:E7 to the range A9:E9.7.Italicize the contents of cell A11and change its font to Times New Roman.8.In the range A11:E11, apply Thick Outside Borders to the cells, then change the fill color to Yellow (4th column, 1st rowof the Standard Colors palette).9.Cassandra wants to know at a glance which courses she is passing. In the range B11:E11, use Conditional Formatting Highlight Cells Rules to format cells whose contents are greater than 70 with Green Fill with Dark Green Text.