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
Who is it for
The wide applicability of the most popular spreadsheet tool in the world means that this free practice test on Excel Spreadsheets is meant for Data Scientists, Business Analysts Data Analysts, as well as teachers, students, doctors and anyone who has to work with some type of data.
How it can help you
Even if you are not a Business Analyst who wants to work at a top-tier bank or a Data Scientist working at a prestige company knowing how to optimize your workflow in Excel is a great ability to have in a lot of work environments.
Check out our most helpful downloadable resources according to 365 Data Science students and our expert team of instructors.
Introduction to Data Science Disciplines
The term “Data Science” dates back to the 1960s, to describe the emerging field of working with large amounts of data that drives organizational growth and decision-making. While the essence has remained the same, the data science disciplines have changed a lot over the past decades thanks to rapid technological advancements. In this free introduction to data science practice exam, you will test your understanding of the modern day data science disciplines and their role within an organization.
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.
State-of-the-art machine learning algorithms have opened a whole new realm of possibilities for businesses to optimize their processes and create new product/service features, that maximize competitive advantages. Used in recommendation systems, fraud detection, spam filtering, self-driving cars, to name a few, these advanced algorithms are only getting more popular by the day. Take this free machine learning practice exam and test your knowledge on supervised, unsupervised and reinforcement machine learning, and their applications.
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.
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.
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.
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.
SQL is one of the most popular and in-demand programming languages, because of its intuitive syntax, ubiquitous presence in the business world, and ability to query data and perform analysis. Therefore, possessing SQL skills will give you a significant career advantage in the modern data-driven workforce. Test your knowledge in the basics of SQL with this free SQL SELECT Statement practice exam designed by 365 Data Science instructor Martin Ganchev. These set of SQL questions will test your knowledge on creating databases, SQL Constraints, and the SQL Select Query by giving you a free .sql file containing company data, to work with.