NEW
Font size
WorksheetsNaan Mudhalvan Recap Quiz
Total questions: 15
Worksheet time: 15mins
1. What is the primary goal of data analytics?
Storing data securely
Analyzing raw data to make informed decisions
Deleting unnecessary data
Increasing data file sizes
1. Which of the following is a common tool used in data analytics?
Microsoft Word
Excel
PowerPoint
Photoshop
2. In a recent project, Aarav and Kiara were tasked with analyzing customer feedback data for a new product launch. What type of data is typically analyzed in data analytics?
Only numerical data
Only textual data
Both numerical and categorical data
Only image data
3. What is a key benefit of using data analytics in business?
Increasing the number of employees
Eliminating all risks
Improving decision-making processes
Reducing employee workload
Which of the following is NOT a type of data analytics?
Descriptive Analytics
Diagnostic Analytics
Predictive Analytics
Fictional Analytics
What is the first step in the data analytics process?
A) Data Collection
B) Data Cleaning
C) Data Visualization
D) Reporting
In data analytics, what is the purpose of data cleaning?
A) Making the dataset look visually appealing
B) Removing errors and inconsistencies from the data
C) Organizing data into folders
D) Adding more data to improve accuracy
In a recent project, Myra used analytics to forecast the sales trends for the upcoming quarter. What type of analytics did she employ to make these predictions?
Descriptive Analytics
Predictive Analytics
Diagnostic Analytics
Prescriptive Analytics
Which of the following best describes data visualization?
Storing data in multiple formats
Representing data graphically for better understanding
Writing reports based on data findings
Encrypting data for security
What does correlation in data analytics indicate?
A cause-and-effect relationship between two variables
A random connection between two datasets
A relationship showing how two variables move together
The accuracy of a machine learning model
Which Excel function is used to find the total of a range of numbers?
=TOTAL()
=SUM()
=ADD()
=COUNT()
What does the =AVERAGE(A1:A10) function return?
The highest value in the range
The sum of values in A1 to A10
The average (mean) of values in A1 to A10
The number of cells in the range
What does the =COUNTIF(A1:A10, ">50") function do?
Counts all values in A1:A10 greater than 50
Counts all values in A1:A10 less than 50
Counts all values, including empty ones
Adds all values in A1:A10
What is the primary purpose of charts in Excel?
To format text in cells
To visually represent data for better analysis
To store large amounts of data
To sort and filter data
Which type of chart is best suited for showing trends over time?
Pie Chart
Line Chart
Bar Chart
Scatter Plot
