Question: steps 11 through 15 please om Table Shape Collaborate 11 5 You are ready to calculate the number of days for the workshops. In cell

steps 11 through 15 please

om Table Shape Collaborate 11 5 You are ready to calculate the number of days for the workshops. In cell E5, 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. The results may display in date format. Copy the formula to the range E6:E 10. Created On: 09/10/2020 3 EXR12.Excel.ChAL.ConAssessment - Training 17 Excel 2019 Project Grader - Instructions Points Possible Instructions Step all aul ile 'S 5 12 The number of days results show dates rather than values. Applying the Number format will solve this issue, Apply Number format with zero decimal places and center the results horizontally in the range E5.E10. 5 No 13 The gross revenue is calculated by type of customer. Column J is designed to display the gross revenue for corporate customers. In cell J5, enter a formula to calculate the gross corporate revenue for the first workshop by multiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range J6:J10 14 Column K is designed to display the gross revenue for education Customers. In cell K5, enter a formula to calculate the gross education revenue by subtracting the education discount rate from 1, multiplying the result by the cost per attendee and multiplying by the number of education attendees. Copy the formula to the range K6:10 15 Now that you calculated the gross revenue for corporate and education customers, you can calculate the total gross revenue for each workshop. In cell L5, enter a formula to calculate the total gross revenue by adding the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula to the range L6-L10. om Table Shape Collaborate 11 5 You are ready to calculate the number of days for the workshops. In cell E5, 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. The results may display in date format. Copy the formula to the range E6:E 10. Created On: 09/10/2020 3 EXR12.Excel.ChAL.ConAssessment - Training 17 Excel 2019 Project Grader - Instructions Points Possible Instructions Step all aul ile 'S 5 12 The number of days results show dates rather than values. Applying the Number format will solve this issue, Apply Number format with zero decimal places and center the results horizontally in the range E5.E10. 5 No 13 The gross revenue is calculated by type of customer. Column J is designed to display the gross revenue for corporate customers. In cell J5, enter a formula to calculate the gross corporate revenue for the first workshop by multiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range J6:J10 14 Column K is designed to display the gross revenue for education Customers. In cell K5, enter a formula to calculate the gross education revenue by subtracting the education discount rate from 1, multiplying the result by the cost per attendee and multiplying by the number of education attendees. Copy the formula to the range K6:10 15 Now that you calculated the gross revenue for corporate and education customers, you can calculate the total gross revenue for each workshop. In cell L5, enter a formula to calculate the total gross revenue by adding the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula to the range L6-L10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

please comment so I can share you the link to excel file EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap...

EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your...

Need help asap thank you so much! I need help espeically with the structured reference for question 1. If you can help with all three formulas that would be awesome. from the SAM website. 10 PROJECT...

File Draw Home Formus Data Rew View Hop Share Comments FIP Page Layout 2.1 E Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Becaule from the Intumat can contain views....

There are only 7 formulas I need help with. Thank you! 2 Standard Inputs 3 Daily Meal Allowance 4 Airport Parking Daily Rate 5 Mileage Rate to/from Airport 6 Roundtrip Miles to Airport Travel Expense...

I am in need of some help with these excel project steps. I think I have included all the necessary images of the excel data. Thank you! PROJECT STEPS 1. Tiana Morales is the director of the customer...

1 Start Excel. Download and open the file named e01_grader_h 1.xlsx . 0 2 Merge and center the Travel Expense Report title in the range A1:E1. 3 3 In cell E5, enter a formula that calculates the...

Grader - Instructions Excel 2019 Project Exp19_Excel_Ch07_Cap_Real_Estate Project Description: You are the office manager for a real estate company northern Utah County. You tracked real estate...

PROJECT STEPS 1 . Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has been keeping track of the support calls the center receives, and...

formulas for 1a-1e. BIU-aba X, X A Styles Editing AA A Font Paragraph Styles the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the...

Draw the d-orbital splitting diagrams for the octahedral complex ions of each of the following. a. Fe2+ (high and low spin) b. Fe3+ (high spin) c. Ni2+ d. Zn2+ e. Co2+ (high and low spin)

In Figure P2.4.7, determine the water pressure [in kilo-pascals (kPa)] in the pipe if h1 = 20.0 cm and h2 = 67.0 cm. Also determine the change in liquid height h1 for a 10 cm change in h2 if the...

What is a key difference between traditional IRAs and Roth IRAs regarding distribution requirements? A) Roth IRAs do not have required minimum distributions (RMDs) during the account owner's lifetime...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question Can group-term insurance be provided for self-employed persons or S corporation shareholders?

Question How small a group can be covered under group-term insurance and are there any special rules for small groups?

Question How can an executive determine whether it is better to defer compensation and pay the taxes later or to receive the compensation currently and pay taxes at relatively low income tax rates?