Write a formula for column F using logical functions that indicates whether Tesla should give an individual a promotion ("Yes" or "No") If BOTH Q1 and Q2 sales are greater than or equal to $500,000, the employee would receive a promotion (Formula would display Yes). Otherwise, the employee would not earn a promotion (Formula would display No) Step 3. Write a formula for column G using logical functions that calculates the bonus of each individual Only employees who have a positive sales difference (>$0) are eligible to receive a bonus For eligible employees, if Q2 sales are less than or equal to $400,000, the bonus would be $4,000. If Q2 sales are between $400,000 and $600,000 (not inclusive), the employee receives a $5,000 bonus. Any eligible employee with Q2 sales greater than or equal to $600,000 will receive a $6,000 bonus If the employee is not eligible for a bonus, $0 should display in column G You may either use nested IF() functions or the IFS() function or a combination of both Note: column G is already in currency format, so the result of your formula will display correctly with $ signs. Therefore, do not include the $ signs in the formula itself or you will likely get an error when trying to complete step 6 below. (In other words, just type 4000 and not "$4,000" in your formula.) Step 4. Write a formula for column H using logical functions that indicates whether an individual should get a pink slip ("Yes" or "No") If the employees Q1 sales are less than $150,000 OR the sales difference is less than -$300,000, the employee will receive the pink slip (i.e., the formula would display "Yes"). Otherwise, the formula would display "No" Step 5. Count the number of promotions and pink slips In cells K4 and K5, use an excel function to count the number of promotions and pink slips Tesla will be giving out Step 6. Calculate the average bonus for employees being promoted vs. not being promoted In cells K8 and K9, use an excel function to calculate the average bonus based on whether there is a "Yes" or "No" in the Promotion column (column F)