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

• =SELECT(A1, “Banana”, “Orange”, “Apple”, “Mango”)
• =CHOOSE(A1, “Banana”, “Orange”, “Apple”, “Mango”)
• =CHOOSE(A1,”Banana”,”Orange”,”Apple”,”Mango”)
• =MATCH(A1,{“Banana”,”Orange”,”Apple”,”Mango”})

The correct answer is:

• =CHOOSE(A1, “Banana”, “Orange”, “Apple”, “Mango”)
• =CHOOSE(A1,”Banana”,”Orange”,”Apple”,”Mango”)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers