Course

Course Summary
Credit Type:
Exam
ACE ID:
CPRT-0076
Organization:
Certiport, a Business of NCS Pearson, Inc.
Dates Offered:
Credit Recommendation & Competencies
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

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
Supplemental Materials