Given a data file as below. B D 1 SCORE MAJOR GENDER TEACHER 2 F Smith 3 M Smith 4 F Smith 5 M Pan 6 F Pan. 7 M Pan 8 M Pan 9 F Green 10 M Green 11 F Smith 12 M Pan 13 F Smith 14 15 16 MAJOR MIS 17 GENDER 18 TEACHER Smith 19 Minimum Score: 20 Average Score (a) Use XLOOKUP to find the minimum score in Smith class. The formula is to be entered into C19 as below: (b) Use XLOOKUP to find the average score in Smith class. The formula is to be entered into C20 as below: 50 MIS 49 ACCT 68 MOM 75 MOM 90 ACCT 94 ACCT 93 MIS 91 MIS 80 MIS 82 ACCT 64 MOM 98 MOM