Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Table 6–13 Last Year’s Sales for State Street and Western Avenue Stores
State Street Store
Western Avenue Store
Individual applications
$148,812
$52,864
Integrated applications
140,135
93,182
Entertainment software
62,912
72,345
System software
22,769
25,278
Learning aids
9,562
21,397
Supplies
44,215
34,921
•• 4: Analyzing Annual College Expenses and Resources
Make It Personal
College expenses are skyrocketing and your resources are limited. To plan for the upcoming year, you
have decided to organize your anticipated expenses and resources in a workbook. The data required to
prepare the workbook is shown in Table 6–14.
Table 6–14 Next Year’s Anticipated College Expenses and Resources
Expenses
Semester 1
Semester 2
Summer
Room and Board
5750
5750
2150
Tuition
8750
8750
2200
Books
1200
1450
230
Clothes
575
350
150
Entertainment
600
500
200
Miscellaneous
400
350
175
Resources
Savings
2500
2500
500
Parents
5000
7500
1200
Job
1000
1200
400
Financial Aid
6275
3450
2505
Scholarship
2500
2500
500
Create a template with the data for the fi rst semester in Table 6–14 in mind. Use dummy data in the
template. Sum both the expenses and resources for the semester in the template. Save the template and
then use it to create a workbook with each of the three semesters on a separate worksheet. Use 3-D
cell references to consolidate the data on a worksheet in the workbook. Include a 3-D pie chart that
compares the annual expenses. Use the concepts and techniques described in this chapter to format the
workbook and chart.
•• 5: Creating a Consolidated Budget Proposal Using Linking Techniques
Working Together
Complete the exercise outlined in Cases and Places 1 using separate workbooks for each department,
rather than a single workbook. As a team, create an appropriate template. Assign each member of the
team one or more of the four required workbooks to build using the template. After the workbooks
have been created, use the concepts and techniques presented in this project to consolidate the data by
creating a workspace and linking the workbooks. Test the linkage to the division workbook by changing
values in the department workbooks.
 
Search JabSto ::




Custom Search