Pronursingexperts.com empowers students by providing them with the tools they need to succeed. By alleviating the burden of homework assignments, students can focus on gaining a deeper understanding of their coursework, engaging in extracurricular activities, and developing essential life skills. Academic success is not solely about grades; it’s also about building confidence. When students receive well-researched and impeccably written assignments from Pronursingexperts.com, they gain confidence in their abilities. This newfound confidence often translates into improved performance in their classes. In the ever-evolving landscape of education, Pronursingexperts.com stands as a beacon of support, guiding students towards academic excellence. With its unwavering commitment to quality, individual attention, and timely delivery, Pronursingexperts.com has rightfully earned its reputation as the best academic writing company. By assisting students in their academic endeavors, this platform is not just completing homework; it’s building the foundation for a brighter, more successful future for students around the world.
YO_Excel16_BU01_PS2_v2
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now
Project Description:
You are the office manager for Jim’s Auto Shop. A new body shop just opened a few blocks away, and your boss, Jim Love, is concerned that sales have declined. He has started a workbook of services offered at the auto shop and included the last six month’s sales. He has asked that you complete the workbook by creating formulas to calculate the total sales of each service. Jim also wants you to determine the largest-selling service at the auto shop and to call attention to these services by formatting them appropriately. From this completed workbook, Jim will determine whether he should continue to offer all services or focus on fewer services to stay competitive.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Open the downloaded file named e01_grader_h2_AutoBody.xlsx. Save the file with the name e01_grader_h2_AutoBody_LastFirst, using your last and first name. |
0 |
|
2 |
Rename Sheet1 Sales. Rename Sheet2 Documentation. |
2 |
|
3 |
On the Sales worksheet, set the horizontal alignment for A1:H1 and then A2:H2 to Center Across Selection. |
4 |
|
4 |
Increase the height of row 1 to 30. Hide row 3. |
4 |
|
5 |
Click cell H4, and type Total. Click in cell A15, and type Total. |
2 |
|
6 |
Select cell B4. Use AutoFill to fill the months through G4. Apply the Angle Counterclockwise orientation to cell range B4:H4. |
6 |
|
7 |
In cell range B15:G15, use a function to calculate the monthly totals. |
6 |
|
8 |
In cell range H5:H15, use functions to calculate the total of each service offered. |
6 |
|
9 |
Select cell range A4:H4, and then apply the Heading 3 style to the cell range. Select cell A1, and then apply the Title style. Select cell A2, and then apply Heading 4 style. |
6 |
|
10 |
Select cell ranges B5:H5 and B15:H15, and then apply the Accounting Number Format. |
4 |
|
11 |
Select cell range B6:H14, then apply the Comma style format. |
4 |
|
12 |
Select cell range B15:H15, and then apply the Total style. |
4 |
|
13 |
Select cell ranges B5:H5 and B15:H15, and then decrease the decimals to zero decimal places. |
4 |
|
14 |
In cells A17, A18, and A19, enter the labels Average, Largest, and Smallest respectively. Right-align cell range A17:A19. |
4 |
|
15 |
In cell B17, use a function to determine the average sales for January. |
4 |
|
16 |
In cell B18, use a function to determine the largest sale for January. |
4 |
|
17 |
In cell B19, use a function to determine the smallest sale for January. |
4 |
|
18 |
Copy the formulas in cell range B17:B19 to cell range C17:G19. If necessary, decrease the decimals to zero decimal places. |
4 |
|
19 |
Select cell range H5:H14. Apply the Gradient Fill Light Blue Data Bar to the range of cells. |
4 |
|
20 |
Select cell range B5:G14, and apply a conditional format to highlight any sales less than $1,000 with Light Red Fill. |
4 |
|
21 |
Hide the Gridlines of the Sales worksheet. |
4 |
|
22 |
Click the Documentation worksheet. In cell A8, type today’s date. In cell B8, type your name in the Firstname Lastname format. In cell C8, type Calculated totals for the services and products for the past six months (no period). Wrap the text of cell C8. In cell B20, type Sales. |
4 |
|
23 |
Enter the file name code in the left footer of both worksheets. Check the spelling of both worksheets, and make any necessary corrections. |
7 |
|
24 |
Change the scaling of the Sales worksheet to Fit all Columns to One Page. Change both worksheets to Landscape orientation. |
5 |
|
25 |
Save your workbook, exit Excel, and then submit your file as directed by your instructor. |
0 |
|
Total Points |
100 |
Pronursingexperts.com recognizes that students often encounter challenging assignments that may be beyond their current skill level or require more time than they can spare due to their busy schedules. The platform steps in to provide valuable academic support by offering assistance with a wide range of assignments. Whether it’s a complex research paper, a challenging math problem set, or a literary analysis, Pronursingexperts.com ensures that students receive the guidance they need to excel. Every student is unique, and so are their academic needs. Pronursingexperts.com recognizes this and offers customized solutions. Students can communicate directly with their assigned writers, providing specific instructions and guidelines. This personal touch ensures that each assignment reflects the student’s individual style and preferences. Meeting deadlines is a critical aspect of academic success. Pronursingexperts.com understands this and prioritizes punctuality. The platform is known for its ability to deliver assignments promptly, even when facing tight schedules. This reliability allows students to submit their work on time, relieving them of the stress associated with late submissions.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
