Microsoft Office Tutorials and References
In Depth Information
In the Lab
Instructions Part 3:
1. Start Excel. Open the workbook Lab 3-1 Salioto Auto Parts Eight-Year Financial Projection. Do
not save the workbook in this part. Divide the window into two panes by dragging the horizontal
split box between rows 6 and 7. Use the scroll bars to show both the top and bottom of the
worksheet. Using the numbers in columns 2 and 3 of Table 3-10, analyze the effect of changing
the annual sales growth (cell B4) and annual price decrease (cell B5) on the net incomes in row 24.
The resulting answers are in column 4 of Table 3–10. Submit the workbook or results of the what-if
analysis for each case as requested by your instructor.
Table 3–10 Salioto Auto Parts Data to Analyze and Results
Case
Annual Sales Growth
Annual Price Decrease
Year 8 Resulting Net Income
in Cell I24
1
7.45%
5.25%
174,568
2
12.75%
3.00%
6,677,903
3
1.65%
(3,552,156)
7.25%
2. Close the workbook without saving it, and then reopen it. Use the What-If Analysis button on the
Data tab on the Ribbon to goal seek. Determine a margin (cell B6) that would result in a Year 8 net
income of \$2,000,000 (cell I24). You should end up with a margin of 40.68% in cell B6. Submit the
workbook with the new values or the results of the goal seek as requested by your instructor. Do
not save the workbook with the latest changes.
In the Lab
Lab 2: Modifying a Weekly Payroll Worksheet
Problem: As a summer intern at Britney’s Music Emporium, you have been asked to modify the
weekly payroll report shown in Figure 3–87a on the next page. The workbook, Lab 3-2 Britney’s Music
Emporium Weekly Payroll Report, is included with the Data Files for Students. See the inside back