Project Description:In this project, you will you will edit a worksheet, with data that has been sorted, filtered, and grouped that analyzes Delivery Modes for programs at Laurel College.Steps to Perform:StepInstructionsPoints Possible1Start Excel. Download, save, and open the workbook named go16_xl_ch05_grader_5f_hw.xlsx. Save it in your Excel Chapter 5 folder as Lastname_Firstname_5F_Career_Programs.xlsx02On the Main-East-West worksheet, insert a table using the range A1:J40. Apply Light Green, Table Style Light 21.Depending upon the Office version used, the style name might be Table Style Light 21.123Sort the values in the Campus column using a custom list in the following order: Main, East, and then West. Add a second level sort by Division and a third level sort by Program Name, both in ascending order. 154On the Delivery Mode Comparison worksheet, copy the range A6:G7. Paste it in cell A1, change the title in cell A1 to Criteria and then name the range A2:G3 Criteria.155Copy the range A1:G2, and paste it into cell A36. Change the title in cell A36 to Online-Hybrid Delivery Mode and then name the range A37:G37 Extract. Select the range A7:G34, and then name this range Database.156Create an advanced filter that will place in the extract area the records from the Database range in which Online is the primary delivery mode and Hybrid is the secondary delivery mode.127Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend.108Apply subtotals to the Program Chair Stipend column at each change in Division. AutoFit columns C: D and then collapse the outline so that the Level 2 summary information is displayed.89Group all three worksheets. Insert a footer in the left section that includes the file name, and in the right section, insert the Sheet Name. Center the worksheets Horizontally, and then set the Width and Height to 1 page.Note, Mac users, handle each sheet individually, if necessary.1110Show all the properties, and then as the Tags, type career programs As the Subject, type your course name and section number. Be sure your name displays as the Author.211Save the workbook. Ensure that the workbook contains the following sheet tabs, in this order: Main-East-West, Delivery Mode Comparison, and Stipends by Division. Close the workbook, and then exit Excel. Submit the workbook as directed.0Total Points100

View the first 40 minutes of the facsinating video below about this eccentric artist whose photographic work had a great impact on the way we view and think about movement and capturing movement with the photographic medium. The video also talks about California back in the 1800's and gives an interesting view of what life was like then. Write a minimum of 250 words of your impressions of Muybridge and his work as well as summarize the video in your own words.