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