Exam (elaborations)
CGS 2518 EXAM 2 ARMSTRONG QUESTIONS AND ANSWERS
- Course
- Institution
CGS 2518 EXAM 2 ARMSTRONG QUESTIONS AND ANSWERS
[Show more]
Content preview
CGS 2518 EXAM 2 ARMSTRONGQUESTIONS AND ANSWERS
Which tools are best suited to calculate the impact of multiple interest rates on an auto
loan? Check all that apply.
Goal seek
Scenario Manager
One-variable data tale
Solver - Answers -Scenario Manager
One-variable data table
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
Goal seek
Scenario Manager
Data Tables
Solver - Answers -Solver
Which tools are best suited to calculate the impact of multiple interest rates on an auto
loan? Check all that apply.
Goal seek
Scenario Manager
One-variable data tale
Solver - Answers -Two-variable data table
This tool calculates the value required in a single cell to produce a desired result within
a related cell.
Goal Seek
Solver
One- or Two-variable data table
Scenario Manager - Answers -Goal Seek
This analysis tool has the ability to handle multiple adjustable cells while minimizing,
maximizing, or meeting goals.
Goal Seek
Solver
One- or Two-variable data table
Scenario Manager - Answers -Solver
Which of the following is an Excel add-in?
Goal Seek
, Solver
One- or Two- variable data table
Scenario Manager - Answers -Solver
Doug would like to purchase a new automobile. He has budgeted for $600 per month. If
the interest and number of payments are constant variables that cannot change, which
analysis tool should Doug use to calculate the amount to spend on a car? - Answers -
Goal Seek
A worksheet contains a PivotTable placeholder and the PivotTable Field List.Where do
you drag the State field if you want a list of each state in the first column of the
PivotTable? - Answers -Row Labels area
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? - Answers -Filter
the Sales Rep field in the PivotChart and deselect the employee's check box.
Which PivotTable calculated field is correctly constructed to calculate a 20% tip on a
meal at a restaurant? - Answers -='Meal Cost'*.2
You 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? - Answers
-Click Refresh in the Data group on the Options tab to update the PivotTable.
Which dialog box enables you to specify the result cells for a scenario summary report?
Scenario Summary
Scenario Values
Add Scenario
Solver Options - Answers -Scenario Summary
Which of the following tools can incorporate constraints?
Goal Seek
Solver
Data Tables
Scenario Manager - Answers -Solver
How can you determine if the Solver add-in is active? Check all that apply.
Solver is an option in the Home Tab of the Ribbon.
Solver is available via right-click.
Solver appears in the Data tab of the Ribbon.
Solver appears in the Goal Seek dialog box to make it appear as a label. - Answers -
Solver appears in the Data tab of the Ribbon.
A worksheet contains data for businesses that are sponsoring this year's Arts Festival.
The worksheet contains these columns in this sequence: Business Name, Address,
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now