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.
Course Content
string(5) "13238"
Master
MS Excel 365 Master Test
Use the X inside a lesson to save your progress. Then click Continue
