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

Which of these is a conditional function and is properly defined?AVERAGE() 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.IF() function alway outputs falseCOUNTIF() is used to count the number of cells that meet a criterion

If cells A1 and A2 are empty, what will be the value of the following Excel formula? =A1*A2Group of answer choicesValue! error2Name? error0

Which function can be used to calculate the average of a range of values in Excel?Group of answer choicesSUMAVERAGECOUNTMAX

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

Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA