CGS 2518 EXAM ARMSTRONG
QUESTIONS WITH COMPLETE
SOLUTIONS
You created an outline within a worksheet. What does the below button indicate to the
left of a row heading?
[-]
A. You can add a new row at that location only.
B. You can click it to collapse the details of that category.
C. One or more columns are hidden.
D. You can click it to expand the details of that category. - Answer-B
You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable?
a.
The PivotTable is deleted from the workbook because it is not up to date.
b.
You must create a new PivotTable if you want updated results in a PivotTable.
c.
The PivotTable is updated automatically when you make changes to the dataset.
d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. -
Answer-D
You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data?
a.
Make the employee's data points and axis titles invisible.
b.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from
the chart.
c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
d.
You cannot delete the rep from the chart without first deleting the data. - Answer-C
You have just created a slicer for the State field in a PivotTable. Which of the following
does not characterize the initial slicer?
, a.
The slicer caption is State.
b.
The slicer may display on top of the PivotTable data.
c.
The slicer contains one column of state names or abbreviations.
d.
The slicer buttons are set to filter out all records. - Answer-D
Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a
meal at a restaurant?
a.
=B5*1.2
b.
=Meal Cost * 20%
c.
="Meal Cost"*.2
d.
='Meal Cost'*.2 - Answer-D
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A. Goal seek
B. Scenario manager
C. Data tables
D. Solver - Answer-D
What tool is used to edit pre-existing range names? (select all that apply)
a. name box
b. scenario manager
c. name manager
d. solver - Answer-A and C
Which tool is most effective when comparing the impacts of various combinations of
interest rates and down payments on a mortgage?
A. Goal seek
B. Solver
C. Two-variable data table
D. Scenario manager - Answer-C
This tool calculates the value required in a single cell to produce a desired result within
a related cell.
A. Goal Seek
B. Solver
C. One- or two-variable data tables
QUESTIONS WITH COMPLETE
SOLUTIONS
You created an outline within a worksheet. What does the below button indicate to the
left of a row heading?
[-]
A. You can add a new row at that location only.
B. You can click it to collapse the details of that category.
C. One or more columns are hidden.
D. You can click it to expand the details of that category. - Answer-B
You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable?
a.
The PivotTable is deleted from the workbook because it is not up to date.
b.
You must create a new PivotTable if you want updated results in a PivotTable.
c.
The PivotTable is updated automatically when you make changes to the dataset.
d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. -
Answer-D
You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data?
a.
Make the employee's data points and axis titles invisible.
b.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from
the chart.
c.
Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
d.
You cannot delete the rep from the chart without first deleting the data. - Answer-C
You have just created a slicer for the State field in a PivotTable. Which of the following
does not characterize the initial slicer?
, a.
The slicer caption is State.
b.
The slicer may display on top of the PivotTable data.
c.
The slicer contains one column of state names or abbreviations.
d.
The slicer buttons are set to filter out all records. - Answer-D
Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a
meal at a restaurant?
a.
=B5*1.2
b.
=Meal Cost * 20%
c.
="Meal Cost"*.2
d.
='Meal Cost'*.2 - Answer-D
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A. Goal seek
B. Scenario manager
C. Data tables
D. Solver - Answer-D
What tool is used to edit pre-existing range names? (select all that apply)
a. name box
b. scenario manager
c. name manager
d. solver - Answer-A and C
Which tool is most effective when comparing the impacts of various combinations of
interest rates and down payments on a mortgage?
A. Goal seek
B. Solver
C. Two-variable data table
D. Scenario manager - Answer-C
This tool calculates the value required in a single cell to produce a desired result within
a related cell.
A. Goal Seek
B. Solver
C. One- or two-variable data tables
