Scroll to top button

Microsoft Office 2016

ISBN : 9781616917074

Gain hands-on expertise to pass the Microsoft Office 2016 certification exams with the Microsoft Office 2016 course and lab. The lab simulates real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. Microsoft Office 2016 course and lab cover all the objectives of MOS 2016 exams and teach how to create and manage documents; format text, paragraphs, and sections; create tables and lists; create and manage references; insert and format graphic elements; create and manage worksheets and workbooks; manage data cells and ranges; create tables; perform operations with formulas and functions; create charts and objects; create and manage presentations; and more.

The Microsoft Office Specialist (MOS) 2016 certification exam has been designed to test a candidate's ability to use an Office application more realistically. The MOS 2016 exam task instructions do not include the command name, as in previous versions. For instance, function names are avoided and are replaced with descriptors. Candidates of this exam must understand the purpose and common usage of the program functionality to complete the tasks in each project.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
Performance lab
Video tutorials

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
Where do I take the exam? Certiport
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the passing score? The passing score varies from exam to exam and is provided on the score report.

(on a scale of 0-1000)

Where can I find more information about this exam? To know more about the MOS-2016, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Data Analyst
  • Project Manager
  • Product Developer
  • Office Professional
  • Welcome to a New Word
  • The Office Look
  • Using the Word Start Screen
  • Touring the Word Screen
  • Exploring the File Tab
  • Undoing and Redoing Actions
  • Setting Word Options
  • Getting Help
  • Exiting Word
  • Summary
  • Creating a Blank File
  • Creating a File from a Template
  • Opening an Existing File
  • Saving and File Formats
  • Compatibility with Previous Versions of Word
  • Choosing the Right Word View for the Task at Hand
  • Printing a Document
  • Achieving Attractive Documents with Styles
  • Constructing Documents Faster with Outlining
  • Cleaning Up Content with AutoCorrect
  • Summary
  • Reviewing the Ways You Can Format Text in Word
  • Applying Character Formatting
  • Structuring Text with Paragraph Formatting
  • Setting Off Text with Paragraph Decoration
  • Using the Styles Group to Apply Styles
  • Checking Spelling and Grammar
  • Summary
  • Adding and Moving Document Content with Cut, Copy, and Paste
  • Managing Pasting Options
  • Searching with the Navigation Pane
  • Starting an Advanced Find from the Ribbon
  • Replacing Text via the Ribbon
  • Summary
  • Revisiting AutoCorrect
  • Using Quick Parts and Building Blocks
  • Inserting a Cover Page
  • Printing Envelopes and Labels Automatically
  • Printing an Envelope
  • Creating Labels
  • Creating PDF or XPS Output
  • Emailing a Document
  • Blogging
  • Summary
  • Getting a Quick Start with Quick Tables
  • Table Basics
  • Working with Table Layout and Design
  • Inserting SmartArt
  • Summary
  • Inserting Pictures from a File
  • Adding an Online Picture
  • Pasting or Snapping a Picture
  • Manipulating Inserted Pictures (and Other Graphics)
  • Creating WordArt
  • Arranging Pictures and Other Objects
  • Summary
  • Adding a Drop Cap for Drama
  • Why Use Text Boxes?
  • Inserting a Text Box
  • Inserting a Shape
  • Adding a Basic Symbol
  • Inserting a Symbol from the Symbol Dialog Box
  • Summary
  • Changing Basic Page Setup
  • Section Formatting
  • Headers and Footers Overview
  • Header and Footer Navigation and Design
  • Adding Header and Footer Material
  • Considering the Need for Columns
  • Changing the Number of Columns
  • Special Column Formatting
  • Summary
  • Adding and Removing Page Borders
  • Formatting the Page Background
  • Applying Page Background Colors, Patterns, Textures, or Pictures
  • Adding a Watermark
  • Removing Watermarks and Page Backgrounds
  • Working More Effectively with Themes
  • Working with Bookmarks
  • Hyperlinks
  • Summary
  • Automating Table of Contents Creation
  • Working with TOC Styles
  • Manually Creating a Table of Contents
  • Updating or Deleting a Table of Contents
  • Captions and Tables of Captioned Items
  • Indexing a Document
  • Footnotes and Endnotes Basics
  • Working with Footnote and Endnote Styling
  • Separators and Continuation
  • Making a Bibliography
  • Identifying the Sources for Your Bibliography
  • Editing Citations
  • Compiling the Citations into a Bibliography
  • Summary
  • Previewing the Mail Merge Process
  • Data Considerations
  • Reviewing Data File Formats
  • Choosing the Data Document Type
  • Attaching a Data Source
  • Assembling a Merge Document
  • Mail Merge Pane/Wizard
  • Summary
  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary
  • The QAT?
  • Changing the Buttons on the Quick Access Toolbar
  • The Customize Quick Access Toolbar Dialog Box
  • Making Changes to the Ribbon
  • Importing and Exporting Ribbon Customizations
  • Summary
  • Opening Word Options
  • General
  • Display (and Printing)
  • Proofing
  • Save
  • Language
  • Advanced
  • Summary
  • Displaying Macro Tools and Creating a Macro
  • Managing Macros
  • Understanding More about Macro Security
  • Macro Storage
  • Automatic Macros
  • Visual Basic for Applications: Quick and Dirty Answers
  • Summary
  • Certification Objectives Map
  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary
  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary
  • Creating New Slides
  • Inserting Content from External Sources
  • Managing Slides
  • Using Content Placeholders
  • Creating Text Boxes Manually
  • Working with Text Boxes
  • Understanding Layouts and Themes
  • Changing a Slide's Layout
  • Applying a Theme
  • Managing Themes
  • Changing Colors, Fonts, and Effects
  • Changing the Background
  • Managing Slide Masters
  • Summary
  • Changing the Font
  • Changing the Font Size
  • Changing Font Color/Text Fill
  • Applying Text Attributes
  • Applying WordArt Styles
  • Applying Text Effects
  • Finding and Replacing Text
  • Correcting Your Spelling and Grammar
  • Using AutoCorrect to Fix Common Problems
  • Using the Research Tools
  • Summary
  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary
  • Creating a New Table
  • Moving around in a Table
  • Selecting Rows, Columns, and Cells
  • Editing a Table's Structure
  • Applying Table Styles
  • Formatting Table Cells
  • Summary
  • Working with the Drawing Tools
  • Understanding Object Formatting
  • Resizing Objects
  • Arranging Objects
  • Merging Shapes
  • Applying Shape or Picture Styles
  • Understanding Color Selection
  • Applying an Object Border
  • Applying an Object Fill
  • Applying Object Effects
  • Using Action Buttons
  • Summary
  • Understanding SmartArt Types and Their Uses
  • Inserting a SmartArt Graphic
  • Formatting a SmartArt Graphic
  • Inserting Clip Art
  • Inserting Photos
  • Sizing and Cropping Photos
  • Adjusting and Correcting Photos
  • Compressing Images
  • Creating a Photo Album Layout
  • Summary
  • Understanding the Parts of a Chart
  • Starting a New Chart
  • Working with Chart Data
  • Chart Types and Chart Layout Presets
  • Working with Chart Elements
  • Formatting a Chart
  • Summary
  • How PowerPoint Uses Audio
  • When to Use Sounds - and When Not To
  • Inserting an Audio Clip as an Icon on a Slide
  • Assigning a Sound to an Object
  • Configuring Sound Playback
  • Understanding Video Types
  • Placing a Video on a Slide
  • Changing the Video's Formatting
  • Specifying Playback Options
  • Summary
  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary
  • The When and How of Handouts
  • Creating Handouts
  • Summary
  • Starting and Ending a Show
  • Using the On-Screen Show Controls
  • Using the On-Screen Pen
  • Using Custom Shows
  • Creating and Using Sections
  • Recording Narration and Timings
  • Summary
  • Working with Comments
  • Comparing and Merging Presentations
  • Summary
  • Navigate the Outlook Interface
  • Perform Basic Email Functions
  • Use Outlook Help
  • Summary
  • Create an Email Message
  • Check Spelling and Grammar
  • Format Message Content
  • Attach Files and Items
  • Enhance an Email Message
  • Manage Automatic Message Content
  • Summary
  • Customize Reading Options
  • Work with Attachments
  • Manage Your Message Responses
  • Summary
  • Manage Messages Using Tags, Flags, and Commands
  • Organize Messages Using Folders
  • Summary
  • View the Calendar
  • Manage Appointments
  • Manage Meetings
  • Print Your Calendar
  • Summary
  • Create and Update Contacts
  • View and Organize Contacts
  • Summary
  • Manage Tasks
  • Manage Notes
  • Summary
  • Customize the Outlook Interface
  • Create and Manage Quick Steps
  • Summary
  • Insert Advanced Characters and Objects
  • Modify Message Settings, Properties, and Options
  • Use Automatic Replies
  • Summary
  • Sort Messages
  • Filter Messages
  • Organize Messages
  • Search Messages
  • Manage Junk Mail
  • Manage Your Mailbox
  • Summary
  • Manage Advanced Calendar Options
  • Manage Additional Calendars
  • Manage Meeting Responses
  • Summary
  • Edit an Electronic Business Card
  • Manage Advanced Contacts Options
  • Forward Contacts
  • Export Contacts
  • Summary
  • Assign and Manage Tasks
  • Record and Modify Journal Entries
  • Summary
  • Delegate Access to Mail Folders
  • Share Your Calendar
  • Share Your Contacts
  • Summary
  • Back Up Outlook Items
  • Change Data File Settings
  • Summary

