Question

suppose =SMALL(C2:C6,4) is entered into cell C9. what is output will result from this formula?

Answer 1

Answer:

sry I didn't understand the question hope this it is very useful to you and add me as a brainly

Answer 2

Answer:

The output of the result is 4

Explanation:

The SMALL Function is a Statistical function in Excel. It will return numeric numbers depending on their position in a value-ordered list. It just computes and delivers the k lowest value in a dataset.

The SMALL function can be used in financial analysis to determine the lowest value in a given set of values. For example, if all salespeople are given the same aim, we may determine which one met the sales target in the least amount of time in a given year.

Syntax

=SMALL(array,k)

• The SMALL function uses the following arguments:
• Array (required argument) – This is an array or range of numerical data for which we want to find the k smallest value.
• K (required argument) – This is the smallest value from the given array.

=SMALL(C2:C6,4)

4th smallest number in Third column (4)

4

=SMALL(B2:B6,2)

2nd smallest number in the second column (3)

3

Reference Link

https://brainly.in/question/17320695