Microsoft Office Tutorials and References
In Depth Information
In the Lab
EX 151
16. Save the workbook using the ﬁ le name Lab 2-1 Part 1 Facade Importers Sales Analysis. Print the
entire worksheet in landscape orientation. Print only the range A3:B10.
17. Display the formulas version by pressing CTRL + ACCENT MARK ( `). Print the formulas version using
the Fit to option button in the Scaling area on the Page tab in the Page Setup dialog box. After
printing the worksheet, reset the Scaling option by selecting the Adjust to option button on the
Page tab in the Page Setup dialog box and changing the percent value to 100%. Change the display
from the formulas version to the values version by pressing CTRL + ACCENT MARK ( `). Do not save
the workbook.
18. Submit the assignment as speciﬁ ed by your instructor.
Instructions Part 2: With the workbook created in Part 1, manually decrement each of the six values
in the net sales column by \$10,000.00 until the percent of quota sold in cell B14 is below, yet as close
as possible to, 100%. All six values in column E must be incremented the same number of times.
The percent of quota sold in B14 should equal 99.85%. Update the worksheet header and save
the workbook as Lab 2-1 Part 2 Facade Importers Sales Analysis. Print the worksheet. Submit the
assignment as speciﬁ ed by your instructor.
Instructions Part 3: With the percent of quota sold in cell B14 equal to 99.85% from Part 2, manually
decrement each of the six values in the sales return column by \$1,000.00 until the percent of quota
sold in cell B14 is above, yet as close as possible to, 100%. Decrement all six values in column C the
same number of times. Your worksheet is correct when the percent of quota sold in cell B14 is equal
to 100.12%. Update the worksheet header and save the workbook as Lab 2-1 Part 3 Facade Importers
Sales Analysis. Print the worksheet. Submit the assignment as speciﬁ ed by your instructor.
In the Lab
Lab 2: Balance Due Worksheet
Problem: You are a spreadsheet intern for Jackson’s Bright Ideas, a popular Denver-based light ﬁ xture
store with outlets in major cities across the western United States. You have been asked to use Excel to
generate a report (Figure 2–89) that summarizes the monthly balance due. A graphic breakdown of the
data also is desired. The customer data in Table 2–9 is available for test purposes.
Table 2–9 Jackson’s Bright Ideas Monthly Balance Due Data
Customer
Beginning Balance
Credits
Payments
Purchases
Costa, Dan
160.68
18.70
99.33
68.28
Hernandez, Abraham
138.11
48.47
75.81
46.72
Mc Cartan, John
820.15
32.11
31.23
29.19
Paoli, Pam
167.35
59.32
52.91
33.90
Ramirez, Alberto
568.34
55.17
18.53
36.34
Vaughn, Noah
449.92
25.90
82.05
99.77
Xiong, James
390.73
48.12
19.35
92.13
Continued >
C6161_EXC_02.4c.indd 151
C6161_EXC_02.4c.indd 151
3/6/07 3:30:19 PM
3/6/07 3:30:19 PM
Search JabSto ::

Custom Search