How to Merge Cells in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Which command keeps the data in all cells joined together?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. What would be the formula in C1 to join the data in A1 with the data in B1, and display it in C1? You would also like a colon (:) between the data.

2. What would be the formula in D1 to join cells A1, B1 and C1? The information from each cell should be separated by a comma.

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

Be prepared to answer questions on the Merge command and example formulas in Microsoft Excel on this quiz/worksheet combo.

Quiz & Worksheet Goals

With this quiz and worksheet, you can review:

  • Excel command that keeps data in all cells together
  • Formulas to join data tables
  • How information is kept and displayed after merging cells in Excel
  • Where to find the Merge and Center icon

Skills Practiced

  • Information recall - access the knowledge you've gained regarding merging cells in Excel to identify formulas for joining and displaying data in cells
  • Interpreting information - verify you can read and interpret information about keeping data in all cells together
  • Knowledge application - use your knowledge to answer a question about where to find the Merge and Center icon

Additional Learning

The lesson titled How to Merge Cells in Excel can help you to learn more about combining and displaying cell data. It will focus on the following objectives:

  • Define how the Merge command functions in Excel
  • Understand what the Combine command involves and its differences from merging
  • Identify how to merge and center your data
  • Describe the method involved in combing data in the program
  • Appreciate the benefits of merging cells in Excel