Data Analyst Practice Test number 2

This is an Excel Data Analyst exam, you will be challenged to analyze data from the 2018 World Cup of the Nigerian football team! 🙂

You will be using functions and topics such as:

  • COUNTIF
  • FILTER
  • Excel Dynamic Arrays
  • SEARCH
  • SUBSTITUTE
  • ISNUMBER
  • LEN
  • Boolean algebra

And more…

You can view the answers in the Solution tab! 🙂

Exam level – Advanced

If you prefer to work on this exam using regular Excel – click here to download the Data Analyst Practice exam no. 2

Expand your Analytics Skills! Check Out Coursera’s Google Data Analytics Professional Certificate Here

Having an issue with the formulas' language? check out this post