hi, could you please write the formulas with answers near the questions and explain what should I do? thank you so much.

COLUMN L4 ASKS CALCULATE THE DEPARTMENTS FEMALE STUDENTS

M4 ASKS CALCULATE DEP. MALE STUDENTS

N4 ASKS CALC. TOTAL MALE STUDS. EXC. PREP.

P4 ASKS CALC. TOTAL FEMALE STUDENTS ALL FACULITIES EXC. PREP

N4 . P FACULTIES TOTAL FAMALE (PREP. EXCL) Y - : X Fox S B C D E F G H I J K L M N O FACULTY FACULT MALE TOTAL L PREP. 1. YEAR 2. YEAR 3.YEAR 4. YEAR TOTA TOTAL (PREP. TOTAL EXCL) 2 F M F M F M F M F M F M 3 Faculty Science 4 Mathematic | 9 | 6 | 13 6 8 8 12 8 10 12 5 Psychology 655 58 14 45 10 496 615 Translator and 13 6 28 32 17 6 12 7 4816 6 interpreter 7 Psychology 12 2 1 1 0 1 0 0 0 0 8 Social 18 9 8 6 0 0 0 0 0 0 9 FACULTY TOTAL 10 11 12 1.In cell L4 Calculate departments Famale Students (drag down) 13 2.In cell M4 Calculate departments Male Students (drag down) 14 3.In cell N4 Calculate faculty total students (drag down) 15 4.In cell 04 Calculate total male students (Preparation excluded). 16 5.In cell P4 Calculate total famale students all faculties (Preparation excluded). 17 6.In cell B9 Calculate all Sums 18 7.Calculate total number of Famale students 2. and 3. year in department Mathematic 20 19 20 21