Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

excel spreadsheet sheet 0/1 SA 19-EX-05.07 H G D B A 5.a Apply chart Style 14 to the chart. 1 Classic Gardens and Landscapes (CGL)

excel spreadsheet sheet

image text in transcribed

0/1 SA 19-EX-05.07 H G D B A 5.a Apply chart Style 14 to the chart. 1 Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 2 3 FEEDBACK Clustered column chart in worksheet "Q2&Q3" does not have the correct chart style. 4 Revenue Categories April May June July August September Total 5 Lawn Maintenance $7,660.13 $7,741.13 $7,886.48 $7,650.23 $7,68330 $8,094 38 $46,715,63 6 Tree & Shrubbery $11,819.93 $11,909.48 $12,043.13 $11,803.28 $11,879.78 $12,225.28 $71,681.85 17 Patio and Furniture $15,192.23 $13,070.48 $12,957.30 $13,039.88 $15,318.23 $16,876.13 $86,454.23 8 Fountains and Irrigatio $4,478.18 $4,708.13 $4,475.25 $5,153.63 $5,514.53 $7.919.55 $32,249,25 Design Consulting $579.38 $585.23 $63113 $563.18 $584.78 $698.40 $3,642.08 10 Total Revenue $39,729.83 $38,014.43 $37,993.28 $38,210.18 $40,980.60 $45,814.73 $240,743.03 11 > 6 0/1 Format the first line and the second line of the chart title to a font size of 20 pt. 9 0/1 12 Create a 3-D Pie chart for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Tools Design tab, Location group] 13 CGL Major Sales Revenue 6.2. Second and Third Quarters 14 15 16 $18,000.00 10 0/1 Edit the chart title to display Revenue by Category. Set the font size to 32. 17 118 15.a $16,000.00 $14,000.00 19 20 0/1 $12,000.00 11 Select the legend and change the font size to 12. 21 22 $10,000.00 23 SB.000.00 0 / 1 10 and 12 Apply the Woven mat texture fill to the Patio and Furniture slice. 24 $6,000lbo 25 sa chalan 10:14 AM 1/17/202 i Type here to search 0/1 SA 19-EX-05.07 H G D B A 5.a Apply chart Style 14 to the chart. 1 Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 2 3 FEEDBACK Clustered column chart in worksheet "Q2&Q3" does not have the correct chart style. 4 Revenue Categories April May June July August September Total 5 Lawn Maintenance $7,660.13 $7,741.13 $7,886.48 $7,650.23 $7,68330 $8,094 38 $46,715,63 6 Tree & Shrubbery $11,819.93 $11,909.48 $12,043.13 $11,803.28 $11,879.78 $12,225.28 $71,681.85 17 Patio and Furniture $15,192.23 $13,070.48 $12,957.30 $13,039.88 $15,318.23 $16,876.13 $86,454.23 8 Fountains and Irrigatio $4,478.18 $4,708.13 $4,475.25 $5,153.63 $5,514.53 $7.919.55 $32,249,25 Design Consulting $579.38 $585.23 $63113 $563.18 $584.78 $698.40 $3,642.08 10 Total Revenue $39,729.83 $38,014.43 $37,993.28 $38,210.18 $40,980.60 $45,814.73 $240,743.03 11 > 6 0/1 Format the first line and the second line of the chart title to a font size of 20 pt. 9 0/1 12 Create a 3-D Pie chart for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Tools Design tab, Location group] 13 CGL Major Sales Revenue 6.2. Second and Third Quarters 14 15 16 $18,000.00 10 0/1 Edit the chart title to display Revenue by Category. Set the font size to 32. 17 118 15.a $16,000.00 $14,000.00 19 20 0/1 $12,000.00 11 Select the legend and change the font size to 12. 21 22 $10,000.00 23 SB.000.00 0 / 1 10 and 12 Apply the Woven mat texture fill to the Patio and Furniture slice. 24 $6,000lbo 25 sa chalan 10:14 AM 1/17/202 i Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Audit Scams A Threat To Corporate Governance

Authors: Sachi Kheskani

1st Edition

3659490148, 978-3659490149

More Books

Students also viewed these Accounting questions

Question

Explain how program objectives may be developed.

Answered: 1 week ago

Question

Using Language That Works

Answered: 1 week ago

Question

4. Are my sources relevant?

Answered: 1 week ago