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
Copies and Supplies
Meeting Room Rent
2: Create an Exploded Pie in 3-D Chart to Summarize Property Values
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.