To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including: Questions and Inquiriesįor inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. Please note that other Pearson websites and online products and services have their own separate privacy policies. This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about Pearson IT Certification products and services that can be purchased through this site. Objective 5.3: Insert and format objects Objective group 5: Create charts and objects Objective 4.3: Format and modify text by using functions Objective 4.2: Perform conditional operations by using functions Objective 4.1: Summarize data by using functions Objective group 4: Perform operations by using formulas and functions Objective 3.2: Manage table styles and options Objective 2.3: Summarize and organize data Objective 2.1: Insert data in cells and ranges Objective group 2: Manage data cells and ranges Objective 1.5: Configure worksheets and workbooks for distribution Objective 1.4: Customize options and views for worksheets and workbooks Objective 1.3: Format worksheets and workbooks Objective 1.2: Navigate in worksheets and workbooks Objective 1.1: Create worksheets and workbooks Objective group 1: Create and manage worksheets and workbooks Taking a Microsoft Office Specialist exam Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.ĭownload the sample pages (includes Chapter 5 and the Index.) Table of Contents Perform operations with formulas and functionsĪ Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards.Create and manage worksheets and workbooks.Sharpen the skills measured by these objectives: Hands-on tasks to practice what you’ve learned.Detailed procedures to help build the skills measured by the exam.In-depth preparation for each MOS objective.Advance your everyday proficiency with Excel 2016.ĭemonstrate 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: