You are previewing MOS 2016 Study Guide for Microsoft Excel.
O'Reilly logo
MOS 2016 Study Guide for Microsoft Excel

Book Description

Advance your everyday proficiency with Excel 2016.

And earn the credential that proves it!

Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2016 Core certification, this official Study Guide delivers:

  • In-depth preparation for each MOS objective

  • Detailed procedures to help build the skills measured by the exam

  • Hands-on tasks to practice what you’ve learned

  • Practice files and sample solutions

  •  Sharpen the skills measured by these objectives:

  • Create and manage worksheets and workbooks

  • Manage data cells and ranges

  • Create tables

  • Perform operations with formulas and functions

  • Create charts and objects

  • About MOS

    A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

    Table of Contents

    1. Cover
    2. Title Page
    3. Copyright Page
    4. Contents
    5. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Download the practice files
      4. Ebook edition
      5. Errata, updates, & book support
      6. We want to hear from you
      7. Stay in touch
    6. Taking a Microsoft Office Specialist exam
      1. Microsoft Office Specialist certification
      2. Selecting a certification path
      3. Test-taking tips
      4. Certification benefits
      5. For more information
    7. Exam 77-727. Microsoft Excel 2016
      1. Prerequisites
        1. Select content
        2. Manage data entry
        3. Manage worksheets
        4. Reuse content
        5. Access program commands and options
    8. Objective group 1. Create and manage worksheets and workbooks
      1. Objective 1.1: Create worksheets and workbooks
        1. Create blank and prepopulated workbooks
        2. Add worksheets to workbooks
        3. Move or copy worksheets
        4. Import data from delimited text files
      2. Objective 1.1 practice tasks
      3. Objective 1.2: Navigate in worksheets and workbooks
        1. Search for data within a workbook
        2. Navigate to a named cell, range, or workbook element
        3. Link to internal and external locations and files
      4. Objective 1.2 practice tasks
      5. Objective 1.3: Format worksheets and workbooks
        1. Manage worksheet attributes
        2. Manage rows and columns
        3. Change the appearance of workbook content
        4. Modify page setup
        5. Insert headers and footers
      6. Objective 1.3 practice tasks
      7. Objective 1.4: Customize options and views for worksheets and workbooks
        1. Hide or unhide content
        2. Customize the Quick Access Toolbar
        3. Modify the display of worksheets
        4. Modify document properties
      8. Objective 1.4 practice tasks
      9. Objective 1.5: Configure worksheets and workbooks for distribution
        1. Print all or part of a workbook
        2. Save workbooks in alternative file formats
        3. Set print scaling
        4. Print sheet elements
        5. Inspect a workbook for hidden properties or personal information
        6. Inspect a workbook for accessibility issues
        7. Inspect a workbook for compatibility issues
      10. Objective 1.5 practice tasks
    9. Objective group 2. Manage data cells and ranges
      1. Objective 2.1: Insert data in cells and ranges
        1. Create data
        2. Reuse data
        3. Replace data
      2. Objective 2.1 practice tasks
      3. Objective 2.2: Format cells and ranges
        1. Merge cells
        2. Modify cell alignment, text wrapping, and indentation
        3. Apply cell formats and styles
        4. Apply number formats
        5. Reapply existing formatting
      4. Objective 2.2 practice tasks
      5. Objective 2.3: Summarize and organize data
        1. Format cells based on their content
        2. Insert sparklines
        3. Outline data and insert subtotals
      6. Objective 2.3 practice tasks
    10. Objective group 3. Create tables
      1. Objective 3.1: Create and manage tables
        1. Create an Excel table from a cell range
        2. Add or remove table rows and columns
        3. Convert a table to a cell range
      2. Objective 3.1 practice tasks
      3. Objective 3.2: Manage table styles and options
        1. Apply styles to tables
        2. Configure table style options
      4. Objective 3.2 practice tasks
      5. Objective 3.3: Filter and sort tables
        1. Sort tables
        2. Filter tables
        3. Remove duplicate table entries
      6. Objective 3.3 practice tasks
    11. Objective group 4. Perform operations with formulas and functions
      1. Objective 4.1: Summarize data by using functions
        1. Reference cells and cell ranges in formulas
        2. Define order of operations
        3. Perform calculations by using functions
      2. Objective 4.1 practice tasks
      3. Objective 4.2: Perform conditional operations by using functions
      4. Objective 4.2 practice tasks
      5. Objective 4.3: Format and modify text by using functions
      6. Objective 4.3 practice tasks
    12. Objective group 5. Create charts and objects
      1. Objective 5.1: Create charts
      2. Objective 5.1 practice tasks
      3. Objective 5.2: Format charts
      4. Objective 5.2 practice tasks
      5. Objective 5.3: Insert and format objects
        1. Insert text boxes and shapes
        2. Insert images
        3. Provide alternative text for accessibility
      6. Objective 5.3 practice tasks
    13. Index
    14. About the author
      1. Acknowledgments
    15. Survey