nmdcat.online
Computer Power Point
nmdcat.online May 22, 2026

In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

A. =LARGE(A:A, 2)
B. =LARGE(UNIQUE(A:A), 2)
C. =INDEX(SORT(UNIQUE(A:A), , -1), 2)
✓
D. =SMALL(UNIQUE(A:A), 2)

📖 Additional Information

  • =LARGE(A:A, 2)
  • =LARGE(UNIQUE(A:A), 2)
  • =INDEX(SORT(UNIQUE(A:A), , -1), 2)
  • =SMALL(UNIQUE(A:A), 2)

🔗 Share This Question

Facebook Twitter LinkedIn WhatsApp

🧭 Navigate Questions

Previous Question

Which of the following is last column in MS Excel-2016?

Next Question

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

Back to All Questions

🔗 Related MCQs

If you have a PowerPoint show you created and want to send using email to another teacher you can add the show to your email message as a (an)____________?
May 22, 2026
in the context of animations, what is a trigger in Microsoft PowerPoint?
May 22, 2026
What is a motion path in Microsoft PowerPoint
May 22, 2026
Which file format can be added to a PowerPoint show?
May 22, 2026
In Power Point Speaker’s information is expressed in___________?
May 22, 2026

Categories

View all →