Data Analytics

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