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…
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…
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…
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…
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%…
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…
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 …
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…
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…
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…
