Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab continued
the table. Click row level symbol 2 and print the table. Click row level symbol 3. Click the Subtotal
button on the Ribbon and then click the Remove All button in the Subtotal dialog box to remove
all subtotals. Close the workbook without saving changes. Submit the assignment as requested by
Instructions Part 5: Open the Lab 5-1 Whitman Publishing Sales Rep Table workbook created in
Part 1. Copy the table (range A7:J20) to a new workbook. Save the new workbook in a CSV (Comma
delimited) ﬁ le format using the ﬁ le name, Lab 5-1 Whitman Publishing Sales Rep Table CSV. Close
the workbook. Start Notepad and open the CSV ﬁ le. Print the CSV ﬁ le. Close Notepad. Open the
CSV ﬁ le in Excel. Quit Excel. Submit the assignment as requested by your instructor.
In the Lab
Lab 2: Sorting, Finding, and Advanced Filtering
Problem: Computer Consultants, Inc. specializes in supplying computer consultants to companies
in need of programmers. The company uses a table (Figure 5–76) that shows whether a consultant is
knowledgeable in a programming language.
The chief ﬁ nancial ofﬁ cer, Cheryl Riiz, has asked you to sort, query, and determine some statistics
from the table. Carefully label each required printout by using the part number and step. If a step results
in multiple printouts, label them a, b, c, and so on.