From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

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 Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Solution: Manage data, cells, and ranges

“

(upbeat music) - [Instructor] Welcome to the solution video for the Chapter Three challenge. For this challenge, we used the 03_09 challenge exercise file and I challenged you to complete all the task in 10 minutes or less. Let's jump right in. First, we'll save the file as My Challenge in the Chapter Three folder, File, Save As, Chapter Three, My Challenge, and Save. Next, we'll complete the task on the Project One worksheet. Our first task is to split A13 into multiple cells. So, A13 contains merged cells, we'll go to Merge and Center, and Merge Cells. Next, format the cells data for January through June as currency and negative numbers in parentheses in red. Let's select all of the sales data. Go into our Number, Formatting window, Currency, negative numbers in red and parentheses, and click OK. Number three, create a named range January Sales to include all sales for January. Let's select all of the data for January. With it highlighted, we can now click in our name box and type…

Contents