Question

Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell C9. What output will result from this formula?

Answer 1

Answer: 780

Explanation:

SMALL(C2:C6,4) = 780

Answer 2

Correct Answer is-

#NUM!

Explanation:

• Because there is no screenshot given above so without appropriate data this is the only output that will result from the formula =SMALL(C2:C6,4) written in cell C9 in MS EXCEL.
• While opening MS EXCEL, go to cell C9 and enter =SMALL
• Insert the opening round bracket
• Either enter the other cells or shift click cell C2 and C6 which will select cells from C2 to C6
• And then a comma and 4 and close the bracket and hit enter.
• There will be the answer which cell number is written after the selected cells.
• Whatever number or words are written in the 4th cell will be the final answer.

#SPJ2