Q. What does the CHOOSE function do in Excel?

A
Selects a value from a list based on an index
B
Counts items
C
Sorts data
D
Calculates averages
Solution:

CHOOSE() selects a value from a list of options based on a given index number.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!