From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Manage data, cells, and ranges

Solution: Manage data, cells, and ranges

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Solution: Manage data, cells, and ranges

“

- [Instructor] Welcome to the solution video for the Chapter 3 Challenge. For this challenge, we use the 03_05 challenge file, and I challenged you to complete all the tasks in five minutes or less. Let's go ahead and get started. Okay, our first task is to save the file as my 03_05 Challenge. Let's go to File, and Save As. Navigate to our Chapter 3 folder on the desktop, click in front of the title, type My and a space, and save. Next, it says complete the tasks on the Project 1 and Project 2 - Q1 Commission Worksheets, and when we're done, we're going to save and close the workbook. Let's go to the Project 1 Worksheet. Merge the text in row seven so the text spans A6 through F6, but do not change the layout. Go ahead and select A6 to F6. On our Home tab, we'll go to Merge and Center. We'll use the Merge Cells. It did change the layout. If that happens to you during the exam, use your Align Left command button to move everything back over to the margin. That Merge Cells should not…

Contents