Practice Exams

Sharpen your skills with practice exams that test how well you know the most in-demand data science tools and techniques.

A selection of practice exams that will test your current data science knowledge. Identify key areas of improvement to strengthen your theoretical preparation, critical thinking, and practical problem-solving skills so you can get one step closer to realizing your professional goals.

Green cover of Excel Mechanics. This practice exam is from 365 Data Science.
Practice Exams excel

Excel Mechanics

Imagine if you had to apply the same Excel formatting adjustment to both Sheet 1 and Sheet 2 (i.e., adjust font, adjust fill color of the sheets, add a couple of empty rows here and there) which contain thousands of rows. That would cost an unjustifiable amount of time. That is where advanced Excel skills come in handy as they optimize your data cleaning, formatting and analysis process and shortcut your way to a job well-done. Therefore, asses your Excel data manipulation skills with this free practice exam.  

Learn More
Green cover of Formatting Excel Spreadsheets. This practice exam is from 365 Data Science.
Practice Exams excel

Formatting Excel Spreadsheets

Did you know that more than 1 in 8 people on the planet uses Excel and that Office users typically spend a third of their time in Excel. But how many of them use the popular spreadsheet tool efficiently? Find out where you stand in your Excel skills with this free practice exam where you are a first-year investment banking analyst at one of the top-tier banks in the world. The dynamic nature of your position will test your skills in quick Excel formatting and various Excel shortcuts 

Learn More
Green cover of Hypothesis Testing. This practice exam is from 365 Data Science.
Practice Exams excel

Hypothesis Testing

Whenever we need to verify the results of a test or experiment we turn to hypothesis testing. In this free practice exam you are a data analyst at an electric car manufacturer, selling vehicles in the US and Canada. Currently the company offers two car models – Apollo and SpeedX.  You will need to download a free Excel file containing the car sales of the two models over the last 3 years in order find out interesting insights and  test your skills in hypothesis testing. 

Learn More
Green cover of Confidence Intervals. This practice exam is from 365 Data Science.
Practice Exams excel

Confidence Intervals

Confidence Intervals refers to the probability of a population parameter falling between a range of certain values. In this free practice exam, you lead the research team at a portfolio management company with over $50 billion dollars in total assets under management. You are asked to compare the performance of 3 funds with similar investment strategies  and are given a table with the return of the three portfolios over the last 3 years. You will have to use the data to answer questions that will test your knowledge in confidence intervals. 

Learn More
Green cover of Fundamentals of Inferential Statistics. This practice exam is from 365 Data Science.
Practice Exams excel

Fundamentals of Inferential Statistics

While descriptive statistics helps us describe and summarize a dataset, inferential statistics allows us to make predictions based off data. In this free practice exam, you are a data analyst at a leading statistical research company. Much of your daily work relates to understanding data structures and processes, as well as applying analytical theory to real-world problems on large and dynamic datasets. You will be given an excel dataset and will be tested on normal distribution, standardizing a dataset, the Central Limit Theorem among other inferential statistics questions.   

Learn More
Green cover of Fundamentals of Descriptive Statistics. This practice exam is from 365 Data Science.
Practice Exams excel

Fundamentals of Descriptive Statistics

Descriptive statistics helps us understand the actual characteristics of a dataset by generating summaries about data samples. The most popular types of descriptive statistics are measures of center: median, mode and mean. In this free practice exam you have been appointed as a Junior Data Analyst at a property developer company in the US, where you are asked to evaluate the renting prices in 9 key states. You will work with a free excel dataset file that contains the rental prices and houses over the last years.

Learn More
Green cover of Excel Functions. This practice exam is from 365 Data Science.
Practice Exams excel

Excel Functions

The majority of data comes in spreadsheet format, making Excel the #1 tool of choice for professional data analysts. The ability to work effectively and efficiently in Excel is highly desirable for any data practitioner who is looking to bring value to a company. As a matter of fact, being proficient in Excel has become the new standard, as 82% of middle-skill jobs require competent use of the productivity software. Take this free Excel Functions practice exam and test your knowledge on removing duplicate values, transferring data from one sheet to another, rand using the VLOOKUP and SUMIF function.

Learn More
Green Cover of Useful Tools in Excel. This practice exam is from 365 Data Science.
Practice Exams excel

Useful Tools in Excel

What Excel lacks in data visualization tools compared to Tableau, or computational power for analyzing big data compared to Python, it compensates with accessibility and flexibility. Excel allows you to quickly organize, visualize and perform mathematical functions on a set of data, without the need for any programming or statistical skills. Therefore, it is in your best interest to learn how to use the various Excel tools at your disposal. This practice exam is a good opportunity to test your excel knowledge in the text to column functions, excel macros, row manipulation and basic math formulas.

Learn More
Green Cover of Excel Basics. This practice exam is from 365 Data Science.
Practice Exams excel

Excel Basics

Ever since its first release in 1985, Excel continues to be the most popular spreadsheet application to this day- with approximately 750 million users worldwide, thanks to its flexibility and ease of use. No matter if you are a data scientist or not, knowing how to use Excel will greatly improve and optimize your workflow. Therefore, in this free Excel Basics practice exam you are going to work with a dataset of a company in the Fast Moving Consumer Goods Sector as an aspiring data analyst and test your knowledge on basic Excel functions and shortcuts.

Learn More
Green Cover of Data Visualization in Middle-Earth. This practice exam is from 365 Data Science.
Practice Exams excel

Data Visualization in Middle-Earth

If you have ever wanted to use your data visualization skills for a nobler cause that does not involve revenue growth, then this free Data Visualization in Middle-Earth practice exam, by instructor Elitsa Kaloyanova, is for you. As the faith of Middle Earth is entrusted into your hands, you are required to use your data visualization and interpretation skills in Excel to answer these data visualization quiz questions and save the magic lands from destruction.

Learn More
Green Cover of Business Analytics Lifecycle. The practice exam is from 365 Data Science.
Practice Exams excel

Business Analytics Lifecycle

This free practice exam on Business Analytics Lifecycle by business analytics veteran Randy Rosseel will test your understanding of a successful step-by-step implementation of the six stages of the analytics lifecycle. The Business Analytics Test comes with an Excel file of PMG’s financials- major European consumer goods company- where you are asked to put various analytics techniques in to practice.

Learn More