Microsoft Office Tutorials and References
In Depth Information
In the Lab
Instructions Part 4: Open the workbook Lab 5-2 Consultant Specialist Table Final created in Part 3.
If you did not complete Part 3, then open Lab 5-2 Consultant Specialist Table from the Data Files for
Students. Perform the following tasks:
1. Scroll to the right to display cell G1 in the upper-left corner of the window. Enter the criteria in the
range O1:Q3 as shown in Figure 5–79. Enter the row titles in cells O5:O10 as shown in Figure 5–79.
2. Use the database function DAVERAGE and the appropriate criteria in the range O2:Q3 to
determine the average age of the males and females in the range. Use the table function DCOUNT
and the appropriate criteria in the range O2:Q3 to determine the record count of those who are
proﬁ cient in HTML. The DCOUNT function requires that you choose a numeric ﬁ eld in the
table to count, such as Age.
3. Use the SUMIF function to determine the Java Y Sum Count in cell R9. That is, sum the Count
ﬁ eld for all records containing a Y in the Java column. Use the COUNTIF function to determine
the HTML N Count in cell R10.
4. Print the worksheet in landscape orientation using the Fit to option. Save the workbook using the
ﬁ le name, Lab 5-2 Consultant Specialist Table Final. Submit the assignment as requested by your