MS Excel 365 - Master Test
Before taking this test you should be at the Master level in MS Excel. This test covers working with:
- Financial functions such as PMT, FV, PV and Rate
- Lookup and Reference Functions such as Match, Index, Offset, Filter and Sort
- Pivot Tables and Charts
- Documenting and Auditing
- Manipulating Data including Sorting, Compare and Merge and Flash Fill
- Automating repetitive tasks with Macros.
There are 25 questions included in the test with questions ranging from true/false, fill in the blank, sequence, multiple choice and hot spot. All these topics are covered in the Master Course.