Google Sheets Concatenate Function Quiz
Interactive Video
•
Computers
•
6th - 7th Grade
•
Practice Problem
•
Hard
Jennifer Brown
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of the concatenate function in Google Sheets?
To create charts and graphs
To sort data in ascending order
To combine multiple strings into one
To perform mathematical calculations
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the first example, what is the reason for adding a space between the first name and surname?
To separate the names visually
To make the formula more complex
To ensure the names are in alphabetical order
To add a special character between names
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a step in the first example of using the concatenate function?
Adding a space using speech marks
Inserting a mathematical formula
Selecting the first name cell
Selecting the surname cell
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the second example, what is the first string added to the name using the concatenate function?
Hi
Welcome
Goodbye
Hello
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the final step after writing the concatenate formula in both examples?
Printing the sheet
Saving the document
Closing the spreadsheet
Pressing the 'Enter' key
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
