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) Cisco Certified Support Technician: Cybersecurity (CPRT-0114) Cisco Certified Support Technician: Networking (CPRT-0115) Communication Skills for Business: Professional Communication (CPRT-0091) Digital Video using Adobe Premiere Pro (CPRT-0116) English for IT (CPRT-0109) 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) View All Courses Page Content