a) Employees receive a bonus based on their sales. This bonus is a \% increase in their base salary (Enter Logical function in column G) b) Employees receive an additional 10% of their salaries if: (1) new accounts opened are greater than 20 AND, (2) sales are greater than 525,000 (Enter Logical Function in column H ) Employees receive an additional 105 of their salaries if: (1) new accounts opened are greater than 200R, (2) sales are greater than $25,000 (Enter Logical Function in column I) Employees receive in June a mid-year bonus of $1,000 if they have worked for the company for at least 1 year (Enter Logical Function in column J ) e) How much are Deter's total sales for the year? (Enter Logical function in cell M21) 1) How much were Peter's sales for all the months when no new accounts were opened? (Enter togical function in cell M25) B) What is Peter's average sale value? (Enter Logical function in cell M28) h) Count the number of transactions with sales greater than $20,000 (Enter Lgical Function in cell M32)