MS Excel Quiz Questions 7

by

Are you ready to test your knowledge of MS Excel and master essential text functions? This post features 20 multiple-choice MS Excel quiz questions designed to help you sharpen your skills in handling text data in Excel. Whether you’re a beginner or looking to refresh your knowledge, this quiz covers the basics of MS Excel text functions like CONCATENATE(), LEFT(), RIGHT(), MID(), TEXTJOIN(), TRIM(), FIND(), and LEN().

Online MS Excel Quiz Questions with Answers

These MS Excel quiz questions are perfect for anyone looking to improve their proficiency in managing and manipulating text data efficiently. Dive into the quiz now and see how well you know these fundamental Excel functions!

Start the MS Excel Quiz Questions below and take your Excel expertise to the next level!

Online MS Excel Quiz Questions with Answers

1. The workbook contains the following data:MS Excel quiz questions 3What will the formula: =CONCATENATE(LEFT(B2,4), RIGHT(B3,4)) return?

 
 
 
 

2. The worksheet contains the following data: ms excel quiz questions 8What is the result of the formula: =CONCATENATE(LEFT(B2, 1), LEFT(B3, 1))

 
 
 
 

3. The worksheet contains the following data

MS Excel quiz questions 1Which of the following formulas will give the result: HSBC Shanghai China?

 
 
 
 

4. What does the CLEAN function do?

 
 
 
 

5. The worksheet contains the following data:MS Excel quiz questions 4Which of the following formulas will return QUA?

 
 
 
 

6. The worksheet contains the following datams excel quiz questions 8What will the formula: =CONCATENATE(PROPER(B2),” “, B3) return?

 
 
 
 

7. The worksheet contains the following data:MS Excel quiz questions 2What will the formula =LEFT(B2,4) return?

 
 
 

8. The worksheet contains the following data:MS Excel quiz questions 2What will the formula =RIGHT(B2,3) return?

 
 
 

9. The worksheet contains the following datams excel quiz questions 5What is the result of the formula: =LEN(B2)+LEN(B3)

 
 
 
 

10. The worksheet contains the following data:MS Excel quiz questions 4What will the formula: =LEN(TRIM(RIGHT(B2,11))) return?

 
 
 
 

11. The worksheet contains the following dataMS Excel quiz questions 4What is the result of the formula: =FIND(“university”, B2)

 
 
 
 

12. The worksheet contains the following dataMS Excel quiz questions 1Sara wants to join the value in B2 and the value in C2 separated by a space to get HSBC Shanghai. She enters the following formula:
=CONCATENATE(B2, ,C2)
She gets an error. Which of the following will correct the error and return the desired result?

 
 
 
 

13. The worksheet contains the following datams excel quiz questions 7What is the result of the formula: =MID(B2, 6, FIND(“-“, B2))

 
 
 
 

14. The worksheet contains the following data

MS Excel quiz questions 1What will be the result of the formula =TEXTJOIN(“,”, TRUE, B2:D2)?

 
 
 
 

15. The workbook contains the following dataMS Excel quiz questions 3What will the formula: =LEFT(TEXTJOIN(“,”, TRUE, B2, B3),4) return?

 
 
 
 

16. The worksheet contains the following datams excel quiz questions 9What will the formula: =TRIM(B2) return?

 
 
 
 

17. Which Excel function would be most suitable for converting “100 kilos” to display as “100 kg”?

 
 
 
 

18. The worksheet contains the following datams excel quiz questions 6What is the result of the formula: =FIND(“Australia”, B2,12)

 
 
 
 

19. The worksheet contains the following data

MS Excel quiz questions 1What will be the result of the formula =concat(B2:D2)?

 
 
 
 

20. Cell B2 holds the data: BUSA3015MS Excel quiz questions 2What will the formula =MID(B2,4,2)

 
 
 

Online MS Excel Quiz Questions with Answers

  • The worksheet contains the following data: What will be the result of the formula =concat(B2:D2)?
  • The worksheet contains the following data: What will be the result of the formula =TEXTJOIN(“,”, TRUE, B2:D2)?
  • The worksheet contains the following data: Which of the following formulas will give the result: HSBC Shanghai China?
  • The worksheet contains the following data: Sara wants to join the value in B2 and the value in C2 separated by a space to get HSBC Shanghai. She enters the following formula: =CONCATENATE(B2, ,C2) She gets an error. Which of the following will correct the error and return the desired result?
  • The worksheet contains the following data: What will the formula =LEFT(B2,4) return?
  • The worksheet contains the following data: What will the formula =RIGHT(B2,3) return?
  • Cell B2 holds the data: BUSA3015What will the formula =MID(B2,4,2)
  • The workbook contains the following data: What will the formula: =CONCATENATE(LEFT(B2,4), RIGHT(B3,4)) return?
  • The workbook contains the following data: What will the formula: =LEFT(TEXTJOIN(“,”, TRUE, B2, B3),4) return?
  • The worksheet contains the following data: What is the result of the formula: =FIND(“university”, B2)
  • The worksheet contains the following data: What is the result of the formula: =LEN(B2)+LEN(B3)
  • The worksheet contains the following data: What is the result of the formula: =FIND(“Australia”, B2,12)
  • The worksheet contains the following data: What is the result of the formula: =MID(B2, 6, FIND(“-“, B2))
  • The worksheet contains the following data: What is the result of the formula: =CONCATENATE(LEFT(B2, 1), LEFT(B3, 1))
  • The worksheet contains the following data: What will the formula: =CONCATENATE(PROPER(B2),” “, B3) return?
  • The worksheet contains the following data: What will the formula: =TRIM(B2) return?
  • The worksheet contains the following data: What will the formula: =LEN(TRIM(RIGHT(B2,11))) return?
  • The worksheet contains the following data: Which of the following formulas will return QUA?
  • What does the CLEAN function do?
  • Which Excel function would be most suitable for converting “100 kilos” to display as “100 kg”?

https://itfeature.com

MS Excel Pivot Table Quiz

Leave a Reply

Discover more from GM Statistics

Subscribe now to keep reading and get access to the full archive.

Continue reading