SOLVE USING EXCEL

Copy the following "Student Data" table to a new sheet (tab). Student Data Student Name ID Age 18 Ann A001 Major FIN HIS Jake A002 19 Tom A003 20 ENG Nina A004 22 HIS Kate A005 20 FIN James A006 22 CS Julie A007 20 HIS Laura A008 21 MTH A. Find the MEAN, MEDIAN, and MODE Age using formulas B. Find the MAXIMUM, MINIMUM Age using formulas C. Check the following condition in each row by using the "OR" function and state 'TRUE or 'FALSE' Condition - "Major HIS and age is less than 20" D. Copy your table in the same sheet; in the duplicate table, create a filtered view that displays only students having FIN major (Note: you must use the Excel filters foature to get credit for this step)