Which function returns the leftmost five characters in cell A1?
- =FIND(A1,1,5)
- =SEARCH(A1,5)
- =LEFT(A1,5)
- =A1-RIGHT(A1,LEN(A1)-5)
The correct answer is:
- =LEFT(A1,5)
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers
- Which formula returns the value in cell A10 of the worksheet named Budget Variances?
- Which function returns TRUE if cell A1 contains a text value?