$1.$ Brittany wants to determine several totals and averages for active employees.$$In cell Q$9,$ enter a formula using the COUNTIF function and structured references to count the number of employees who can work as lifeguards.