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.
Who is it for
How it can help you
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.
Learn More
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
Intrо to Machine Learning
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.
Learn More
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
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
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
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
SQL SELECT Statement
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.
Learn MoreExcel Mechanics
