New Perspectives Excel 2013 Tutorial 4: SAM Project 1a 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

New Perspectives Excel 2013 Tutorial 4: SAM Project 1a

1. 

On the Rental Cost History worksheet, add blue gradient data bars to the

range I4:I7 (1st column, 1st row in the Gradient Fill section of the Data

2. 

Create column sparklines in the range H4:H8 based on the data in the

range B4:G8. Change the style of the sparklines to Sparkline Style

3. 

Add the chart title Yearly Rental Costs 2011-2016 to the Clustered Column

Chart using the Above Chart title option.

4. 

Add the primary vertical axis title Cost 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 250000.0

6. 

Add Primary Major Vertical Gridlines to the chart.

7. 

Change the position of the Clustered Column Chart’s legend using the

Bottom legend option.

8. 

Create a 3-D Pie Chart based on the range I4:I7. Change the chart title to

Share of Rental Cost and then move the chart so that the top left corner

is in cell H10. (Hint: To ensure proper grading, make sure the corner of

this chart is completely within cell H10, rather than touching the edge of

that cell.)

9. 

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

the range A4:A7.

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 Rental Cost Projection worksheet, create column sparklines in the

range G4:G8 based on the data in B4:F8. Change the style of the

sparklines to Sparkline Style Colorful #4.

13. 

Use the Quick Analysis tool on the range A3:F7 to insert a Clustered

Column chart, using the first Clustered Column Chart recommendation on

the Charts tab. (Note: The columns in this chart are grouped by year.)

Move and resize the chart so that the top left corner is in cell A10 and the

bottom right corner is in cell G27. (Hint: To ensure proper grading, make

sure the corners of the chart are completely within the cells A10 and G27

rather than touching the edges of those cells.)

14. 

Change the chart title of the Clustered Column Chart to Rental Cost

Projection 2017-2021. Then add the Primary Vertical Axis Title Cost to

15. 

Change the major units value for the vertical axis to 250000.0.

16. 

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

the chart style palette.)

17. 

In the 3-D pie chart, change the font size of the title to 14 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.