Microsoft Office Tutorials and References
In Depth Information
In the Lab
16. Save the workbook using the fi 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 specifi ed by your instructor.
Instructions Part 2: Open the workbook created in Part 1 and save the workbook as Lab 2-1 Part 2
Facade Importers Sales Analysis. 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. Print the worksheet.
Submit the assignment as specifi ed by your instructor.
Instructions Part 3: Open the workbook created in Part 2 and then save the workbook as Lab 2-1
Part 3 Facade Importers Sales Analysis. 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. Print the
worksheet. Submit the assignment as specifi 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 fi 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 >
 
Search JabSto ::




Custom Search