n 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.

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

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.IF() function alway outputs falseCOUNTIF() is used to count the number of cells that meet a criterionAVERAGE() and AVERAGEIF() perform exactly the same way

In the syntax of VLOOKUP (value, table, col_index, [range_lookup]), the [range_lookup] is said to be optional to specify. Which option correctly defines its function? Ops: A. TRUE = approximate match (default), FALSE = exact match B. TRUE = Exact match (default) C. FALSE = approximate match D. TRUE = exact match, FALSE = approximate match (default) Q 04. What will be the output of COUNTIFS(A1:A10,"<>red") if A1 to A10 contains different colour names? Ops: A. Cells not containing red B. All cells C. Cells containing red except first cell D. Cells only containing red

Which of the following aggregate functions does not ignore null values -Options: Pick one correct answer from belowMax(attribute)Count(attribute)Min(attribute)Count(*)Both ii) and iv)Both i) and iii)