DO NOTHARD

DSE HARD CODE CRITERIA VALUES WITHIN THE FUNCTIONS $...$ USE CELL REFERENCES TO COLUMN K

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

a$)$ Use the SUMIF function to sum the 'Salary' values for $2022$

b$)$ Use the AVERAGEIFS function to average 'Salary' values for June in years following $2021$

c$)$ Use the COUNTIF function to count the number of records whose salary is greater than $$15,000$

d$)$ Use the SUMIFS function to sum the 'Salary' values for $2022$ with Month names that contain the letter $\text{'}$e$\text{'}$

e$)$ Use the COUNTA function to count the number of months

f$)$ Use the AVERAGEIF function to average the 'Salary' values for Month names that end with $\text{'}r\text{'}$

NOTE: To assist with grading AND because the function calls in D$5$:D$9$ will not be copied, use RELATIVE references to the Data Values and the Criteria Values Areas