Concatenate Function Quiz
Seven medium-difficulty multiple-choice questions about using CONCATENATE and alternative methods from the video transcript.
Try this quiz
Play through the questions and see your score instantly
Ready to test your knowledge?
7 questions · Quick play · Instant results
Make your own quiz videos
Turn any topic into a polished video quiz — with AI-powered questions, voiceover, and animations. No video editing skills needed.
Unlimited quizzes, free to start
Create as many quizzes as you want. Describe your topic and AI builds the questions, answers, and explanations for you.
Customise everything
Pick from stunning templates, tweak colours and fonts, add your branding, and choose between vertical or landscape formats.
Export-ready videos
Download HD videos optimised for TikTok, YouTube Shorts, Instagram Reels, or full-length YouTube — one click, no editing.
No credit card required
Quiz Questions & Answers
Review every prompt, the correct responses, and helpful context to prep for your own run-through.
Question 1: According to the video, what is the first literal step to start combining text using the CONCATENATE function in Excel?
Press Ctrl+K to link cells
Type CONCATENATE and open a parenthesis
Enter an equals sign then the cell addresses
Select both cells before typing anything
Question 2: In the video, what does the presenter call the argument that specifies what appears between joined values?
Glue
Connector
Operator
Delimiter
Question 3: Which exact text notation does the video show for including a single space as the delimiter inside CONCATENATE?
" " (quotation mark, space, quotation mark)
spacebar without quotes
CHAR(32)
' ' (single quotes around a space)
Question 4: What is the main alternative method to CONCATENATE demonstrated in the video for joining cells?
Using CONCAT_WS function
Using TEXTJOIN with ignore-empty option
Using the ampersand operator (&) between items
Using VBA macro recorded on the sheet
Question 5: When replacing the delimiter with a dash, what observable change does the video say will occur in the combined result?
Excel automatically removes the dash
The formula breaks due to invalid character
The last name moves to a new cell
A dash appears between the first and last names
Question 6: Beyond joining names, what other related task does the video point viewers to as sometimes necessary?
Merging worksheets into one file
Splitting a full name into first and last names
Creating pivot tables from names
Converting text to uppercase
Question 7: Which mindset or practice does the presenter encourage regarding different concatenation methods?
Use macros for every text join task
Be aware there are multiple methods and some work better situationally
Always use CONCATENATE because it's the only proper way
Avoid delimiters to keep names compact