Data Analytics

What is the primary goal of data analytics?

• To collect data

• To analyze data

• To visualize data

• To have insights on data

Which is not a type of data analytics

• Descriptive Analytics

• Predictive Analytics

• Narrative Analytics

• Prescriptive Analytics

What is the first step in data analysis process?

• Data cleaning

• Data collection

• Data visualization

• Data interpretation

Which of the following is a common tool used for data visualization?

• Microsoft Word

• Microsoft Excel

• Microsoft Powerpoint

• Microsoft OneNote

What is the difference between structured and unstructured data?

• Structured data is numeric, while unstructured data is textual.

• Structured data is highly organized, while unstructured data lacks a specific structure.

• Structured data is qualitative, while unstructured data is quantitative.

• Structured data is visual, while unstructured data is textual.

What is a pivot table used for in Excel?

• To create charts

• To filter data

• To perform calculations

• To summarize and analyze data

What does a dollar sign ($) do in an Excel formula?

• Indicates a currency format

• Creates an absolute reference

• Converts numbers to text

• Applies conditional formatting

Which of the following elements is commonly used in a dashboard?

• Text boxes

• Pie charts

• Pivot Tables

• All of the above

What tool can be used to create interactive dashboards in Excel?

• Solver

• Data Validation

• Slicers

• Goal Seek

Tool used for information management and business intelligence