What is the purpose of the IF function in Excel?a.To perform logical tests and return one value if the condition is true and another value if it's falseb.To count the number of cells in a rangec.To calculate the average of a range of cellsd.To add up the values in a range of cells

What is the purpose of the IFS function in Excel?1 pointIt replaces nested IF functions where more than one condition is tested.It combines the IF function with conditional formatting.It counts the number of cells that meet a specific criterion.It returns the sum of the cells that meet a specific criterion.

Which of these is a conditional function and is properly defined?IF() function alway outputs falseCOUNTIF() is used to count the number of cells that meet a criterionAVERAGE() and AVERAGEIF() perform exactly the same wayCOUNT() counts the number of cells that are not empty in a range while COUNTA() counts the number of cells in an array that have a number value in them.I don't know

Which of the following is not among the Logical functions category of excel?  IFNA IFERROR AND DAVERAGE

When using IF statements in Microsoft Excel we are required to make a decision on whether criteria is either true or false

Which Excel function would one use if they want to make sure that all of the conditions in a certain set are met?=IF=OR=AND