20 questions · 30 minutes · Excel
Advance Excel Practice 2 practice quiz
20 MCQs on Excel Text Functions – LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN.
Before you start
Answer all 20 questions. 1 mark each. No negative marking.
You can take this without an account and you will still get the full marked review. Only signed-in attempts are saved — sign in first if you want this one kept in your history.
- Questions
- 20
- Time
- 30 minutes
- Marks
- 20
- Subject
- Excel
- Marking
- Server-side
What it asks
The first few questions
- Which function extracts a specified number of characters from the start of a text string?
- The RIGHT function requires which two arguments?
- Which function returns the number of characters in a string, including spaces?
- Which function extracts characters from the middle of a string?
16 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.