EX16 XL_CHO1 GRADER_CAP_AS - Training Workshops 1.6 Project Description: You manage a company that provides training workshops. F corporate training workshops. Your two types of cients are business You want to complete a spreadsheet that calculates gross revenue for upcoming Finally, you wi improve the appearance of the worksheet by applying font, alignment, and number formats Instructions: For the purpose of grading the project you are required to perform the following tasks Step Instructions Start Excel. Download and open the fle named eOL grader alxsx Copy the range AS:GS and paste the data below the Big Deta Analytics row. For the pasted data, change the start date to 6/25/2018 and the end date to 6/29/2018. Cange the # of Coporate Attendees to 10 and the # of Eduation Attendees to 10. Merge and center the cells F3 and G3. Merge and center the range H3:33. Apply Bold and Green font color to the range F3:33 For the range A4.34, apply the Good cell style, wrap text, and center horizontaly eIo- 113 Insert a column to the right of the End Date column. Type # of Days in cel D. 13-94 In cell DS, enter a formula to calculate the number of days for the first workshop. Add 1 to the results to include the total number of days, including the start and end dates. Copy the 7 formula to the range D6:D9..83 8 Apply Number format with zero decimal places to the range DS:D9 Increase indent three times for the range D5:D9. P-112-113 Delete the row containing the Adv. Project Management workshop. You canceled this 10 workshop because only one person registered for it 94-9S Updated: 11/13/2017 Current Instruction doox tn cel 15, enter a formula to calculate the gross corporate mutiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range 16:18 In cell ) education discount rate from 1, 5, enter a formula to calculate the gross education revenue by subtracting the mulbiplying the result by the cost per attendee and mutplying 12 by the number of education attendees. Copy the formule to the range 36:38 In cel KS, enter a formula to add the Corporate Gross Revenue and the Education Gross 13 Revenue. Copy the formula to the range K6:KB. rs p. 114 14 Format the ranges ES:EB, 15:KB with Accounting Number Format with zero decimal places 15 114 Change the width of columns F, G, and H to 9 16 97 Apply Outside Borders to the range G5:HB. Apply Outside Borders to the range 15.X8 17 113 18 Select Landscape orientation 123-12 Set a 1.5-inch top margin and center the worksheet horizontally on the page. 19 Change the scaling to 90%. 20 P3-ar 123-1 21 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. 22 Save the workbook Close the workbook and then edt Excel. Submit the workbook as directed Total Points 100 Updated: 11/13/2017 EX16 XL_CHO1 GRADER_CAP_AS - Training Workshops 1.6 Project Description: You manage a company that provides training workshops. F corporate training workshops. Your two types of cients are business You want to complete a spreadsheet that calculates gross revenue for upcoming Finally, you wi improve the appearance of the worksheet by applying font, alignment, and number formats Instructions: For the purpose of grading the project you are required to perform the following tasks Step Instructions Start Excel. Download and open the fle named eOL grader alxsx Copy the range AS:GS and paste the data below the Big Deta Analytics row. For the pasted data, change the start date to 6/25/2018 and the end date to 6/29/2018. Cange the # of Coporate Attendees to 10 and the # of Eduation Attendees to 10. Merge and center the cells F3 and G3. Merge and center the range H3:33. Apply Bold and Green font color to the range F3:33 For the range A4.34, apply the Good cell style, wrap text, and center horizontaly eIo- 113 Insert a column to the right of the End Date column. Type # of Days in cel D. 13-94 In cell DS, enter a formula to calculate the number of days for the first workshop. Add 1 to the results to include the total number of days, including the start and end dates. Copy the 7 formula to the range D6:D9..83 8 Apply Number format with zero decimal places to the range DS:D9 Increase indent three times for the range D5:D9. P-112-113 Delete the row containing the Adv. Project Management workshop. You canceled this 10 workshop because only one person registered for it 94-9S Updated: 11/13/2017 Current Instruction doox tn cel 15, enter a formula to calculate the gross corporate mutiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range 16:18 In cell ) education discount rate from 1, 5, enter a formula to calculate the gross education revenue by subtracting the mulbiplying the result by the cost per attendee and mutplying 12 by the number of education attendees. Copy the formule to the range 36:38 In cel KS, enter a formula to add the Corporate Gross Revenue and the Education Gross 13 Revenue. Copy the formula to the range K6:KB. rs p. 114 14 Format the ranges ES:EB, 15:KB with Accounting Number Format with zero decimal places 15 114 Change the width of columns F, G, and H to 9 16 97 Apply Outside Borders to the range G5:HB. Apply Outside Borders to the range 15.X8 17 113 18 Select Landscape orientation 123-12 Set a 1.5-inch top margin and center the worksheet horizontally on the page. 19 Change the scaling to 90%. 20 P3-ar 123-1 21 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. 22 Save the workbook Close the workbook and then edt Excel. Submit the workbook as directed Total Points 100 Updated: 11/13/2017
