Self-test your comprehension by completing a series of hands-on activities. Practice importing, navigating, changing tab colors, renaming and reordering worksheets, changing page orientation, adjusting row height and column width, and inserting headers an
- [Instructor] Hi, welcome to the first challenge…in the course.…This challenge will be for the videos that you watched…in Chapter 2, and we'll be using the 02_07 challenge…exercise file located in your Chapter 2 folder.…Now, for each of the challenges,…I'll give you a specific amount of time in which…you should be able to complete all of the tasks.…In this case, it's 10 minutes.…If you find that you're unable to complete…each of the tasks in 10 minutes or less,…go back and watch the videos again…and then come and try the challenge again.…
Remember, the more you can practice,…the quicker you'll be able to complete all of the tasks,…and since time is of the essence on the MOS exam,…you'll want to complete the tasks as quickly but accurately…as possible, so that you'll have more time to spend…on the more difficult tasks or, more importantly,…to be able to go back after you've completed…all the tasks to review any of the questions…that maybe you were a little bit unsure about.…Now, since this is our first challenge,…
Author
Jennifer McBee
Released
12/25/2016The course begins with an overview of the certification program and how to prepare for the exam. Next, Jennifer walks you through all the certification objectives. Throughout the course, she provides you with opportunities for hands-on practice with exercises and chapter challenges, and wraps up with a full-length practice test that emulates exam 77-727.
- Recall the steps taken to change the margins of a worksheet.
- Explain how to repeat row and column headings when printing a document.
- Recognize three available options when merging cells.
- Identify the most effective way to filter and sort data in a table.
- Recognize the order of operations used when calculating data.
- Explain why a user might want to switch the row and column data in a chart.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m
-
-
1. Microsoft Office Specialist Exam Overview
-
Prepare for the exam2m 33s
-
2. Create and Manage Workbooks and Worksheets
-
3. Manage Data Cells and Ranges
-
Format cells and ranges7m 51s
-
4. Create Tables
-
Create and manage tables4m 22s
-
Filter and sort a table6m 41s
-
-
5. Perform Operations with Formulas and Functions
-
6. Create Charts and Objects
-
Create charts4m 47s
-
Format charts5m 50s
-
Insert and format objects5m 22s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Challenge: Create and manage workbooks and worksheets