WorksheetsData Analytics
Total questions: 15
Worksheet time: 8mins
Which of the following is used to visualize data?
Python
Excel
Tableau
All of the Above
Which function in Excel is used to calculate the average?
=MEAN()
=AVG()
=AVERAGE()
=SUM()/COUNT()
What is the primary purpose of data cleaning?
Compressing data
Making charts
Removing or correcting inaccurate data
Encrypting data
Which Python library is used for data analysis?
NumPy
Pandas
Matplotlib
All of the above
Which chart is best for showing trends over time?
Pie chart
Bar chart
Line Chart
Histogram
What does SQL stand for?
Structured Query Language
Simplified Quality Language
Sequential Query Logic
Strong Query Language
What is the function used in Excel to count the number of cells that meet a specific condition?
=FILTER()
=COUNTIF()
=AVERAGEIF()
=SUMIF()
Which of the following is a popular database management system?
JavaScript
CSS
HTML
MySQL
What is the main goal of data visualization?
To encrypt data
To store data
To present data in a clear and effective way
To analyze data
Which of the following is a common tool for creating interactive dashboards?
Power BI
Notepad
Word
Photoshop
What is the purpose of the VLOOKUP function in Excel?
To find a value in a table
To create a chart
To format cells
To sort data
Which type of chart is most effective for comparing parts of a whole?
Bar chart
Line chart
Scatter plot
Pie chart
What is the purpose of using indexes in a database?
To speed up data retrieval
To format data
To create backups
To store images
Which of the following is a common method for data analysis?
Data mining
Data entry
Data storage
Data encryption
What type of data visualization is best for displaying the distribution of a dataset?
Bar chart
Box plot
Line chart
Pie chart
