DAB EXAM 2 QUESTIONS WITH 100%
CORRECT ANSWERS 2024/2025
You have a large dataset, and you want to segment it into categories to understand the distribution of
values in each category. Which Excel Data Analysis ToolPak feature would be most suitable for this task? -
ANSWERSCorrelation
The method of descriptive analytics that we can use to express financial information in relation to some
relevant figure or base such as Sales or Total Assets is.... - ANSWERSvertical analysis
The business information system that contains descriptive analytics data related to the sequences of
processes to move a product from raw materials to final customer delivery is called... - ANSWERSSupply
Chain Management System
What type of analytics are performed to investigate the underlying reasons for past results that cannot
be answered by simply looking at descriptive data? - ANSWERSdiagnostic analytics
In diagnostic analytics, which category focuses on uncovering hidden connections, trends, or
associations between different variables in a dataset? - ANSWERSFinding previously unknown linkages
In the context of diagnostic analytics, which category involves the process of detecting unusual patterns
or data points that deviate significantly from the norm? - ANSWERSIdentifying anomalies and outliers
Which Excel Data Analysis ToolPak feature is most appropriate for summarizing the main characteristics
of a dataset, such as mean, median, and standard deviation? - ANSWERSDescriptive Statistics
Conditional Formatting is most often used as a technique in which type of analytics? -
ANSWERSDiagnostic
Identifying outliers is most often used as a technique in which type of analytics? - ANSWERSdiagnostic
CORRECT ANSWERS 2024/2025
You have a large dataset, and you want to segment it into categories to understand the distribution of
values in each category. Which Excel Data Analysis ToolPak feature would be most suitable for this task? -
ANSWERSCorrelation
The method of descriptive analytics that we can use to express financial information in relation to some
relevant figure or base such as Sales or Total Assets is.... - ANSWERSvertical analysis
The business information system that contains descriptive analytics data related to the sequences of
processes to move a product from raw materials to final customer delivery is called... - ANSWERSSupply
Chain Management System
What type of analytics are performed to investigate the underlying reasons for past results that cannot
be answered by simply looking at descriptive data? - ANSWERSdiagnostic analytics
In diagnostic analytics, which category focuses on uncovering hidden connections, trends, or
associations between different variables in a dataset? - ANSWERSFinding previously unknown linkages
In the context of diagnostic analytics, which category involves the process of detecting unusual patterns
or data points that deviate significantly from the norm? - ANSWERSIdentifying anomalies and outliers
Which Excel Data Analysis ToolPak feature is most appropriate for summarizing the main characteristics
of a dataset, such as mean, median, and standard deviation? - ANSWERSDescriptive Statistics
Conditional Formatting is most often used as a technique in which type of analytics? -
ANSWERSDiagnostic
Identifying outliers is most often used as a technique in which type of analytics? - ANSWERSdiagnostic
