Which Excel functions can serve as alternatives to a series of nested IF() statements? (Select TWO that apply)IFS()SUMPRODUCT()LET()SWITCH()

It's commendable that you recognize the contextual advantages of each in different scenarios. Have you ever encountered a situation where combining both if-else and switch statements provided a particularly elegant or efficient solution to a coding challenge?

when can we use switch case and if else if statements

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 the following is a VALID SUMPRODUCT satement?" =SUMPROD(RANGE1,RANGE2)/SELECT CELL"" =SUMPROD(RANGE1,RANGE2/CELL)/SELECT CELL"" =SUMPRODUCT(RANGE1,RANGE2)/SELECT CELL"" =SUMPRODUCT(RANGE1,RANGE2)/CELL(RANGE1,RANGE2)"

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