(BIS 155 Week 6)
BIS 155 Week 6 Excel Project Memo: Sales Data Analysis and Recommendations
BIS-155 Week 6 Lab Exercise: Income Statement & Sales Analysis
BIS-155 Week 6 Discussion Answer: What-If Analysis
Life is full of questions and each question deserves a good answer. Let’s explore the What-If Analysis tools available in Excel. Explain how these tools are used to assist with solid decision making. Give examples of how each of the What-If Analysis tools can be used practically. Please include your research references in APA format.
BIS 155 Week 6 What-If Analysis – Quiz
- Question (TCO 6) Which of the following tools is an add-in?
- Question (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?
- Question (TCO 6) In a data table, the _____ number format is used to disguise the formula references in thefirst row as labels.
- Question (TCO 6) A series of ______ indicates that which of a column is too narrow to display the complete number
- Question (TCO 6) In order to complete a two variable data table, which of the following must … included in the table?
- Question (TCO 6) In the goal seek dialog box, the cell reference of the desired value is entered in the _____ box.
- Question (TCO 6) Where is scenario manager … in excel
- Question (TCO 6) To optimize the monthly payments, you would designate the home cost, down payment, APR, and number of years for the loan as the ______ variable cells.
- Question (TCO 6) Which is the best for determining the optimal blend of products to produce in order to maximize profit?
- Question (TCO 6) Which What-if analysis tool is the best tool for evaluating the various scenarios based on variable within a formula?
- Question (TCO 6) Which What-if analysis tool is the best tool for manipulating one variable to determine one result?
- Question (TCO 6) How can you determine id the Solver add-in is active?
- Question (TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT
- Question (TCO 6) The Goal Seek command is … in the _____ command on the Data tab.
- Question (TCO 6) The value you want to achieve in Goal Seek needs to … entered in the _____ box in the GoalSeek dialog box.