Complete the following $6$ tasks using the data region located to the right $($F$4$:H$19)$ and the criteria located in column K$.$ Data Values Criteria Values

DO NOT HARD CODE CRITERIA VALUES WITHIN THE FUNCTIONS $...$ USE CELL REFERENCES TO COLUMN K Year Month Salary March

Use conditional statements as specified $...$ do NOT cherry pick values from the 'Data Values' region $2021$

$2021$ March $$12,722\mathrm{.}682022$

a$)$ Use the SUMIF function to sum the 'Salary' values for $2023$ $$63,988\mathrm{.}782021$ June $$14,991\mathrm{.}162023$

b$)$ Use the AVERAGEIFS function to average 'Salary' values for March in years following $20222021$ September $$12,040\mathrm{.}11$ $$13,000$

c$)$ Use the COUNTIF function to count the number of records whose salary is greater than $$13,0002021$ December $$14,630\mathrm{.}59$ r

d$)$ Use the SUMIFS function to sum the 'Salary' values for $2021$ with Month names that contain the letter $\text{'}$r$\text{'}$ $$0\mathrm{.}002022$ March $$13,798\mathrm{.}20$

e$)$ Use the COUNTA function to count the number of months $2022$ June $$13,891\mathrm{.}16$

f$)$ Use the AVERAGEIF function to average the 'Salary' values for Month names that end with $\text{'}$r$\text{'}2022$ September $$14,240\mathrm{.}11$

$2022$ December $$11,330\mathrm{.}59$

$2023$ March $$14,377\mathrm{.}21$

$2023$ June $$15,477\mathrm{.}21$

$2023$ September $$17,628\mathrm{.}18$

$2023$ December $$16,506\mathrm{.}18$

$2024$ March $$15,326\mathrm{.}14$

$2024$ June $$14,183\mathrm{.}30$

$2024$ September $$17,841\mathrm{.}24$

$2024$ December $$19,205\mathrm{.}25$

NOTE: Because the function calls in D$5$:D$10$ will not be copied, use RELATIVE references to the Data Values and the Criteria Values Areas