A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $650, and $600. What function could be used to return the third largest value

Question

contestada

Respuesta :

supabrains supabrains · Answer 1 · 2020-03-13T04:45:39+01:00

Answer:We use the Large Function. the general formula is =LARGE(first cell:last cell,3) .Please refer to the explanation section for details

Explanation:

Let us assume

A 1 = $1,250, A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600

Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;

=LARGE(A1:A2,3)

andromache andromache · Answer 2 · 2022-03-10T12:05:44+01:00

The function that should be used for returning the third largest value should be =LARGE(first cell:last cell,3)

Since the values are given i.e. $1,250, $1,090, $985, $985, $880, $756, $675, $650, and $600.

So here we assume A1 = $1,250 A2 = $1,090 and so on

So based on the given values, the function that need to be used is

=LARGE(A1:A2,3)

Learn more about sales here: https://brainly.com/question/20115597