MS Excel 365 - Expert Test

Before taking this test you should be at the Expert level in MS Excel. This test covers working with: 

  • Pivots including creating calculated fields, grouping fields, timelines,
  • Running totals
  • Creating dynamic named ranges
  • Power Query
  • ISNA, ISBLANK, ISNUMBER and ISERROR

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

Expert

MS Excel 365 Expert Test