What is the function of the IF function in Microsoft Excel?
A. Tests a condition and returns one value if the condition is true and another value if the condition is false
B. Calculates the sum of a range of cells
C. Calculates the average of a range of cells
D. Counts the number of cells in a range that meet a certain criteria
Answer:A
What is the function of the IF function in Microsoft Excel?
A. Tests a condition and returns one value if the condition is true and another value if the condition is false B. Calculates the sum of a range of cells C. Calculates the average of a range of cells D. Counts the number of cells in a range that meet a certain criteria