Please read first photo for instructions then answer second photo using proper formulas. Please zoom in for clearer pictures.

1st photo is the instructions 2nd is the problem.

broken down picture for 2nd photo

The project problem is on next sheet; the current worksheet is for explanatior if someone's salary is #1, display 1 in M7; if #2, display 2. if #3, display 3. If someone's length on job (LOJ) is #1, display 1 in M8; if #2. display 2: if #3, display 3. Millennium Manufacturing. Inc. Skills involved: (1) Lookup. (2) IFested IF. (3) SUMIF. (4) COUNTIF. Tasks Part 1: Year 2002 Budget - Salaries (5) references. (6) pivot table. (7) common functions such as MIN/MAX Lookup an employee's Salary & length on job (LOJ) by Lynda Fields. Acct Temp Total points: 24 +2 = 26 Learn by yourself (below) Enter Emp ID below: OR: ===========> Enter/Lname 9/10/01 For tasks 1 & 2. students Due EOB Friday 12/04; IF submitted by Saturday 5 PM, 11/28, need to learn the functic 1 IF the emplyee's salary is among top-3, display ranking: Enter Lname 5 Skills involved: (1) Lookup. (2) IFested IF. (3) SUMIF. (4) COUNTIF (5) references. (6) pivot table. (7) common functions such as MIN/MAX Total points: 24 +2 = 26 Learn by yourself (below) For tasks 1 & 2. students need to learn the functic LARGE and functoin SN (Search online) 1 2 IF the emplyee's salary is among top-3. display ranking IF the emplyee's LOJ is among top-3, display ranking: | Enter Lname: v): ES IF the emplyee's salary is among top-3. display ranking F the emplyee's LOJ is among top-3, display ranking 2 Enter/Lname 9/10/01 For tasks 1 & 2. students Due EOB Friday 12/04; IF submitted by Saturday 5 PM, 11/28, need to learn the functic 1 IF the emplyee's salary is among top-3, display ranking: Enter Lname 5 Skills involved: (1) Lookup. (2) IFested IF. (3) SUMIF. (4) COUNTIF (5) references. (6) pivot table. (7) common functions such as MIN/MAX Total points: 24 +2 = 26 Learn by yourself (below) For tasks 1 & 2. students need to learn the functic LARGE and functoin SN (Search online) 1 2 IF the emplyee's salary is among top-3. display ranking IF the emplyee's LOJ is among top-3, display ranking: | Enter Lname: v): ES IF the emplyee's salary is among top-3. display ranking F the emplyee's LOJ is among top-3, display ranking 2