Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Instructions Part 3: Open the workbook Lab 1-3 Part 2 College Resources and Expenses and then save
the workbook using the i le name, Lab 1-3 Part 3 College Resources and Expenses. A close inspection
of Table 1– 9 shows that both cost and i nancial support i gures increase 7% each year. Use Excel
Help to learn how to enter the data for the last three years using a formula and the Copy and Paste
buttons (Home tab | Clipboard group). For example, the formula to enter in cell C4 is =B4*1.07. Enter
formulas to replace all the numbers in the range C4:E9 and C13:E19. If necessary, reformat the tables,
as described in Part 1. The worksheet should appear as shown in Figure 1– 81, except that some of
the totals will be off by approximately 0.01 due to rounding errors. Save the workbook. Submit the
assignment as specii ed by your instructor. Close the workbook without saving changes.
Cases and Places
Apply your creative thinking and problem solving skills to design and implement a solution.
1: Analyzing Quarterly Expenses
To estimate the funds needed by your school’s Travel Club to make it through the upcoming quarter,
you decide to create a report for the club itemizing the expected quarterly expenses. The anticipated
expenses are listed in Table 1– 10. Use the concepts and techniques presented in this chapter to create
the worksheet and an embedded Clustered Cylinder chart. Be sure to use an appropriate chart style
that compares the quarterly cost of each expense. Total each expense item and each quarter. Include a
grand total for all of the expenses. Use the AutoCalculate area to determine the average amount spent
per quarter on each expense. Manually insert the averages with appropriate titles in an appropriate area
on the worksheet.
Table 1– 10 Travel Club Quarterly Expenses
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Copies and Supplies
75
50
80
150
Meeting Room Rent
400
425
400
425
Miscellaneous
150
100
175
70
Refreshments
130
155
150
225
Speaker Fees
200
200
400
500
Travel
450
375
500
375
2: Create an Exploded Pie in 3-D Chart to Summarize Property Values
Personal
Your wealthy Aunt Nicole owns several properties of varying value. She would like to see the values
of the properties in a worksheet and chart that helps her to better understand her investments.
She has asked you to develop a worksheet totaling the values of the properties and also to include
other relevant statistics. The property values are: Property 1, \$56,671.99; Property 2, \$82,276.58;
Property 3, \$60,135.45; Property 4, \$107,373.39; and Property 5, \$87,512.82. Create an Exploded pie
in 3-D chart to illustrate the relative property values. Use the AutoCalculate area to i nd the average,
maximum, and minimum property values and manually enter them and their corresponding identii ers
in an appropriate area of the worksheet. Use the Sum button to total the property values.
Continued >
Search JabSto ::

Custom Search