Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Exam ACE ID: CPRT-0076 Organization: Certiport, a Business of NCS Pearson, Inc. Dates Offered: 8/1/2017 - 7/31/2020 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 1 Computer Applications or Information Technology The minimum passing score for the exam is 700 out of 1000. Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. Skills Measured: Create and manage worksheets and workbooks:Create worksheets and workbooks; navigate in worksheets and workbooks; format worksheets and workbooks; customize options and views for worksheets and workbooks; and configure worksheets and workbooks for distribution. Manage data cells and ranges:Insert data in cells and ranges; format cells and ranges; and summarize and organize data.Create tables:Create and manage tables; manage table styles and options; and filter and sort a table.Perform operations with formulas and functions:Summarize data by using functions; perform conditional operations by using functions; and format and modify text by using functions.Create charts and objects:Create charts; format charts; and insert and format objects. Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Other offerings from Certiport, a Business of NCS Pearson, Inc. Autodesk Certified User: AutoCAD (CPRT-0086) Autodesk Certified User: Revit for Architecture (CPRT-0087) Communication Skills for Business: Professional Communication (CPRT-0091) ESB: Entrepreneurship and Small Business v.2 (CPRT-0093) Exam AI-900: Microsoft Azure AI Fundamentals (MLS-0063) Exam AZ-900: Microsoft Azure Fundamentals (MLS-0054) Exam DP-900: Microsoft Azure Data Fundamentals (MLS-0064) Exam MB-901: Microsoft Dynamics 365 Fundamentals (MLS-0055) Exam MS-900: Microsoft 365 Fundamentals (MLS-0057) Exam PL-900: Microsoft Power Platform Fundamentals (MLS-0056) View All Courses Page Content