CGS 2518 QUIZ QUESTIONS WITH
CORRECT ANSWERS
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
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 view existing range names?
(a)Name Box
(b)Scenario Manager
(c)Name Manager
(d)Solver - Answer-C
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
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
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or
meeting goals.
(a)Goal Seek
(b)Solver
(c)One- or two-variable data table
(d)Scenario Manager - Answer-B
, Which of the following is an Excel add-in?
(a)Goal Seek
(b)Solver
(c)One- or two-variable data table
(d)Scenario Manager - Answer-B
Which of the following is not an acceptable range name?
(a)Apr
(b)Rate_2021
(c)2021_Rate
(d)Payment - Answer-C
What is the keyboard shortcut to open the Paste Name dialog box?
(a)F2
(b)F3
(c)F4
(d)F5 - Answer-B
Which of the following tools can incorporate constraints?
(a)Goal Seek
(b)Solver
(c)Data Tables
(d)Scenario Manager - Answer-B
The Solver add-in displays on this tab in the ribbon.
(a)Home tab.
(b)Formulas tab.
(c)Data tab.
(d)Analyze tab. - Answer-C
The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?
(a)=YEAR(C1)
(b)=MONTH(C1)
(c)=DAYS(B1,C1)
(d)=DAY(C1) - Answer-D
What function would you use to calculate the total interest paid for the first year of a
mortgage?
(a)CUMIPMT
(b)PMT
(c)PPMT
(d)CUMPRINC - Answer-A
You constructed a loan amortization table with beginning balance, monthly payment,
interest paid, principal repayment, and ending balance columns. If all the formulas are
CORRECT ANSWERS
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
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 view existing range names?
(a)Name Box
(b)Scenario Manager
(c)Name Manager
(d)Solver - Answer-C
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
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
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or
meeting goals.
(a)Goal Seek
(b)Solver
(c)One- or two-variable data table
(d)Scenario Manager - Answer-B
, Which of the following is an Excel add-in?
(a)Goal Seek
(b)Solver
(c)One- or two-variable data table
(d)Scenario Manager - Answer-B
Which of the following is not an acceptable range name?
(a)Apr
(b)Rate_2021
(c)2021_Rate
(d)Payment - Answer-C
What is the keyboard shortcut to open the Paste Name dialog box?
(a)F2
(b)F3
(c)F4
(d)F5 - Answer-B
Which of the following tools can incorporate constraints?
(a)Goal Seek
(b)Solver
(c)Data Tables
(d)Scenario Manager - Answer-B
The Solver add-in displays on this tab in the ribbon.
(a)Home tab.
(b)Formulas tab.
(c)Data tab.
(d)Analyze tab. - Answer-C
The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?
(a)=YEAR(C1)
(b)=MONTH(C1)
(c)=DAYS(B1,C1)
(d)=DAY(C1) - Answer-D
What function would you use to calculate the total interest paid for the first year of a
mortgage?
(a)CUMIPMT
(b)PMT
(c)PPMT
(d)CUMPRINC - Answer-A
You constructed a loan amortization table with beginning balance, monthly payment,
interest paid, principal repayment, and ending balance columns. If all the formulas are
