Microsoft Office Tutorials and References
In Depth Information
In the Lab
Table 5–7 Whitman Publishing Sales Rep Table Filter Criteria
Filter
Region
Div
Dist
Rep
Lname
Fname
Age
Gender
Quota
Sales
1
M
2
C
3
3
2
D
2
4
2
>5,000,000
5
>30
F
6
>40 and < 50
7
>50
>3,500,000
8
1
D
9
1
<39
F
>4,000,000
10
M
>=5,500,000
11
>=500
12
All
All
All
All
All
All
All
All
All
All
Instructions Part 3: Open the workbook Lab 5-1 Whitman Publishing Sales Rep Table created in Part 1.
Do not save the workbook in this part. Sort the table according to the following six sort problems. Print
the table for each sort problem in landscape orientation using the Fit to option (or write down the last
name in the ﬁ rst record for submission to your instructor). Begin problems 2 through 6 by sorting the
Rep ﬁ eld in ascending sequence to sort the table back into its original order.
1. Sort the table in descending sequence by region.
2. Sort the table by district within division within region. All three sort keys are to be in ascending
sequence.
3. Sort the table by division within region. Both sort keys are to be in descending sequence.
4. Sort the table by representative number within district within division within region. All four
sort keys are to be in ascending sequence.
5. Sort the table in descending sequence by sales.
6. Sort the table by district within division within region. All three sort keys are to be in descending
sequence.
7. Hide columns I and J by selecting them and pressing CTRL + 0 (zero). Print the table. Select
columns H and K. Press CTRL + SHIFT + RIGHT PARENTHESIS to display the hidden columns. Close
the Lab 5-1 Whitman Publishing Sales Rep Table workbook without saving changes. Submit the
assignment as requested by your instructor.
Instructions Part 4: Open the Lab 5-1 Whitman Publishing Sales Rep Table workbook created in
Part 1 and complete the following tasks. Do not save the workbook in this part.
1. Click a cell in the table to activate the table. Click the Design tab on the Ribbon and then click
the Total Row check box to remove the total row. Sort the table by district within division within
region. Select ascending sequence for all three sort keys.
2. Select cell A8. Right-click anywhere in the table, point to the Table command on the shortcut
menu, and then click the Convert to Range command on the Table submenu. When Excel dis-
plays the Microsoft Ofﬁ ce Excel dialog box, click the Yes button to convert the table to a range.
Click the Data tab on the Ribbon and then click the Subtotal button on the Ribbon. When Excel
displays the Subtotal dialog box, click the ‘At each change in’ box arrow and then click Region #.
If necessary, select Sum in the Use function list. In the ‘Add subtotal to’ list, click Quota and Sales
to select them and then click the OK button. Print the table. Click row level symbol 1 and print
Continued >

Search JabSto ::

Custom Search