Modify an excel

User Generated

yvhybatybir

Business Finance

Description

the requirements are in the pictures and do it directly on the Excel. Please follow the steps and do it carefully

Unformatted Attachment Preview

Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 Revenue Categories Lawn Maintenance April $7,886.48 July $7,650.23 August $7,683.30 September Total $46,715.63 Tree & Shrubbery $11,819.93 $11,909.48 $12,043.13 $11,803.28 $11,879.78 $12,226.28 $71,681.85 Patio and Furniture $15,192.23 $13,070.48 $12,957.30 $13,039.88 $15,318.23 $16,876.13 $86,454.23 Design Consulting $7,741.13 June $8,094.38 Fountains and Irrigation $7,660.13 May $4,478.18 $4,708.13 $4,475.25 $5,153.63 $5,514.53 $7,919.55 $32,249.25 $579.38 $585.23 $631.13 $563.18 $584.78 $698.40 $3,642.08 Total Revenue $39,729.83 $38,014.43 $37,993.28 $38,210.18 $40,980.60 $45,814.73 $240,743.03 Step 1 Download start file 1. Open the Classic Gardens-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Create a Clustered Column chart object for cells A4:G9. 3. Move the chart object so that its top left corner is at cell A12. Size the bottom of the chart to reach cell H30. 4. Edit the chart title to display CGL Major Sales Revenue on one line, then press Enter and type Second and Third Quarters on the second line. 5. Apply chart Style 14 to the chart. 6. Format the first line and the second line of the chart title to a font size of 20 pt. 7. Apply a 1/2 point Black, Text 1 outline to the chart area. 8. Verify that the chart is still selected. In the highlighted range in the worksheet, drag the resize pointer to remove the Design Consulting data series from the chart (Figure 3-71). B с F G H 7 8 9 $579.38 $585.23 $631.13 $563.18 $584.78 $698.40 10 11 12 13 14 15 16 17 18 19 20 $18,000.00 $16,000.00 $14,000.00 $12,000.00 $8,000.00 9. Create a 3-D Pie chart for cells DE A4:A9 and cells H4:H9. Move Patio and Furniture $15,192.23 $13,070.48 $12,957.30 $13,039.88 $15,318.23 $16,876.13 $86,454.23 Fountains and Irrigation ! $4,478.18 $4,708.13 $4,475.25 $5,153.63 $5,514.53| $7,919.55 $32,249.25 the chart to its own sheet Design Consulting $3,642.08 named Revenue Breakdown. Total Revenue $39,729.83 $38,014.43 $37,993.28 $38,210.18 $40,980.60 $45,814.73 $240,743.03 Hint: Use the Move Chart button + [Chart Tools Design tab, Location CGL Major Sales Revenue Second and Third Quarters group). 10. Edit the chart title to display Y Revenue by Category. Change the font size to 32. 21 $10,000.00 11. Select the legend and change the font size to 12. 12. Apply the Woven mat texture fill 26 to the Patio and Furniture slice. 13. Add data labels to display in Lawn Maintenance Tree & Shrubbery Patio and Furniture Fountains and Irrigation the center of each slice. a. Display the Format Data Revenue Breakdown Q2&Q3 Labels task pane, choose 3-71 Drag the resize pointer to change the chart data the Accounting format, and set 0 decimal places. b. While the data labels are selected, change the font size to 14 pt and apply bold [Home tab, Font group). 14. Deselect the chart. 22 23 24 25 LLLL $6,000.00 $4,000.00 $2,000.00 $0.00 April May June July August September 27 28 29 30 31 32 15. Save and close the workbook (Figure 3-72). Step 2 Upload & Save 16. Upload and save your project file. 17. Submit project for grading. Step 3 А B F G H Grade my 1 с E Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 Project 2 3 4 5 01 7 Revenue Categories April May June July August September Total Lawn Maintenance $7,660.13 $7,741.13 $7,886.48 $7,650.23 $7,683.30 $8,094.38 $46,715.63 Tree & Shrubbery $11,819.93 $11,909.48 $12,043.13 $11,803.28 $11,879.78 $12,226.28 $71,681.85 Patio and Furniture $15,192.23 $13,070.48 $12,957.30 $13,039.88 $15,318.23 $16,876.13 $86,454.23 Fountains and Irrigatio $4,4 18 $4,7 13 $4,475.25 $5,153.63 $5,5 $7,919.55 $32,249.25 Design Consulting $579.38 $585.23 $631.13 $563.18 $584.78 $698.40 $3,642.08 Total Revenue $39,729.83 $38,014.43 $37,993.28 $38,210.18 $40,980.60 $45,814.73 $240,743.03 00 9 10 11 12 13 CGL Major Sales Revenue Second and Third Quarters 14 15 16 17 18 19 20 21 $18,000.00 $16,000.00 $14,000.00 $12,000.00 $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 22 23 24 25 26 27 28 $0.00 29 April May June July August September 30 Lawn Maintenance Tree & Shrubbery Patio and Furniture 31 Fountains and Irrigation 32 Revenue Breakdown Q2803 Revenue Breakdown Q2&Q3 Revenue by Category $3,642 $32,249 $46,716 $86,454 $71,682 Lawn Maintenance Tree & Shrubbery Patio and Furniture Fountains and Irrigation Design Consulting 3-72 Excel 3-4 completed chart sheets
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags