Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › LEFT, RIGHT, MID

LEFT, RIGHT, MID: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1 has EXCEL2026. What will this formula return?
    =LEFT(A1,5)
    • A. EXCEL
    • B. EXCE
    • C. 2026
    • D. L2026
    Show the answerA — EXCEL. LEFT takes 5 characters from the start: EXCEL.
  2. A1 has EXCEL2026. What will this formula return?
    =RIGHT(A1,4)
    • A. 026
    • B. L202
    • C. EXCEL
    • D. 2026
    Show the answerD — 2026. RIGHT takes 4 characters from the end: 2026.
  3. A1 has EXCEL2026. What will this formula return?
    =MID(A1,3,3)
    • A. XCE
    • B. CEL
    • C. EXC
    • D. EL2
    Show the answerB — CEL. MID starts at character 3 and takes 3: C, E, L.
  4. A1 has EXCEL2026. What will this formula return?
    =LEN(A1)
    • A. 5
    • B. 8
    • C. 9
    • D. 4
    Show the answerC — 9. LEN counts every character: 5 letters and 4 digits.
  5. A1 has ravi@gmail.com. What will this formula return?
    =FIND("@",A1)
    • A. 6
    • B. 4
    • C. 5
    • D. 1
    Show the answerC — 5. FIND gives the position of @. It is the 5th character.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories