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
Can't access the exercise? Below you can find the link to download the Excel file:
Data-Analyst-Exam-2-1.xlsx (2914 downloads )