Microsoft Excel 2021365 - Beginner to Advanced - Joining Data Using CONCAT

The video tutorial explains how to join text strings in Excel using different methods. It covers the use of the ampersand symbol and the Concat function, highlighting their differences and applications. The tutorial also demonstrates more complex concatenation tasks, such as combining names and job titles with specific formatting. Finally, it provides a practical example of concatenating country and product names in a sales worksheet.

What symbol can be used to join text strings in Excel?

• #

• !

• %

• &

Which function is the updated version of CONCATENATE in Excel?

• COMBINE

• JOIN

• MERGE

• CONCAT

When using the CONCAT function, how do you add a space between text strings?

• Use a comma

• Use a semicolon

• Use a space enclosed in quotes

• Use a dash

What is the purpose of using quote marks in text concatenation?

• To highlight text

• To indicate a formula

• To treat spaces and special characters as text

• To separate numbers

How can you format a concatenated string to include a dash between names and job titles?

• Use a period

• Use a comma

• Use a semicolon

• Use a space-dash-space enclosed in quotes

In the sales worksheet example, how is the product name formatted?

• In bold

• Underlined

• In italics

• In brackets

What is the first step in using CONCAT to combine country and product names?

• Add a dash

• Select the country name

• Add a comma

• Select the product name