Which of these is a conditional function and is properly defined?COUNT() 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.AVERAGE() and AVERAGEIF() perform exactly the same wayCOUNTIF() is used to count the number of cells that meet a criterionIF() function alway outputs false

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

COUNTIF can be used in conditional formatiing customized formulas, but not AVERAGEIF, since the order of the arguments can differ True False

_____ Excel function returns TRUE or FALSE based on two or more conditionsGroup of answer choices=CONCAT=AVERAGEIFS=COUNTA=AND

What does = COUNT() function do?Counts cells having alphabetsCounts empty cellsCounts cells having numberCounts non-empty cell

In COUNTIF function, Blank 1 Question 3 component(s) is/are required and Blank 2 Question 3 component(s) is/are optional.Sample: In SUM function, which is =SUM(range), the range is the only component and it is required.