


Objective 4.2: Calculate and transform data by using functions.Objective 4.1: Insert references in formulas.4 Perform operations by using formulas and functions.

Objective 3.3: Filter and sort table data.Objective 3.1: Create and format tables.Objective 2.3: Define and reference named ranges.Objective 2.1: Manipulate data in worksheets.Objective 1.5: Configure content for collaboration.Objective 1.4: Customize options and views.Objective 1.3: Format worksheets and workbooks.Objective 1.2: Navigate within workbooks.Objective 1.1: Import data into workbooks.Manage data cells and rangesĭownload the sample pages (includes Chapter 2) Table of Contents Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. Perform Operations by Using Formulas and FunctionsĪ Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards.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!ĭemonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers:
