Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab continued
2. Add an extract range by copying the table title and ﬁ eld names (range A9:M10) to the range A35:M36
(Figure 5–78). Change cell A35 to Extract Area and then color the title area as shown in Figure 5–78.
Use the Name box in the formula bar to name the extract range (range A36:M36) Extract.
3. With the table active, use the Advanced button on the Data tab on the Ribbon to extract records that
pass the tests listed below in a through d. Print the entire worksheet using landscape orientation and
the Fit to option for each extract.
a. Extract the records that represent employees who are male and older than 30 (Figure 5–77 on
the previous page). You should extract seven records (Figure 5–78).
b. Extract the records that represent female employees who are proﬁ cient in Java, but not in RPG.
You should extract two records.
c. Extract the records that represent male employees who are at least 35 years old and are
proﬁ cient in at least four programming languages. The ﬁ eld Count in column M uses the
COUNTIF function to count the number of Ys in a record. A count of 4 means the record
represents a specialist with expertise in four areas. You should extract two records.
d. Extract the records that represent employees who are proﬁ cient in three programming languages
or fewer. You should extract 4 records.
4. 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, Lab 5-2 Consultant Specialist Table Final. Close the workbook.
Submit the assignment as requested by your instructor.