Create and apply an Advanced filter so that only records where the student is female and is enrolled in a Yoga class are displayed. Select A14:E107, and then name the cell range Enrollment. Copy range A14:E14, and then paste in range A1:E1 to set up the advanced filter criteria area. Enter the following filter criteria. In cell C2, type F In cell E2, type Yoga

B C D E F G . T K L M N C Class Fee Gender F Class Name Yoga 1 Student ID 2 3 4 5 Field Fee Clear Gender II Fee Class Z23 A22 A22 Y23 539 we Z23 6 7 7 Number of Records 8 Average Fee 9 Total Revenue 10 11 12 13 14 Student ID 15 X2396G23 16 X6260G23 17 X2637G23 18 X6649623 19 X3307G23 20 T4742G23 21 T1011623 22 T6528G23 23 T2068G23 24 X8696G23 25 T9032G23 2016 26 TS 701623 VEC42022 27 X6613G23 28 T5406G23 29 T5178G23 30 X5420G23 31 T4814623 32 X9593G23 33 T1993G23 34 34 T4370G23 35 X3127G23 36 X2204623 37 T4313523 38 T3335G23 F M M F M F F M M F Z23 A22 Z23 A39 T22 han J49 za Z23 A39 T22 F F M F M M F M M Class_Name $75.00 Ti Chi $25.00 Step Aerobics $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $75.00 Tai Chi $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Ti Chi $30.00 Aerobics $30.00 Aerobics $25.00 Step Aerobics $30.00 Aerobics 539 A22 Z23 A39 T22 349 539 A22 $39 F M F F F B C D E F G . T K L M N C Class Fee Gender F Class Name Yoga 1 Student ID 2 3 4 5 Field Fee Clear Gender II Fee Class Z23 A22 A22 Y23 539 we Z23 6 7 7 Number of Records 8 Average Fee 9 Total Revenue 10 11 12 13 14 Student ID 15 X2396G23 16 X6260G23 17 X2637G23 18 X6649623 19 X3307G23 20 T4742G23 21 T1011623 22 T6528G23 23 T2068G23 24 X8696G23 25 T9032G23 2016 26 TS 701623 VEC42022 27 X6613G23 28 T5406G23 29 T5178G23 30 X5420G23 31 T4814623 32 X9593G23 33 T1993G23 34 34 T4370G23 35 X3127G23 36 X2204623 37 T4313523 38 T3335G23 F M M F M F F M M F Z23 A22 Z23 A39 T22 han J49 za Z23 A39 T22 F F M F M M F M M Class_Name $75.00 Ti Chi $25.00 Step Aerobics $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $75.00 Tai Chi $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Tai Chi $30.00 Aerobics $25.00 Step Aerobics $75.00 Tai Chi $30.00 Aerobics $75.00 Ti Chi $30.00 Aerobics $30.00 Aerobics $25.00 Step Aerobics $30.00 Aerobics 539 A22 Z23 A39 T22 349 539 A22 $39 F M F F F