CGS 2518 EXAM QUESTIONS WITH
COMPLETE ANSWERS
What settings should you select for a PivotTable if you want to apply a different color
scheme and display different fill colors for main category rows and horizontal lines
within the PivotTable?
A. Banded Rows check box and a different PivotTable style.
B. Banded Columns check box and a different PivotTable style.
C. Banded Rows and Banded Columns check boxes.
D. A different PivotTable style only. - Answer-A (Banded Rows check box and a
different PivotTable style)
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 (The slicer buttons are set
to filter out all records)
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
d.
='Meal Cost'*.2 - Answer-D (='Meal Cost'*.2)
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
(Filter the Sales Rep field in the PivotChart and deselect the employee's check box)
Currently, the House Types field is in the ROWS area, the Real Estate Agent field is in
the COLUMNS area, and Sum of List Prices is in the VALUES area. How can you
modify the PivotTable to display the agent names as subcategories within the house
types in the first column?
A. Drag the House Types field from the ROWS area and drop it below the Real Estate
Agent field in the COLUMNS area.
B. Drag the Real Estate Agent field from the COLUMNS area and drop it below the
House Types field in the ROWS area.
C. Drag the Real Estate Agent field from the COLUMNS area and drop it above the
House Types field in the ROWS area.
D. Drag the House Types field from the ROWS area to the FILTERS area and drag the
Real Estate Agent field from the COLUMNS area to the ROWS area. - Answer-B (Drag
the Real Estate Agent field from the COLUMNS area and drop it below the House
Types field in the ROWS)
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A. Goal Seek
B. Scenario Manager
C. Name Manager
D. Solver - Answer-D (Solver)
What tool is used to edit pre-existing range names? (Check all that apply.
A. Name Box
B. Scenario Manager
COMPLETE ANSWERS
What settings should you select for a PivotTable if you want to apply a different color
scheme and display different fill colors for main category rows and horizontal lines
within the PivotTable?
A. Banded Rows check box and a different PivotTable style.
B. Banded Columns check box and a different PivotTable style.
C. Banded Rows and Banded Columns check boxes.
D. A different PivotTable style only. - Answer-A (Banded Rows check box and a
different PivotTable style)
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 (The slicer buttons are set
to filter out all records)
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
d.
='Meal Cost'*.2 - Answer-D (='Meal Cost'*.2)
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
(Filter the Sales Rep field in the PivotChart and deselect the employee's check box)
Currently, the House Types field is in the ROWS area, the Real Estate Agent field is in
the COLUMNS area, and Sum of List Prices is in the VALUES area. How can you
modify the PivotTable to display the agent names as subcategories within the house
types in the first column?
A. Drag the House Types field from the ROWS area and drop it below the Real Estate
Agent field in the COLUMNS area.
B. Drag the Real Estate Agent field from the COLUMNS area and drop it below the
House Types field in the ROWS area.
C. Drag the Real Estate Agent field from the COLUMNS area and drop it above the
House Types field in the ROWS area.
D. Drag the House Types field from the ROWS area to the FILTERS area and drag the
Real Estate Agent field from the COLUMNS area to the ROWS area. - Answer-B (Drag
the Real Estate Agent field from the COLUMNS area and drop it below the House
Types field in the ROWS)
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A. Goal Seek
B. Scenario Manager
C. Name Manager
D. Solver - Answer-D (Solver)
What tool is used to edit pre-existing range names? (Check all that apply.
A. Name Box
B. Scenario Manager
