From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

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

Solution: Full-length MOS Expert sample exam for Excel 2016

Solution: Full-length MOS Expert sample exam for Excel 2016

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Solution: Full-length MOS Expert sample exam for Excel 2016

“

- [Instructor] Welcome to the Final Challenge Solution video. For this challenge we were using the 06_01 challenge exercise file, and I challenged you to complete all the tasks for all the projects in 40 minutes or less. Remember when you sit for the live exam, time is of the essence. The quicker you can complete all the tasks, the sooner you'll be able to move on to the other tasks in the exam. Let's go ahead and get started. Task number one is to save the file as My 06_01 Challenge. File, Save As, browse back to the desktop, save it as My 06_01 Challenge and save. Number two, configure Excel to disable all macros, except macros that are digitally signed. We're going to go into File and Options. Into our Trust Center. Trust Center. And into our Macro Settings. Now, keep in mind, that your macro settings are global. So if you've already come in and set this to Disable all macros except digitally signed ones, it's already going to be excepted. Don't be surprised if you go into your own…

Contents