MOS 2013 Study Guide for Microsoft Excel

Description

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Microsoft Office Specialist (MOS) exam, this all-in-one study guide features: Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skills Hands-on practice tasks to apply what you’ve learned Includes downloadable practice files Cover Copyright page Contents Introduction Who this book is for How this book is organized Download the practice files Sidebar: Adapting exercise steps Ebook edition Get support and give feedback Errata We want to hear from you Stay in touch Taking a Microsoft Office Specialist exam Microsoft Office Specialist certification Selecting a certification path Test-taking tips Certification benefits For more information Exam 77-420: Microsoft Excel 2013 Prerequisites Managing worksheets Managing worksheet content Managing Excel tables Managing data entries Objective 1: Create and manage workbooks and worksheets 1.1 Create workbooks and worksheets Creating new workbooks and worksheets Reusing existing content Practice tasks 1.2 Navigate through worksheets and workbooks Locating data and worksheet elements Inserting hyperlinks Practice tasks 1.3 Format worksheets and workbooks Modifying page setup Inserting page elements Changing workbook themes and colors Modifying rows and columns Configuring data validation Practice tasks 1.4 Customize options and views for worksheets and workbooks Displaying different views of worksheets Displaying multiple parts of a workbook Hiding and displaying workbook content Customizing the Quick Access Toolbar Customizing the ribbon Working with macros Modifying workbook properties Practice tasks 1.5 Configure worksheets and workbooks to print or save Printing workbook content Saving workbooks Practice tasks Objective review Objective 2: Manage cells and ranges 2.1 Insert data in cells and ranges Creating data Reusing data Practice tasks 2.2 Format cells and ranges Formatting cell structure Formatting cell content Applying number formats Copying formatting Practice tasks 2.3 Order and group cells and ranges Modeling data Creating named ranges Working with data groups and summaries Practice tasks Objective review Objective 3: Manage tables 3.1 Create tables Practice tasks 3.2 Modify tables Practice tasks 3.3 Filter and sort tables Practice tasks Objective review Objective 4: Apply formulas and functions 4.1 Utilize cell ranges and references in formulas and functions Referencing cells and cell ranges in formulas Defining order of operations Practice tasks 4.2 Summarize data by using functions Practice tasks 4.3 Utilize conditional logic in functions Practice tasks 4.4 Format and modify text by using functions Practice tasks Objective review Objective 5: Create charts and objects 5.1 Create charts Practice tasks 5.2 Format charts Practice tasks 5.3 Insert and format objects Adding pictures to sheets Adding text boxes to sheets Adding SmartArt graphics to sheets Practice tasks Objective review Index About the author Survey page