4.5k views
5 votes
17) If you want to find the average salary (with each employee's salary found in column C) for those who are full time employees (which will have "FT" in column B), you would use the ________ function.

A. COUNTAVERAGE


B. IFAVERAGE


C. AVERAGE


D. AVERAGEIF

2 Answers

5 votes

Answer:

Average

Step-by-step explanation:

If you want to find the average salary (with each employee's salary found in column C) for those who are full time employees (which will have "FT" in column B), you would use the AVERAGE function.

User Fanhk
by
4.2k points
5 votes

Answer:

AVERAGE

Step-by-step explanation:

THIS is a function used in Microsoft Excel.

The steps to find average is

  • Sum/Total

Hence

first we use AUtoSUM function to find sum then we use average to calculate

User Leo Selig
by
4.7k points