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

Unlock the full course today

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

Solution: Create and manage workbooks and worksheets

Solution: Create and manage workbooks and worksheets

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

Start my 1-month free trial

Solution: Create and manage workbooks and worksheets

(chime) - [Instructor] Welcome to the solution video for the Chapter Two Challenge. For this challenge we used the 02_07 challenge file that you can find in your Chapter Two folder, and I challenged you to complete all of the tasks in 10 minutes or less. Let's go ahead and get started. Our first task is to save the file as My 02_07 Challenge. I'll do File, Save As. Goes right back to that Chapter Two folder. Just click in front of the document title and type My and a space and click save. Great. Next, we're going to insert a new worksheet named 2017 Customers and move it after the Project 2 worksheet. I'll click my New Sheet icon, double click on the tab, title it 2017 Customers, and I am going to click and drag and drop it on the other side of Project 2. Let's go back to instructions. Unhide the Web Sales worksheet. I'm just going to right-click on any of the worksheet tabs, go to Unhide, here is Web Sales. I'll just make sure it's highlighted, click Okay. That's done. Next, add the…

Contents