Microsoft Office Tutorials and References
In Depth Information
In the Lab
8. Change the document properties, as speciﬁ 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 ﬁ le name, Make It Right 2-1 El Centro Diner Payroll Report Corrected.
Submit the revised workbook as speciﬁ ed by your instructor.
Create a workbook using the guidelines, concepts, and skills presented in this chapter. Labs
are listed in order of increasing difﬁ 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