Westonci.ca is your trusted source for finding answers to all your questions. Ask, explore, and learn with our expert community. Join our Q&A platform and get accurate answers to all your questions from professionals across multiple disciplines. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, which formula is correct?

Sagot :

If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, the correct formula is =LARGE(B11:C20, 6).

What is Excel Formula?

In regards to Microsoft Excel, a formula is seen as a kind of an expression that tends to function on values that can be found within a range of cells.

Note that these formulas are said to often return a result, even if  it is an error. Excel formulas helps a person to carry out calculations such as addition, subtraction, and others.

Thus, If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, the correct formula is =LARGE(B11:C20, 6).

Learn more about Excel formula from

https://brainly.com/question/27927845

#SPJ1