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