i need help with this assignment search in document review smartart charts tables do 5176838

I need help with this assignment Search in Document Review SmartArt Charts Tables Document Elements Layout Themes Insert Styles Paragraph Font Aa A A- A- Aa 14 Themes Text Box Styles ABE A A2 Instructions: For the purpose of grading the project you are required to perform the following tasks: 4 Points Possible Instructions Step Download and open the fle named exploring e12c2Schedule.xlsx, and then save the fle as e12c2Schedule LastFirst, replacing Lastfirst with your name. 0.000 1 On the Sequential worksheet, apply the Retrospect theme and the Aspect theme color. Apply Heading 3 cell style to the column labels in the range A4:K4 10.000 2 Record a macro named RoomSort, Click and drag to select the range AM:K46 from the Sequential worksheet, then copy and paste the data in cell A4 of the Room worksheet. Do not stop the recording after this step. With the macro still recording, ck cel 4. On the Data tab, in the Sort &Fiter group, click Sort. Using the Sort dialog box, sort the data by Room in alphabetical order. Add a second level sort that sorts the Days column using the following custom sort order: MWF, MW, M, W. TR, T, R. s. Add a third level sort that sorts the Start Time column from earliest to latest. Retun to the Sequential worksheet, click cell A1 and stop the recording. Save the workbook as a Macro-Enabled Template. 10.000 3 15.000 4 With Al of the Sequential worksheet selected, record a macro named EacultySort Click and drag to select the range M:K46 from the Sequential worksheet, then copy and paste the data in cell A4 of the Faculty worksheet. Do not stop the recording after this step 10.000 With the macro still recording, didk cell A4. Create a custom sort that does the folowing: Sort Instructor in alphabetical order, then by Days with the custom order created in the prior step (Step 4), then by Start Time from earlest to lateest. After the sort is complete, return to cell A1 on the Sequential worksheet and stop recording. 10.000 Insert a form control button filling the range E1:0 in the Sequential worksheet and assign it to the RoomSort macro 16.000 7 Edit the text that appears on the splay the text RoomSort 2.000 Using the prior steps as a quide,, create a second button that displays the text EncultySort filing the range F1H0 and assign it to the EacitySort macro. Once completed, save the macro-enabled template 12.000 Print Layout View Words: Sec Pages 1 of 2 100% 25 40H m Search In Document Layout Document Elements Tables Charts SmartArt Review Font Paragraph Styles Insert Themes EE Ab A A 14 Aa Aa A ABE A A2 ABC Styles Text Box Themes office 2016-mytlab grader-nstructions Exce Projc Step Instructions Points Possible 10 Create a new worksheet named Code to the right of the Faculty sheet 5.000 Open the VBA Editor and display the module containing the room sort. Copy the code beginning with the text Sub RoomSort (0 and ending with the first instance of the text End Sub Paste the contents in cell A1 of the Code worksheet. Ensure that the copied code is formatted as Text. Do not close the VBA Editor, 11 5,000 Display the mopule containing the faculty sort. Copy the code beginning with the text Sub EacubSort 0thd ending with the final instance of the text End Sub Paste the contents in cell F1 of the Code worksheet, Ensure that the copied code is formated as Text. Close the VBA Editor 17 5.000 Save the fle as an Excel Workbook (not macro-enabled) with the name e12c1Schedule solution. Ensure that the workbooks are displayed in the folowing order Sequential, Room, Facuity, and Code. Close the workbook and eit Excel. Submit the e12ctSchedule solutionlsr workbook as directed 13 0.000 Total Points 100.000 Print Layout View Sec Pages: Words 1 of 2 100 % 25 20 F3 44 4ON