MS Excel Quiz Questions 7

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 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?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

6. What does the CLEAN function do?

 
 
 
 

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 dataMS Excel quiz questions 4What is the result of the formula: =FIND(“university”, B2)

 
 
 
 

9. The worksheet contains the following data

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

 
 
 
 

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

 
 
 

11. The worksheet contains the following data

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

 
 
 
 

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

 
 
 
 

13. The worksheet contains the following data

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

Social Psychology MCQs with Answers 5

The post is about Social Psychology MCQs with Answers. There are 15 multiple-choice questions from Social Psychology. The subject of Social Psychology in Sociology is the scientific study of how others and their social environments influence people. Social Psychology examines how people think, feel, and behave in social settings. This quiz is one of a series of Quizzes on the Subject of Sociology. Let us start with the Quiz Social Psychology MCQs with Answers now.

Social Psychology MCQs With Answers
Please go to Social Psychology MCQs with Answers 5 to view the test

Social Psychology MCQs with Answers

  • Sara knows that she can help people simply by dialing 9-1-1 on her cell phone if an emergency arises. Which step in the decision process for helping would Sara be at?
  • Which of the following would the field of social neuroscience be most likely to study?
  • Your behavior is changed with the presence of others, which is called
  • Gordon Allport defines social psychology in
  • The tendency to judge the category of people based on how closely it resembles the typical or average member of that category
  • Our social judgment is also shaped by our ability to imagine, known as
  • A tendency to categorize people based on their common attributes, this is called
  • The most representative member of a category is called
  • Fixed way of thinking about others which don’t include individual variations, called
  • The three dimensions of attitude are
  • It reduces complex judgment into simple thumb rule
  • Reinforcement and punishment behaviour are part of
  • Mere exposure effect was proposed by
  • Feelings and actions toward people are sometimes negative and sometimes positive is
  • Observational and correlational studies are the primary research methods followed by experimentation in

Hypothesis Testing

Social Psychology Quiz Questions 4

The post is about Social Psychology Quiz Questions with Answers. There are 20 multiple-choice questions from Social Psychology. The subject of Social Psychology in Sociology is the scientific study of how others and their social environments influence people. Social Psychology examines how people think, feel, and behave in social settings. This quiz is one of a series of Quizzes on the Subject of Sociology. Let us start with the Social Psychology Quiz Questions now.

Online Social Psychology Quiz Questions with Answers gmstat.com
Please go to Social Psychology Quiz Questions 4 to view the test

Social Psychology Quiz Questions

  • Research on helping behaviour suggests that people tend to help people:
  • Social psychologists who focus on legal applications have witnessed that many eyewitnesses are:
  • Salman admits that he conforms to be liked by others. This is known as
  • According to the text, in which of the following has group-think been known to occur?
  • Many businesses now require their employees to work in teams, believing that a group of four to five employees will accomplish more than four to five individuals working alone. This is an example of what concept?
  • Maria was approached by her neighbor asking her to adopt two to three kittens that were abandoned by their mother. While Maria refused to take in three kittens, she did agree to adopt just one. What compliance technique did her neighbor use on Maria?
  • Which of the following people would probably not be a prime candidate for membership in a cult?
  • Follow-up studies to Stanley Milgram’s research have suggested that a teacher’s willingness to deliver potentially lethal shocks may be more a product of ———— than of obedience.
  • The public service messages that encourage parents to sit down with their children and talk frankly about drugs are promoting which method of attitude formation?
  • Researchers have found that a ———— degree of fear in a message makes it more effective, particularly when it is combined with —————.
  • Sandy was a juror in the trial of a man accused of stealing guns from a sporting goods store. The defendant was not very well-spoken and came from a very poor background, but Sandy listened carefully to the evidence presented and made her decision based on that. Sandy was using ————– processing.
  • Which of the following should Shaista avoid if she wants to reduce cognitive dissonance?
  • Arsalan goes to a job interview dressed in patched blue jeans, a torn T-shirt, and sandals. His hair is uncombed and he hasn’t shaved in a few days. Arsalan knows nothing about
  • If Behaviour is assumed to be caused by external characteristics, this is known as:
  • Thomas likes to “hang with the guys” These people with whom Thomas identifies most strongly are called a(n)
  • The “Robber’s Cave” experiment showed the value of ————- in combating prejudice.
  • Shoaib and Tahir met at work. At first, they were just friends, but over time, they found themselves falling in love as Shoaib told her friends, “Tahir just grew on me!” According to research on interpersonal attraction, the most likely explanation for their attraction is
  • According to Sternberg, a couple whose love is based on intimacy and passion but who are not yet committed to a long-term relationship are in the form of love called ———— love.
  • The concept that aggression results from a social role is based on what psychological theory?
  • To which two processes do most social psychologists attribute the failure of those around Atif Ameen to help her?

Online Statistics MCQs