Question: Cell A1 contains the number 3. Which formula returns the text Apple?

1. `=SELECT(A1, "Banana", "Orange", "Apple", "Mango")`
2. `=CHOOSE(A1, "Banana", "Orange", "Apple", "Mango")`
3. `=CHOOSE(A1,"Banana","Orange","Apple","Mango")`
4. `=MATCH(A1,{"Banana","Orange","Apple","Mango"})`

Answer: The correct answer of the above question is Option C:`=CHOOSE(A1,"Banana","Orange","Apple","Mango")`