Google Sheets Concatenate Function Quiz

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

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

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

In the second example, what is the first string added to the name using the concatenate function?

• Hi

• Welcome

• Goodbye

• Hello

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