From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
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 2019
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Solution: Full-length MOS Expert sample exam for Excel 2019
(upbeat music) - [Instructor] Welcome to the solution video for the final challenge. For this challenge we'll be using the 06_01 challenge Exercise File and the 06_01 Consolidate file. I challenge you to complete all the tasks in 40 minutes or less. Let's jump right in. First, we'll save the file as My Final Challenge. File, Save As, My Final Challenge. And move onto number two. Configure Excel to disable all macros except macros that are digitally signed. We'll go to File, Options, Trust Center, Trust Center Settings, Macro Settings, Disable all macros except digitally signed macros. Click OK and OK again. And go to number three. Configure Excel to not check for errors in cells where numbers are formatted as text or preceded by an apostrophe. Let's go back to Options, Formulas, down to Error checking rules, and we will remove the check mark next to Numbers formatted as text or preceded by an apostrophe.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.