In cell AA$14$ use the SUBTOTAL Function only to calculate the average Gross Monthly Salary for all employeesBlank $1($Format as comma style, $0$ decimal$)$

Filter the data to show female employees with Rating of $5$ or more from ON$.$

The Subtotal value in AA$14$ should update to show the result for the filtered data.

Enter $($type$)$ this new Subtotal value into cell AB$14($the value should remain when the filters are cleared$).$

What is the new Subtotal value?Blank $2($Format as comma style, $0$ decimal$)$