In cell J8, insert the AVERAGEIF function to calculate the average salary for executives. Use mixed references to the range and for the cell containing Executives. Copy the function to cell J9.