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)"

Correct format for a SUMIF statement isSelect one:A.=SUMIF(range, critera,sum_range)B.=SUMIF(range,sum_range,critera)C.=SUMIF(sum_range,critera,range)

Which of the following statements correctly describe the SUMIF and SUMIFS functions?1) The cells to be summed up must be cells that specified the conditions2) The [sum_range] is the last argument of the SUMIF function syntax. But it is the first argument of the SUMIFS function syntax.3) The SUMIFS function sums values that meet multiple criteria4) The SUMIFS function’s condition can be either an ‘AND’ or an ‘OR’ operatorQuestion 11Select one:a.1,4,3b.2,3,1c.1,3d.2,3

Regarding the function SUMIF(range, criteria, [sum_range]), all three arguments required.Question 27Select one:a.Trueb.False

Would SUMPRODUCT function be an option to calculate the total value (quantity X price) of the products listed?Question 2Answera.Not enough information to determine the answer.b.No, they are in separate data sets.c.Yes, the data is suitable for the calculation using SUMPRODUCT.d.No, it does not fulfil the requirements for SUMPRODUCT.

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