## In Week 2, student exercise 1, in order to use Goal Seek you will need to indicate the “changing cell”, which cell should be identified?

6. Question 6 In Week 2, student exercise 1, in order to use Goal Seek you will need to indicate the “changing cell”, which cell should be identified? 1 point…

## Your client wants to understand the profitability of a project but many of the variables are not known and vary independently. What approach would allow the user to test the likelihood of the project being profitable at many combinations of variables?

3. Question 3 Your client wants to understand the profitability of a project but many of the variables are not known and vary independently. What approach would allow the user…

## Your client wants to know what the Net Present Value (NPV) would be of a particular capital project as interest rates move from 1% to 15%. What would be the most appropriate approach?

2. Question 2 Your client wants to know what the Net Present Value (NPV) would be of a particular capital project as interest rates move from 1% to 15%. What…

## In Week 2, student exercise 3. We are using a one-way data table to determine the impact of changing cost per hour. If we instead were asked to determine the impact of changing Revenue per Purchase, what other information would we need?

8. Question 8 In Week 2, student exercise 3. We are using a one-way data table to determine the impact of changing cost per hour. If we instead were asked…

## In Week 2, student exercise 2, for the scenario “Low growth with margin impact”, what would you indicate as the revenue growth rate?

7. Question 7 In Week 2, student exercise 2, for the scenario “Low growth with margin impact”, what would you indicate as the revenue growth rate? 1 point   3.5%…

## As part of your analysis you want to be able to answer “what if” questions by starting, first, with the outcome of the analysis. What is the best tool to use?

5. Question 5 As part of your analysis you want to be able to answer “what if” questions by starting, first, with the outcome of the analysis. What is the…

## You need to mathematically optimize outcomes in your model given specific constraints. What is the best tool to use?

4. Question 4 You need to mathematically optimize outcomes in your model given specific constraints. What is the best tool to use? 1 point   Solver   Goal Seek  …

## Imagine you have an Excel file that contains 5 separate data tables. What Excel features will allow you to create a Pivot Table that includes data from all 5 of the separate data tables?

6. Question 6 Imagine you have an Excel file that contains 5 separate data tables. What Excel features will allow you to create a Pivot Table that includes data from…

## Which of the following statements DOES NOT apply to Relational databases?

4. Question 4 Which of the following statements DOES NOT apply to Relational databases? 1 / 1 point   Relational databases have data stored in different data sets   Relational databases might be…

## Which of the following is the BEST guiding principle to avoid too much hard-coding?

2. Question 2 Which of the following is the BEST guiding principle to avoid too much hard-coding? 1 point     Create a storyboard     Use shortcuts     Use…