Microsoft Excel Certification Preparation Practice Tests

Here are some important Excel topics that are essential for proficiency, whether you're using Excel for basic tasks, data analysis, or advanced functions:

Practice test 1:

59 questions | 1 hour | 50% correct required to pass

* Cell Referencing (Relative, Absolute, Mixed)

*  Basic Formulas and Functions (SUM, AVERAGE, MIN, MAX, COUNT, etc.)

*  Data Entry and Editing

*  Formatting Cells (Number, Text, Date, Currency, etc.)

*  Conditional Formatting

*  Sorting and Filtering Data

* Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)

* Date and Time Functions (TODAY, NOW, DATE, DATEDIF, NETWORKDAYS)

* Logical Functions (IF, AND, OR, NOT)

* Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)

* Mathematical Functions (ROUND, SUMIF, SUMIFS, COUNTIF, COUNTIFS)

* Data Validation

Practice test 2:

50 questions | 1 hour | 50% correct required to pass

• Pivot Tables and Pivot Charts

• Data Tables (One-variable and Two-variable data tables)

• What-If Analysis (Goal Seek, Scenario Manager)

• Advanced Filter

• Slicers and Timelines

• Power Query (Get & Transform Data)

• Array Formulas (Dynamic Array Formulas, SEQUENCE, FILTER, UNIQUE)

• Advanced Lookup Functions (XLOOKUP, XMATCH)

• Statistical Functions (AVERAGEIFS, MEDIAN, MODE, STDEV.P, STDEV.S)

• Financial Functions (NPV, IRR, PMT, FV)

• Text to Columns and Flash Fill

Practice test 3:

50 questions | 1 hour | 50% correct required to pass

• Creating and Customizing Charts (Bar, Line, Pie, Scatter, etc.)

• Sparklines

• Creating Dashboards

• Conditional Formatting for Visualizations

• Combo Charts (Mixed Chart Types)

• Recording Macros

• Running and Editing Macros

• Basic VBA Programming (Creating Functions, Loops, Conditional Statements)

• Automating Tasks with VBA

Practice test 4:

46 questions | 1 hour | 50% correct required to pass

• Data Import and Export (CSV, Text Files, Databases)

• Excel Tables (Structured References)

• Protecting and Sharing Workbooks

• Track Changes and Comments

• Collaboration Features in Excel (Excel Online, Co-Authoring)

• Power Pivot (Data Models, Measures, Relationships)

• Power BI Integration

• Advanced Power Query Techniques

• Using DAX in Excel