In cell AC10 use the SUBTOTAL Function only to calculate the highest Units Sold Qtr 2 for all employeesBlank 1 (Format as comma style, 0 decimal) Filter the data in the table to show the records for employees from Regions RG1 or RG3 who have the Job Title of Manager or Advisor and have a Rating of more than 3. The Subtotal value in AC10 should update to show the result for the filtered data. Enter (type) this new Subtotal value into AD10 (the value should remain when the filters are cleared) and below. Blank 2 (Format as comma style, 0 decimal) Clear the filters. Blank 1 Add your answer In cell AC10 use the SUBTOTAL Function only to calculate the highest Units Sold Qtr 2 for all employeesBlank 1 (Format as comma style, 0 decimal) Filter the data in the table to show the records for employees from Regions RG1 or RG3 who have the Job Title of Manager or Advisor and have a Rating of more than 3. The Subtotal value in AC10 should update to show the result for the filtered data. Enter (type) this new Subtotal value into AD10 (the value should remain when the filters are cleared) and below. Blank 2 (Format as comma style, 0 decimal) Clear the filters. Blank 1 Add your