Rename Sheet1 Sales and change the worksheet tab color to Light Blue
Step
Instructions
Points Possible
1
Start Excel. Download and open the file named Excel_Bu01_Assessment_AutoBody.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.
0
2
Rename Sheet1 Sales and change the worksheet tab color to Light Blue. Rename Sheet2 Documentation
2.4
3
To improve the readability of the worksheet, you center the worksheets titles. On the Sales worksheet, set the horizontal alignment for cell ranges A1:H1 and A2:H2 to Center Across Selection.
1.6
4
To allow for future formatting of the title, increase the height of row 1 only to 30 Hide row 3.
1.6
5
In cell H4, type Total In cell A15, type Total
0.8
6
To save time entering data, use the fill handle to copy cell B4 through G4. To make the worksheet visually appealing, in cell range B4:H4, apply the Angle Counterclockwise orientation.
2.4
7
Next you want to total the services by month. In cell range B15:G15, enter a function to calculate the monthly totals.
2.4
8
In cell range H5:H15, enter a function to calculate the total of each service offered.
2.4
9
Continue formatting the worksheet by completing the following: In cell range A4:H4, apply Heading 3 cell style. In cell A1, apply Title cell style. In cell A2, apply Heading 4 cell style.
2.4
10
To improve the readability of the worksheet numbers, in cell ranges B5:H5 and B15:H15, apply the Accounting Number Format.
1.6
11
To align the numbers with the totals in cell range B15:H15, in cell range B6:H14, apply the Comma Style format.
1.6
12
In cell range B15:H15, apply Total cell style.
1.6
13
In cell ranges B5:H5 and B15:H15,decrease the decimals to zero decimal places. In cell range B6:H14, decrease the decimals to zero decimal places.
1.6
14
In cell A17, type Average In cell A18, type Largest In cell A19, type Smallest Right-align cell range A17:A19.
1.6
15
Next, you want to analyze the data in the worksheet. In cell B17, use a function to determine the average sales for January.
1.6
16
In cell B18, use a function to determine the largest sale for January.
1.6
17
In cell B19, use a function to determine the smallest sale for January.
1.6
18
Copy the formulas in cell range B17:B19 through cell range C17:G19. If necessary, decrease the decimals to zero decimal places.
1.2
19
In cell range B5:G14, apply a conditional format to highlight any sales less than 1000 with Light Red Fill.
1.6
20
Now that the Sales worksheet is complete, hide the Gridlines.
0.8
21
To quickly format the workbook apply the Mesh workbook theme. If you do not have the Mesh theme, browse for the downloaded theme Mesh.thmx.
1.6
22
Click the Documentation worksheet. In cell A8, type 5/18/2022 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 Wrap the text of cell C8. In cell B20, type Sales
1.6
23
Enter the File Name code in the left footer of both worksheets. Check the spelling of both worksheets, and make any necessary corrections.
2.8
24
To ensure the worksheet prints properly, change the scaling of the Sales worksheet to Fit all Columns to One Page. Change both worksheets to Landscape orientation.
1.6
25
Save and close Excel_BU01_Assessment_AutoBody.xlsx. Exit Excel, and then submit your file.
0