Contents
Taking a Microsoft Office Specialist exam
Exam 77-727 Microsoft Excel 2016
1 Create and manage worksheets and workbooks
Objective 1.1: Create worksheets and workbooks
Create blank and prepopulated workbooks
Import data from delimited text files
Objective 1.2: Navigate in worksheets and workbooks
Search for data within a workbook
Navigate to a named cell, range, or workbook element
Link to internal and external locations and files
Objective 1.3: Format worksheets and workbooks
Get MOS 2016 Study Guide for Microsoft Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.