New Perspectives Excel 2013  Tutorial 4: SAM Project 1b Friends of Glasswater Park Create a Fundraising Plan 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

New Perspectives Excel 2013  Tutorial 4: SAM Project 1b

Friends of Glasswater Park

Create a Fundraising Plan

1.  On the 2012-2016 Funds Raised worksheet, add green gradient data bars to the

range H4:H6.

2. Create column sparklines in the range G4:G7 based on the data in the range

B4:F7. Change the style of the sparklines to Sparkline Style Accent 6, Lighter

40%.

3. Add the chart title Facilities Funds Raised 2012-2016 to the Clustered Column

Chart using the Above Chart title option.

4.  Add the primary vertical axis title Amount Raised to the Clustered Column Chart.

5. 

In the Clustered Column Chart, make the following adjustments to the vertical

axis:

a. Change the number format of the vertical axis to Accounting with 0 decimal

places.

b. Change the major units value for the vertical axis to 150000.0

6.  Add Primary Major Horizontal Gridlines to the chart.

7.  Change the position of the Clustered Column Chart’s legend using the Top

legend option.

8.  Create a 3-D Pie Chart based on the data in the range H4:H6. Change the chart

title to Shares Raised By Source and then move the chart so that the top left

corner is in cell H9.

9. In the 3-D Pie Chart, modify the legend labels to use the label text from the

range A4:A6.

10. In the 3-D Pie chart, make the following adjustments:

a. Change the location of the chart legend to Top.

b. Add data labels to the chart and change the label options so that the data

label contains only the Percentage.

11. Change the location of the data labels in the 3-D pie chart using the Outside End

data label option.

12. On the 2017-2020 Projection worksheet, create column sparklines in the range

F4:F7 based on the data in B4:E7. Change the Sparkline style to Sparkline Style

Accent 6, Lighter 40%.

13. Use the Quick Analysis tool on the range A3:E6 to insert a Clustered Column

chart, using the first Clustered Column Chart recommendation on the Charts tab.

(Hint: The columns in this chart are grouped by year.) Move and resize the chart

so that the top left corner is in cell A9 and the bottom right corner is in cell G26.

14.  Change the chart title of the Clustered Column Chart to Projected Facilities

Fundraising 2017-2020. Then add the primary vertical axis title Amount Raised

to this chart.

15.  Change the major units value for the vertical axis to 150000.0.

16.  Change the style of the Clustered Column Chart to Style 7 (7th choice in the

chart styles palette.)

17.  In the 3-D pie chart, change the font size of the title to 16 pt.

18. Remove the legend from the 3-D pie chart.

19.  In the 3-D pie chart, make the following adjustments to the data labels:

a. Change the position of the data labels using the Outside End data label

option.

b. Change the label options so that the data label contains the Category Name

and the Percentage.

c. Change the data label number option to Percentage with 0 decimal places.