Excel 1 – Quiz | Divex Consult

What is the primary difference between data analysis and data analytics? *

Data analysis focuses on collecting and organizing data, while data analytics applies advanced techniques for strategic decision-making.

Data analysis and data analytics are the same and can be used interchangeably.

Data analytics is only concerned with data collection, while data analysis focuses on insights.

Data analysis involves predictive and prescriptive analytics, while data analytics does not

Which of the following best describes the role of data analytics? *

Using only descriptive analytics to summarize past trends.

Collecting, processing, and analyzing data to uncover patterns and support decision-making

Focusing only on data visualization without statistical techniques.

Avoiding automation and machine learning techniques in data processing

Which type of data analytics is used to analyze past data to understand what happened? * *

Predictive Analytics

Descriptive Analytics

Diagnostic Analytics

Prescriptive Analytics

Which of the following is NOT a key step in data analysis? * *

Data Collection

Data Cleaning

Data Guessing

Data Transformation

In which of the following industries can data analytics be applied? * *

Healthcare

Finance

Retail

All of the above

Which of the following is the first step in the data analysis process? *

Analyze

Process

Ask

Share

Which of the following tools is best suited for visualizing data? * *

SQL

Power BI

Python

Jupyter Notebook

Which of the following is a key principle of data ethics? * *

Selling customer data without consent

Ensuring data privacy and security

Manipulating data for biased results

Using data without transparency

Excel Data Analysis