Business Intelligence and Excel Quiz

What is the primary purpose of Business Intelligence?

• To create software applications

• To support decision-making with data-driven insights

• To manage hardware resources

• To design websites

Which of the following is a type of data analytics that looks at past data?

• Prescriptive Analytics

• Diagnostic Analytics

• Predictive Analytics

• Descriptive Analytics

What does the VLOOKUP function do in Excel?

• Calculates the average of a range

• Looks up a value in a table and returns a corresponding value

• Counts the number of cells with numbers

• Finds the smallest value in a range

Which Excel feature is used for data cleaning and aggregation?

• Data Visualization

• Power Pivot

• Power Query

• Data Storage

What is the formula to calculate the total sales in Excel?

• =AVERAGE(B2:B6)

• =MAX(B2:B6)

• =SUM(B2:B6)

• =COUNT(B2:B6)

Which of the following is NOT a key concept of Business Intelligence?

• Data Visualization

• Data Storage

• Data Collection and Integration

• Data Deletion

What is the purpose of the Analysis step in the DATA Analytics Framework?

• To acquire necessary data

• To analyze the collected data and answer questions

• To identify what decisions need to be made

• To determine the time-period for data collection

Which formula would you use to find the maximum sales figure?

• =SUM(B2:B6)

• =MAX(B2:B6)

• =COUNT(B2:B6)

• =MIN(B2:B6)

What is the Engagement Rate in the context of social media posts?

• The number of likes divided by the total reach

• The total number of clicks

• The total number of comments

• The total number of shares

How can Excel be integrated with other BI tools?

• By exporting data to CSV files

• By using Power BI for further analysis

• By creating macros

• By using only formulas