1
For Expert help and assignment solutions, +254707240657
QBA Quiz Questions and Answers (100%
Correct Answers) Already Graded A+
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
© 2025 Assignment Expert
technique? [ Ans: ] Data Visualization
Which tab of the Ribbon contains commands to change the color
of cells or text on a worksheet? [ Ans: ] Home
Guru01 - Stuvia
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
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
, 2
For Expert help and assignment solutions, +254707240657
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
© 2025 Assignment Expert
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? [
Guru01 - Stuvia
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
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
, 3
For Expert help and assignment solutions, +254707240657
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
© 2025 Assignment Expert
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
Guru01 - Stuvia
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.
Which of the following is an investment made in regular
installments over a period of time? [ Ans: ] annuity
The terms of a lease would be used to define which of the
following arguments for the PMT function to calculate monthly
lease payments. [ Ans: ] nper
Which of the following commands can be used to save an Excel
workbook to the cloud using OneDrive [ Ans: ] Save As
The sort command is found in which of the following
combinations? [ Ans: ] Data tab, Sort Button
A Treemap chart is an example of which data analytics
technique? [ Ans: ] Data Visualization
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
For Expert help and assignment solutions, +254707240657
QBA Quiz Questions and Answers (100%
Correct Answers) Already Graded A+
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
© 2025 Assignment Expert
technique? [ Ans: ] Data Visualization
Which tab of the Ribbon contains commands to change the color
of cells or text on a worksheet? [ Ans: ] Home
Guru01 - Stuvia
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
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
, 2
For Expert help and assignment solutions, +254707240657
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
© 2025 Assignment Expert
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? [
Guru01 - Stuvia
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
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
, 3
For Expert help and assignment solutions, +254707240657
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
© 2025 Assignment Expert
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
Guru01 - Stuvia
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.
Which of the following is an investment made in regular
installments over a period of time? [ Ans: ] annuity
The terms of a lease would be used to define which of the
following arguments for the PMT function to calculate monthly
lease payments. [ Ans: ] nper
Which of the following commands can be used to save an Excel
workbook to the cloud using OneDrive [ Ans: ] Save As
The sort command is found in which of the following
combinations? [ Ans: ] Data tab, Sort Button
A Treemap chart is an example of which data analytics
technique? [ Ans: ] Data Visualization
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
