Exp19_Excel_Ch01_CapAssessment_Training | Exp22 Excel Ch01 Training |

Описание: #Exp19_Excel_Ch01_CapAssessment_Training #Excel_Ch01_CapAssessment_Training #Ch01_Cap_Training #Training #Exp19_Excel_Ch01_CapAssessment_Training.xlsx #Exp22 #Exp19_Ch01_CapAssessment_Training #Ch01_CapAssessment_Training
#Exp19_Excel_Ch01_CapAssessment_Training #Ch01 #Ch01_Training #Exp22 #Ch01_Cap_Training #Ch01_Training.xlsx #Training #Exp19_Excel_Ch01 #Exp22 #Exp19_Excel_Ch01_CapAssessment_Training #Exp19_Ch01_CapAssessment_Training
#Excel_2019_Project #Exp19_Excel_Ch01_Training #Exp19_Excel #Exp22 #Exp19_Excel_Ch01_CapAssessment_Training
#Exp19_Excel_Ch01_CapAssessment_Training.xlsx


Contact
WhatsApp 1: +923137183201
WhatsApp 2: +923458962216
Email:: : [email protected]
Direct WhatsApp link
Link : https://wa.me/923137183201

#Exp19_Excel_Ch01_CapAssessment_Training #Excel_Ch01_CapAssessment_Training #Ch01_Cap_Training #Training #Exp19_Excel_Ch01_CapAssessment_Training.xlsx #Exp19_Ch01_CapAssessment_Training #Ch01_CapAssessment_Training
#Exp19_Excel_Ch01_CapAssessment_Training #Ch01 #Ch01_Training #Ch01_Cap_Training #Ch01_Training.xlsx #Training #Exp19_Excel_Ch01

Exp22_Excel_Ch01_CumulativeAssessment

Project Description:
You manage a company that provides corporate training workshops. Your two types of clients are business people and college professors. You want to complete a spreadsheet that calculates gross revenue for upcoming training workshops. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp22_Excel_Ch01_CumulativeAssessment_Training.xlsx. Grader has automatically added your last name to the beginning of the filename.

Use Find and Replace to find Teacher and replace it with Education.

Check the spelling of the worksheet and correct the errors.

Delete the row containing the Charting Basics workshop.
Insert a new row between the Big Data Foundations and Data Mining rows. Copy row 5 and paste it on the empty row. Change the dates to June 7, 2024 in the range C7:D7. Enter 11 in cell G7 and 10 in cell H7.
Format the dates in the range C5:D10 with Short Date format
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
Merge and center the cells H3 and I3. Merge and center the range J3:L3.

For the range A4:L4, apply the Good cell style, wrap text, and center horizontally.

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:E10.

Apply Number format with zero decimal places and center the results horizontally in the range E5:E10.

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.

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.
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.
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
Format the range G5:G10 as Percent Style with zero decimal places and center the data horizontally.
#Exp22
Format the ranges F5:F10, J5:L10 with Accounting Number Format with zero decimal places.

Right-align data in the range H5:I10 and increase the indent two times. 5
Apply Outside Borders to the range H4:I10.
Select Landscape orientation.
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
Set a 1.5-inch top margin, 0.5-inch left and right margins, and center the worksheet horizontally on the page.

Change the scaling to 90%.
24 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 of the Sheet1 worksheet. 6
25 The worksheet is named Sheet1, which is not meaningful. You want to add a meaningful sheet name so that it will display in the footer. In addition, the Sheet2 worksheet is empty and should be deleted.

Rename Sheet1 as June and then delete Sheet2. 3
26 Save and close Exp22_Excel_Ch01_CumulativeAssessment_Training.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100







#Exp19_Access_Ch04_HOEAssessment_Conference.accdb
#Exp19_Access_Ch02_HOEAssessment_Drama
#Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb
#Exp19_Access_Ch04_HOEAssessment - Leadership Conference 1.1
#Exp22_Excel_AppCapstone_IntroAssessment_Travel
#Exp19_Access_Ch03_CapAssessment_Retirement_Accounts.accdb
#Excel_2F_Bonus
#Excel_2E_Dessert_Inventory
#Exp22_Excel_Ch06_Cumulative_AutoSales