CGS 2518 EXAM Q&A
You constructed a loan amortization table with beginning balance, monthly payment,
interest paid, principle repayment, and ending balance columns. If all the formulas are
correct, which is the only column that shows an increase in value throughout the term of
the loan?
a) Beginning Balance
b) Monthly Payment
c) Interest Paid
d) Principal Repayment - Answer-c) Interest Paid
What function would you use to calculate the total number of periods in a loan or
investment?
a) NPER
b) RATE
c) PV
d) FV - Answer-a) NPER
You want to apply a subtotal to a dataset containing names, departments, and salaries.
What is the first step you need to do?
a) Filter the dataset by salaries
b) Select the function to be used for the subtotal rows within the dataset
c) Insert new rows where you want the subtotal rows within the dataset - Answer-a)
Filter the dataset by salaries
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 pivot table, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
a)Filter area
b) Columns area
c) Values area
d) Rows area - Answer-d) Rows 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 pivot table 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
Which of the following is not used when creating a calculated field in a PivotTable?
a) Operands, such as multiplication(*)
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 in the underlying list, which automatically removes that rep from
the chart - Answer-I assume..... a) Operands, such as multiplication(*)
but i need to clarify
You created a pivot chart 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 pivot chart and deselect the employee's check box
d)Hide that rep's row in the underlying list, which automatically removes that rep from
the chart - Answer-c)filter the sales rep field in the pivot chart and deselect the
employee's check box
Which what if analysis is the best option for complex calculations requiring constrained
optimization?
a)Goal seek
b)Scenario Manager
c)Data Tables
d)Solver - Answer-b)Scenario Manager
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
You constructed a loan amortization table with beginning balance, monthly payment,
interest paid, principle repayment, and ending balance columns. If all the formulas are
correct, which is the only column that shows an increase in value throughout the term of
the loan?
a) Beginning Balance
b) Monthly Payment
c) Interest Paid
d) Principal Repayment - Answer-c) Interest Paid
What function would you use to calculate the total number of periods in a loan or
investment?
a) NPER
b) RATE
c) PV
d) FV - Answer-a) NPER
You want to apply a subtotal to a dataset containing names, departments, and salaries.
What is the first step you need to do?
a) Filter the dataset by salaries
b) Select the function to be used for the subtotal rows within the dataset
c) Insert new rows where you want the subtotal rows within the dataset - Answer-a)
Filter the dataset by salaries
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 pivot table, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
a)Filter area
b) Columns area
c) Values area
d) Rows area - Answer-d) Rows 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 pivot table 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
Which of the following is not used when creating a calculated field in a PivotTable?
a) Operands, such as multiplication(*)
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 in the underlying list, which automatically removes that rep from
the chart - Answer-I assume..... a) Operands, such as multiplication(*)
but i need to clarify
You created a pivot chart 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 pivot chart and deselect the employee's check box
d)Hide that rep's row in the underlying list, which automatically removes that rep from
the chart - Answer-c)filter the sales rep field in the pivot chart and deselect the
employee's check box
Which what if analysis is the best option for complex calculations requiring constrained
optimization?
a)Goal seek
b)Scenario Manager
c)Data Tables
d)Solver - Answer-b)Scenario Manager
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
