CGS 2518 EXAM GUIDE QUESTIONS WITH COMPLETE ANSWERS

CGS 2518 Exam GUIDE Questions with
Complete Answers
Why would you click the collapse outline symbol above a column of outlined data?
(a)You want to see more detailed columns that relate to the formula in that column.
(b)You want to hide the detailed columns to focus on the result column.
(c)You want to insert a subtotal row for a set of rows.
(d)You want to delete columns containing values. - Answer-(b)You want to hide the
detailed columns to focus on the result column.

After creating a blank PivotTable, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
(a)Filters area
(b)Columns area
(c)Values area
(d)Rows area - Answer-(c)Values area

What is the default summary statistic for any value field added to a PivotTable?
(a)Average
(b)Count
(c)Min
(d)Sum - Answer-(d)Sum

You created a PivotTable and changed some values in the dataset from which the
PivotTable was created. How does this affect the PivotTable?
(a)The PivotTable is updated automatically when you make changes to the dataset.
(b)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
(c)You must create a new PivotTable if you want updated results in a PivotTable.
(d)The PivotTable is deleted from the workbook because it is not up to date. - Answer-
(b)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.

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?
(a)Banded Rows and Banded Columns check boxes
(b)Banded Columns check box and a different PivotTable style
(c)Banded Rows check box and a different PivotTable style
(d)A different PivotTable style only - Answer-(c)Banded Rows check box and a different
PivotTable style

Why would you create a slicer for a PivotTable?
(a)To filter data in a PivotTable
(b)To sort data for a field in a PivotTable
(c)To slice the data into a timeline

, (d)To create a color-coded slice for each category - Answer-(a)To filter data in a
PivotTable

Which of the following is not used when creating a calculated field in a PivotTable?
(a)Operands, such as multiplication (*)
(b)Name of a field containing values
(c)Another value to be used in the calculation
(d)A cell reference to a value outside of the PivotTable - Answer-(d)A cell reference to a
value outside of the PivotTable

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?
(a)Make the employee's data points and axis titles invisible.
(b)You cannot delete the rep from the chart without first deleting the data.
(c)Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
(d)Hide that rep's row(s) in the underlying list, which automatically removes that rep
from the chart. - Answer-(c)Filter the Sales Rep field in the PivotChart and deselect the
employee's check box.

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)Solver

What tool is used to view existing range names?
(a)Name Box
(b)Scenario Manager
(c)Name Manager
(d)Solver - Answer-(c)Name Manager

Which tool is most effective when comparing the impact of various combinations of
production expenses and new customer acquisition on net sales profit?
(a)Goal Seek
(b)Solver
(c)Two-variable data table
(d)Scenario Manager - Answer-(c)Two-variable data table

This tool calculates the value required in a single cell to produce a result within a related
cell.
(a)Goal Seek
(b)Solver
(c)One- or two-variable data table
(d)Scenario Manager - Answer-(a)Goal Seek