QBA EXAM UPDATED QUESTIONS AND
CORRECT ANSWERS.
After clicking a field name in the VALUES area of a PivotTable, the Field Settings dialog box can
be opened bywhich of the following? - ANS Click the Field Settings button in the PivotTable
Analyze tab of the Ribbon
A Treemap chart is an example of which data analytics technique? - ANS Data Visualization
Which tab of the Ribbon contains commands to change the color of cells or text on a
worksheet? - ANS Home
The following warning was found on a worksheet that contains a PivotTable: "This PivotTable
ONLY includes data from the range A2:C26 in the Sales Data worksheet." This is an example of
a: - ANS Warning Data Internal Control
Which of the following is where you would find commands to hide or unhide a column? -
ANS Home Tab Format Button
Which of the following is one of the components of the DATA Analytics Framework? -
ANS Decisions
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
,Assume a dataset is being sorted using a column that contains the months of the year. If the
data is going to be sorted in calendar year order (January to December), what should be
selected from the Order dropdown box in the Sort dialog box? - ANS Custom List
Which of the following is the first step of the DATA Analytics framework? - ANS Decision
When entering numeric data into an Excel worksheet, you should omit any symbols such as
commas or dollar signs because: - ANS It slows down the data entry process
Which of the following is NOT one of the components of the DATA Analytics Framework? -
ANS Data Design
Which of the following is true when working with an Excel worksheet that was created by
another person? - ANS A data audit must be conducted before using an Excel Worksheet that
was created by another person
The sort command is found in which of the following combinations? - ANS Data tab, Sort
button
What is the center area of a chart that displays data and labels based on the type of chart that
is being created? - ANS Plot Area
Which of the following Ribbon tabs would be used to add a header or footer to a worksheet? -
ANS Insert
Which of the following is found in the Data Analytics Model? - ANS All of the above
Which of the following are true with respect to the grand totals displayed for columns and rows
on a PivotTable? - ANS The grand totals are a permanent feature on a Pivot Table and cannot
be removed
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, Which of the following is the last step of the DATA Analytics framework? - ANS Analysis
_____ is the way in which data is presented or visualized to an audience to explain
circumstances and decisions in professional settings. - ANS Data Presentation
Using data analytics to predict what might happen in the future is called - ANS Predictive
Analytics
A dataset contains the following columns: Year, Month, and Total Sales Dollars. If a PivotTable is
going to be created to sum the sales dollars by year, the Total Sales Dollars field should be
dragged into which area of the PivotTable? - ANS VALUES
The following warning was found on a worksheet that contains a PivotTable: "This PivotTable
ONLY includes data from the range A2:C26 in the Sales Data worksheet." This is an example of
a: - ANS Warning Data Internal Control
Which of the following is a collection of investments managed by a financial professional and
traded on the openmarket? - ANS ETF
A home buyer is purchasing a home that costs $250,000. Cash in the amount of $50,000 was
paid. A loan will be used to pay for the remaining cost of the house. Based on this information,
which of the following is true? - ANS The down payment is $50,000
The "Lie Factor" refers to - ANS The ratio of the size of the effect in the graphic to the size of
the effect in the data
When entering numeric data into an Excel worksheet, you should omit any symbols such as
commas or dollar signs because: - ANS it slows down the data entry process
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
CORRECT ANSWERS.
After clicking a field name in the VALUES area of a PivotTable, the Field Settings dialog box can
be opened bywhich of the following? - ANS Click the Field Settings button in the PivotTable
Analyze tab of the Ribbon
A Treemap chart is an example of which data analytics technique? - ANS Data Visualization
Which tab of the Ribbon contains commands to change the color of cells or text on a
worksheet? - ANS Home
The following warning was found on a worksheet that contains a PivotTable: "This PivotTable
ONLY includes data from the range A2:C26 in the Sales Data worksheet." This is an example of
a: - ANS Warning Data Internal Control
Which of the following is where you would find commands to hide or unhide a column? -
ANS Home Tab Format Button
Which of the following is one of the components of the DATA Analytics Framework? -
ANS Decisions
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
,Assume a dataset is being sorted using a column that contains the months of the year. If the
data is going to be sorted in calendar year order (January to December), what should be
selected from the Order dropdown box in the Sort dialog box? - ANS Custom List
Which of the following is the first step of the DATA Analytics framework? - ANS Decision
When entering numeric data into an Excel worksheet, you should omit any symbols such as
commas or dollar signs because: - ANS It slows down the data entry process
Which of the following is NOT one of the components of the DATA Analytics Framework? -
ANS Data Design
Which of the following is true when working with an Excel worksheet that was created by
another person? - ANS A data audit must be conducted before using an Excel Worksheet that
was created by another person
The sort command is found in which of the following combinations? - ANS Data tab, Sort
button
What is the center area of a chart that displays data and labels based on the type of chart that
is being created? - ANS Plot Area
Which of the following Ribbon tabs would be used to add a header or footer to a worksheet? -
ANS Insert
Which of the following is found in the Data Analytics Model? - ANS All of the above
Which of the following are true with respect to the grand totals displayed for columns and rows
on a PivotTable? - ANS The grand totals are a permanent feature on a Pivot Table and cannot
be removed
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, Which of the following is the last step of the DATA Analytics framework? - ANS Analysis
_____ is the way in which data is presented or visualized to an audience to explain
circumstances and decisions in professional settings. - ANS Data Presentation
Using data analytics to predict what might happen in the future is called - ANS Predictive
Analytics
A dataset contains the following columns: Year, Month, and Total Sales Dollars. If a PivotTable is
going to be created to sum the sales dollars by year, the Total Sales Dollars field should be
dragged into which area of the PivotTable? - ANS VALUES
The following warning was found on a worksheet that contains a PivotTable: "This PivotTable
ONLY includes data from the range A2:C26 in the Sales Data worksheet." This is an example of
a: - ANS Warning Data Internal Control
Which of the following is a collection of investments managed by a financial professional and
traded on the openmarket? - ANS ETF
A home buyer is purchasing a home that costs $250,000. Cash in the amount of $50,000 was
paid. A loan will be used to pay for the remaining cost of the house. Based on this information,
which of the following is true? - ANS The down payment is $50,000
The "Lie Factor" refers to - ANS The ratio of the size of the effect in the graphic to the size of
the effect in the data
When entering numeric data into an Excel worksheet, you should omit any symbols such as
commas or dollar signs because: - ANS it slows down the data entry process
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
