Question 1

In Q15:

Use the appropriate function that will return TRUE if the Gender is Male and the Region is RG4 and the Department is 1202 and the Units Sold Qtr 4 is 5,500 or more.

In cell Q10 use the appropriate function to calculate how many are TRUE.

Question 2

In R15:

Use the appropriate function that will return TRUE if the Region is RG3 or the Age is 64 or the Annual Units Sold is 21,000 or more or the Rating is 1. Copy the function down to the other cells in the column. In cell R10 use the appropriate function to calculate how many are TRUE.

Question 3

In AB10 use the AVERAGEIFS function to calculate the average Salary for female employees with the Job Title Advisor, who are in Region RG3 and are younger than 60 with Annual Units Sold of 21,000 or less.