Data Analyst Practice Test number 1

This is an Excel Data Analyst exam, you will be challenged to solve various data analysis issues that Excel Data Analysts face in their everyday work!

You will be using functions such as:

  • COUNTIF
  • TRIM
  • UNIQUE
  • XLOOKUP
  • VALUE

And more… 

You can view the answers in the Solution tab! 🙂

Exam level – Intermediate-Advanced

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

 

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