multiplies TotalSessions and Rate. Format the TotalDue
column as Currency with 0 decimal places. Create a
named range for the TotalDue column that uses the
column heading as the name.
6
Insert a slicer for the Subject field. Select both Science 10.00
and Math in the Subject slicer. Drag the Subject slicer 0
so the upper left corner is in the top left corner of J1.
Drag the bottom edge of the Subject slicer to adjust the
height so that the extra white space is no longer visible
and the height is 2.1". Apply Slicer Style Dark 5 to the
slicer.
7
In cell F6, use the SUBTOTAL function and insert a
formula that counts the number of cells in the
LastName field that are not empty. In cell F7, use the
SUBTOTAL function and insert a formula that averages
the cells in the Rate field. In cell F8, use the SUBTOTAL
function and insert a formula that sums the cells in the
TotalDue field.
10.00
0