Excel TEXT Functions sample practice questions and online Exam

Last modified date

Below you can download & practice excel workbook with sample questions on TEXT functions as per your knowledge level(Like beginner, intermediate, advanced).

Beginner Task List

Task1: Click here to download the Text Functions practice workbook

Task1 Answers: Click here to get the answers workbook

Below Quick 5 minutes exam on Excel TEXT functions

1. Excel Function to convert text to Lower Case

 
 
 
 

2. Excel Function to convert text to Upper Case

 
 
 
 

3. Excel function which helps to remove Extra Spaces from Text.

 
 
 
 

4. Excel Function which is used to search position of text “Morning” in main text “Good Morning” it should match exactly (case-sensitive).

 
 
 
 

5. Excel Function which is used to extract text “day” from the text “Have a good day”.

 
 
 
 

6. Excel Function which is used to extract text “Good” from the text “Good day”.

 
 
 
 

7. Excel Function which is used to extract text “Microsoft” from the text “Excel is a Microsoft Product”.

 
 
 
 

8. Excel Function which is used to repeat the text.

 
 
 
 

9. Excel Function which is used to get the total number of character in the text “Excel is a Microsoft Product”.

 
 
 
 

10. Excel Function which is used to join 2 text strings.

 
 
 
 

Question 1 of 10

Intermediate Task List

Expert(Advanced Excel) Task List

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment