Preparing for an Exam
This exam validates the skills needed to be proficient in Excel 2021.
Audience Profile
The Core-level Microsoft Office Excel 2021 User should be able to navigate Microsoft Office Excel 2021 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2021. The core-level user should be able to use Microsoft Office Excel 2021 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:
- Accountants
• Clerical, Office professionals
• Consultants
• Executives/Managers
• Help desk personnel
• Instructors/Trainers
• Program/Project Managers
• Sales
• Students
• Other members of the general population
Tasks that might be undertaken or work products created by members of the Microsoft Excel 2021 Core-level User Target Audience might include, but would not be limited to:
• Charting
• Create analytical, financial, etc. reports
• Data entry
• Family budget
• Format numerical (financial, statistical, etc.) reports
• Forms
• Graphing
• Process data
• Reporting
• Technical support
• Trending
Skills Measured
Skills Being Measured This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.
The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.
Excel 2021 Setup & Printing Issues
- Worksheet Margins
- Worksheet Orientation
- Worksheet Page Size
- Headers and Footers
- Header and Footer Fields
- Scaling Your Worksheet to Fit a Page(S)
- Visually Checking Your Calculations
- Displaying Gridlines When Printing
- Printing Titles on Every Page
- Printing Row and Column Headings
- Spell Checking
- Previewing a Worksheet
- Viewing Workbooks Side By Side
- Zooming the View
- Printing Options
- Setting the Number of Copies to Print
- Selecting a Printer
- Selecting Individual Worksheets or the Entire Workbook
- Selecting Which Pages to Print
- Single or Double Sided Printing
- Collation Options
- Page Orientation
- Paper Size
- Margins
- Scaling
- Printing
Excel 2021 Functions and Formulas
- Getting Help with Functions
- Nested Functions
- Consolidating Data Using a 3-D Reference Sum Function
- Mixed References within Formulas
Excel 2021 Time & Date Functions
- Inserting the Current Time and Date
- Today Function
- Now Function
- Day Function
- Month Function
- Year Function
Excel 2021 Mathematical Functions
- Round Function
- Rounddown Function
- Roundup Function
Excel 2021 Logical Functions
- If Function
- And Function
- Or Function
Excel 2021 Mathematical Functions
- Sumif Function
Excel 2021 Statistical Functions
- Count Function
- Counta Function
- Countif Function
- Countblank Function
- Rank Function
Excel 2021 Text Functions
- Left Function
- Right Function
- Mid Function
- Trim Function
- Concatenate Function
Excel 2021 Financial Functions
- Fv Function
- Pv Function
- Npv Function
- Rate Function
- Pmt Function
Excel 2021 Lookup Functions
- Vlookup Function
- Hlookup Function
Excel 2021 Database Functions
- Dsum Function
- Dmin Function
- Dmax Function
- Dcount Function
- Daverage Function
Excel 2021 Named Ranges
- Naming Cell Ranges
- Removing a Named Range
- Named Cell Ranges and Functions
Excel 2021 Cell Formatting
- Applying Styles to a Range
- Conditional Formatting
- Custom Number Formats
Manipulating Worksheets within Excel 2021
- Copying or Moving Worksheets between Workbooks
- Splitting a Window
- Hiding Rows
- Hiding Columns
- Hiding Worksheets
- Un-Hiding Rows
- Un-Hiding Columns
- Un-Hiding Worksheets
Excel 2021 Templates
- Using Templates
- Creating Excel Templates
- Editing Excel Templates
Paste Special Options within Excel 2021
- Using Paste Special to Add, Subtract, Multiply & Divide
- Using Paste Special ‘Values’
- Using Paste Special Transpose Option