CGS 2518 EXAM 2 KEN ARMSTRONG
QUESTIONS AND ANSWERS
Sum - Answer-What is the default summary statistic for any value field added to a
PivotTable?
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. -
Answer-You created a PivotTable and changed some values in the dataset from which
the PivotTable was created. How does this affect the PivotTable?
Banded Rows check box and a different PivotTable style - Answer-What settings should
you select to apply a different color scheme and display a fill color for every other row or
horizontal lines within the PivotTable?
To filter data in a PivotTable - Answer-Why would you create a slicer for a PivotTable?
A cell reference to a value outside of the PivotTable - Answer-Which of the following is
not used when creating a calculated field in a PivotTable?
Filter the Sales Rep field in the PivotChart and deselect the employee's check box. -
Answer-You created a PivotChart showing sales by quarter by sales rep. How do you
remove a sales rep from the chart without deleting the data?
Solver - Answer-Which what-if analysis tool is the best option for complex calculations
requiring constrained optimization?
Name Manager - Answer-What tool is used to view existing range names?
Two-variable data table - Answer-Which tool is most effective when comparing the
impact of various combinations of production expenses and new customer acquisition
on net sales profit?
Goal Seek - Answer-This tool calculates the value required in a single cell to produce a
result within a related cell.
Solver - Answer-This analysis tool can handle multiple adjustable cells while minimizing,
maximizing, or meeting goals.
Solver - Answer-Which of the following is an Excel add-in?
2021_Rate - Answer-Which of the following is not an acceptable range name?
F3 - Answer-What is the keyboard shortcut to open the Paste Name dialog box?
QUESTIONS AND ANSWERS
Sum - Answer-What is the default summary statistic for any value field added to a
PivotTable?
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. -
Answer-You created a PivotTable and changed some values in the dataset from which
the PivotTable was created. How does this affect the PivotTable?
Banded Rows check box and a different PivotTable style - Answer-What settings should
you select to apply a different color scheme and display a fill color for every other row or
horizontal lines within the PivotTable?
To filter data in a PivotTable - Answer-Why would you create a slicer for a PivotTable?
A cell reference to a value outside of the PivotTable - Answer-Which of the following is
not used when creating a calculated field in a PivotTable?
Filter the Sales Rep field in the PivotChart and deselect the employee's check box. -
Answer-You created a PivotChart showing sales by quarter by sales rep. How do you
remove a sales rep from the chart without deleting the data?
Solver - Answer-Which what-if analysis tool is the best option for complex calculations
requiring constrained optimization?
Name Manager - Answer-What tool is used to view existing range names?
Two-variable data table - Answer-Which tool is most effective when comparing the
impact of various combinations of production expenses and new customer acquisition
on net sales profit?
Goal Seek - Answer-This tool calculates the value required in a single cell to produce a
result within a related cell.
Solver - Answer-This analysis tool can handle multiple adjustable cells while minimizing,
maximizing, or meeting goals.
Solver - Answer-Which of the following is an Excel add-in?
2021_Rate - Answer-Which of the following is not an acceptable range name?
F3 - Answer-What is the keyboard shortcut to open the Paste Name dialog box?
