Microsoft Office Tutorials and References
In Depth Information
In the Lab
EX 149
8. Change the document properties, as specifi ed by your instructor. Change the worksheet header
with your name, course number, and other information requested by your instructor. Save the
workbook using the fi le name, Make It Right 2-1 El Centro Diner Payroll Report Corrected.
Submit the revised workbook as specifi ed by your instructor.
In the Lab
Create a workbook using the guidelines, concepts, and skills presented in this chapter. Labs
are listed in order of increasing diffi culty.
Lab 1: Sales Analysis Worksheet
Problem: You have been asked to build a sales analysis worksheet for Facade Importers that determines
the sales quota and percentage of quota met for the sales representatives in Table 2–8. The desired
worksheet is shown in Figure 2–88.
Table 2–8 Facade Importers Sales Data
Sales Representative
Sales Amount
Sales Return
Sales Quota
Polizzi, Bernard
591518
12638
765130
Li, Grace
895050
12015
776381
Volpe, Pamela
716502
18141
733309
Khan, Anwer
709672
22326
566940
Hudson, Emma
802525
11138
712222
Huerta, Teresa
885156
18721
778060
Figure 2–88
Continued >
C6161_EXC_02.4c.indd 149
C6161_EXC_02.4c.indd 149
3/6/07 3:30:17 PM
3/6/07 3:30:17 PM
Search JabSto ::




Custom Search