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 worksheets and workbooks

Solution: Manage worksheets and workbooks

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

Start my 1-month free trial

Solution: Manage worksheets and workbooks

“

(upbeat music) - [Instructor] Welcome to the solution video for the Chapter 2 Challenge. For this challenge, we use the 02_12 challenge exercise file and I challenged you to complete all the tasks in 10 minutes or less. Let's jump right in. First, we'll save the file in the Chapter 2 folder as My Challenge. File, Save As, we'll go to the Desktop where my files are saved and rename it My Challenge. Number two, insert a new worksheet named 2019 Customers and move it after the Project 2 worksheet. We'll click here to insert a new sheet, double click, type 2019 Customers and we are going to move it after the Project 2 worksheet. I'll click on the tab, hold my mouse down, and drag and drop it after Project 2. Next, we'll unhide the New Customers worksheet and move it before the Disclaimer worksheet. Right click on any of the tabs and go to Unhide, New Customers, and then OK. And let's hop it right over Disclaimer, let's go back to instructions. Add the following information to the Document…

Contents