than 5 total lessons, display "
0 earned"
. If the student
has had between 5 and 10 lessons, display "
1 earned"
;
otherwise, display " 2 earned"
.
10
In cell E5, use the VLOOKUP function to look up the
student’s uniform size in the
Student_Data table for the
student listed in cell B2 . The value should be looking for
an exact match.
In cell E7, use the HLOOKUP function to retrieve the
student’s registration fee in the
Entry_Fee named range
for the registration type in cell
E3
. The value should be
looking for an exact match.
In cell I13, use the COUNTIF function to count the
number of uniforms in the Student_Data table that meet
the filter criteria in cell H12 .
10