Hands on Activities (Labs)

  • Using the Word Count Option
  • Exploring the File tab
  • Understanding undoing and redoing actions
  • Understanding Inserting versus Overtyping
  • Creating a file from a template
  • Saving a Document
  • Identifying file formats
  • Zooming in the Document
  • Changing the Text to Bold
  • Modifying the Font
  • Changing the Text Color
  • Showing Paragraph Marks and Zooming in the Document 
  • Increasing the Line Spacing
  • Creating a Signature Line
  • Inserting Page Breaks
  • Inserting Bullets
  • Changing the Heading Style
  • Using the Cut and Paste Functions
  • Understanding the Navigation pane
  • Finding and Replacing the Text
  • Revisiting AutoCorrect
  • Inserting a Cover Page
  • Printing an envelope
  • Inserting a Table
  • Formatting the Table Border
  • Inserting Rows and Columns
  • Drag the table style option to its description.
  • Modifying the Table Design and Border
  • Inserting SmartArt
  • Inserting and Modifying the Picture
  • Inserting an Online Picture
  • Understanding resizing, rotating, and cropping
  • Inserting a WordArt
  • Applying a Drop Cap
  • Inserting Symbols
  • Inserting a shape
  • Drag the features of the Symbol dialog box to match them with their descriptions.
  • Changing the Basic Page Setup
  • Adding a Header
  • Inserting Page Numbers
  • Changing the Number of Columns and the Basic Page Setup
  • Breaking Content into Columns
  • Adding and Removing Page Borders
  • Adding the Page Color
  • Adding a Custom Text Watermark
  • Identifying shortcut for inserting bookmark
  • Identifying Mail merge options
  • Identifying fields of the Rules feature
  • Understanding Track Changes
  • Understanding Accept and Reject Changes
  • Understanding the Quick Access Toolbar
  • Identifying formatting marks
  • Identifying Macro file formats
  • Identifying font dialog controls
  • Adding notes in MS PowerPoint 2016
  • Changing document view in MS PowerPoint 2016
  • Showing gridlines in MS PowerPoint 2016
  • Duplicating slide in MS PowerPoint 2016
  • Understanding Outline view
  • Understanding themes and template
  • Adding a layout in MS PowerPoint 2016
  • Applying themes in MS PowerPoint 2016
  • Identifying text effects
  • Customizing AutoCorrect Options in MS PowerPoint 2016
  • Marking a document as final in MS PowerPoint 2016
  • Formatting bulleted lists
  • Setting fill transparency
  • Aligning objects in MS PowerPoint 2016
  • Identifying merge operations
  • Inserting and formatting shapes in MS PowerPoint 2016
  • Understanding border attributes
  • Inserting SmartArt and arranging picture position in MS PowerPoint 2016
  • Adding multiple screenshots in MS PowerPoint 2016
  • Applying artistic effects in MS PowerPoint 2016
  • Creating an album in MS PowerPoint 2016
  • Understanding the parts of a chart
  • Identifying chart elements
  • Inserting audio in MS PowerPoint 2016
  • Inserting a video in MS PowerPoint 2016
  • Applying transition on the slide in MS PowerPoint 2016
  • Applying animation on images in MS PowerPoint 2016
  • Adding a motion path to an object
  • Applying animation on an online picture
  • Customizing the handout master in MS PowerPoint 2016
  • Previewing the handout master in MS PowerPoint 2016
  • Identifying Message Form tabs
  • Creating and sending an email
  • Deleting email messages
  • Understanding AutoCorrect feature
  • Checking spelling and grammar in a message
  • Identifying paste options
  • Attaching a file to a message
  • Understanding SmartArt
  • Understanding reading options
  • Working with attachments
  • Using flags to manage messages
  • Identifying the Calendar Grid Arrangement options
  • Responding to a meeting request
  • Printing calendar
  • Creating contacts
  • Understanding Quick Steps
  • Understanding chart type
  • Modifying message settings
  • Sorting messages
  • Filtering messages
  • Managing junk mail
  • Managing advanced calendar display options
  • Editing an electronic business card
  • Forwarding contacts
  • Exporting contacts
  • Identifying share calendar options
  • Sharing contacts
  • Changing data file settings