MO-201 Excel Expert Exam Review 1-2 Practice Tasks (1/2)

Pass the new 2019 Excel Expert Exam with this review of the practice tasks & Excel tips covering the Microsoft Exam # MO-201 Microsoft Excel Expert (v2019) Study Guide.

Objective 1-2 ‘Prepare Workbooks for Collaboration’.

This video walks through the following practice tasks:
- Unlock cells (@ 0:25);
- Shortcut to Format Cells Menu (@ 0:41);
- Protect Worksheet (@ 2:58);
- Allow an Edit Range (@ 5:45); and,
- Unlock an Edit Range (@ 7:54).

Order the textbook and/or download the practice files here:

MO-201 77-728 mos microsoft office excel 2016 2019 expert M0-201

[steventate]

awesome I did wonder why random letters were underlined. Thank you.

[steventate]

I just failed the Expert exam a couple of days ago. one of the tasks not on the practice test or study guide was expand chart by months and increment or step up by 100 or some stupid stuff I never heard of. If they are averagving about 15 tasks not on the practice or study guide, then I guese I got to try to watch random videos to see who can help. You never know what they are ganna ask so these videos might just cover some random surprise stuff.

[nikoespino]

@7:20 When you protect the sheet, does this password you enter have to match the password assigned to the password-protected cell(s) B:7?