your name. In the Security Warning bar, click Enable
Content.
2
On the Student Data worksheet, insert a table with
6.000
headers that uses the range $A$11:$G$50. With the
data table selected, create named ranges using the top
row as the names.
3
Copy range A11:G11, and then paste the range in cell
6.000
A1. In cell C2, type Sophomore (no period). In cell D2,
type Microsoft Office (no period).
4
Create an advanced filter using the data in range
8.000
A1:G2. Filter the list in-place to display the filtered data
on the Student Data worksheet. Copy the filtered data
including the headings and then paste it in cell A1 on
the Filter worksheet. AutoFit the columns so all the data
is visible.
5
On the Student Data worksheet, clear the filter. In cell
H11, type TotalDue . In cell H12, enter a formula that
7.000