Reference no: EM132262646
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.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions
1 Start Excel. Download and open the file named e01_grader_a1.xlsx.
SAVE AS: Lastname.Firstname-ExcelCh1-TrainingWorkshops.xlsx
Hint: If you are working on a school or public computer, do not allow your files to save to the Downloads folder on a school or public computer.
Remember use SAVE AS and save to your S:/drive or other storage.
2 Copy the range A5:G5 and paste the data below the Big Data Analytics row.
For the pasted data, change the start date to 6/25/2018 and the end date to 6/29/2018.
Change the # of Corporate Attendees to 10 and the # of Education Attendees to 10.
Hint: Select A5:G5. On the Home tab in the Clipboard group, click Copy.
3 Merge and center the cells F3 and G3. Merge and center the range H3:J3.
Hint: On the Home tab, in the Alignment group, click Merge & Center.
4 Apply Bold and Green font color to the range F3:J3.
Hint: On the Home tab, in the Font group, click Font Color.
5 For the range A4:J4, apply the Good cell style, wrap text, and center horizontally.
Hint: On the Home tab, in the Styles group, click Cell Styles.
6 Insert a column to the right of the End Date column. Type # of Days in cell D4.
Hint: On the Home tab, in the Cells group, click Insert.
7 In cell D5, 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 formula to the range D6:D9.
Hint: Subtract B5 from C5 and then add 1. =C5-B5+1 **parenthesis are not needed because Addition and Subtraction are on the same level in PEMDAS.
8 To the range D5:D9, Apply Number format with zero decimal places.
Hint: On the Home tab, use the tools in the Number group.
9 Increase indent three times for the range D5:D9.
Hint: On the Home tab, in the Alignment group, click Increase Indent.
10 Delete the row containing the Adv. Project Management workshop. You canceled this workshop because only one person registered for it.
Hint: Right-click the row 6 heading, and select Delete.
11 In cell I5, 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 I6:I8.
Hint: Multiply E5 by G5. =E5*G5
12 In cell J5, 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 J6:J8.
Hint: Multiply E5 by (1-F5) and then multiply by H5. =(1-F5)*E5*H5
13 In cell K5, enter a formula to add the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula to the range K6:K8.
Hint: Add I5 to J5. =I5+J5
14 Format the range F5:F8 with Percent Style.
On the Home tab, in the Number group, click Percent Style.
Hint: On the Home tab, in the Number group, click Percent Style.
15 Format the ranges E5:E8, I5:K8 with Accounting Number Format with zero decimal places.
Hint: On the Home tab, in the Number group, click Accounting Number Format.
16 Change the width of columns F, G, and H to 9.
Hint: Click in cell F2, on the Home tab, in the Cells group, click Format.
17 Apply Outside Borders to the range G5:H8. Apply Outside Borders to the range I5:K8.
Hint: On the Home tab, in the Font group, click Borders.
18 Select Landscape orientation.
Hint: On the Page Layout tab, in the Page Setup group, open the Dialog Box to complete steps 18, 19, 20, & 21.
19 Set a 1.5-inch top margin and center the worksheet horizontally on the page.
Hint: On the Page Layout tab, in the Page Setup group, open the Dialog Box to complete steps 18, 19, 20, & 21.
20 Change the scaling to 90%.
Hint: In the Page Setup dialog box, click the Page tab and change the Scaling.
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.
Hint: In the Page Setup dialog box, click the Header/Footer tab, Custom Header ...
22 SAVE, CLOSE and SUBMIT the workbook.
Did you remember to name your file using our naming convention? See step 1 -- SAVE AS: Lastname.Firstname-ExcelCh1-TrainingWorkshops.xlsx
Attachment:- Instructions.rar