In the scenario manager, I'm going to select the first one, the term length. So, instead of writing them down like this, I'm going to cancel out of here, close this, and use the pro tip to give each of these cells meaningful names so we know which is which. But as it is right now, it's kind of hard for me to differentiate between these inputs because H 13 doesn't really mean anything to me unless I actually go and look for it. And here is where we enter the values for each of the inputs. So in this case, the down payment and the interest rate And if we press Control, we can select the term length as well. And our changing cells are going to be our inputs. You can give it whichever name you want, but this is going to help us identify them. So that's the down payment, 5% interest rate, and 30-year term length. So our first one is going to be the one we have right now. So we're going to go to the What If Analysis Scenario Manager, and from here we can add a new scenario. So what we're going to do now is use the scenario manager to evaluate the monthly payment that we get for each of these options and see which one we choose. But we were actually given three more options. So right now we have a 20% down payment, a 5% interest rate, and a 30-year term length. Now, when we went to ask for this loan, this actually wasn't the only payment option that we were given. We're back in the MortgageCalculator tab of our course project workbook in Excel. Now let's jump to Excel and replicate this example. ![]() In the example above, you can see in the Scenario value screen that the input cells have the names percent, down interest rate, and term length, which facilitates filling them out. So quick tip: give your input cells meaningful names to create scenarios that are easy to interpret and manage. So in this example, you can see that we have different combinations of downpayments, interest rates, and term lengths that result in different monthly payment amounts. When adding one, you'll specify which cells are the inputs, and then you'll assign a value for each.Īnd finally, you can alternate between showing the values for each scenario in your input cells and then evaluating the outputs for each. So when you open the scenario manager, you'll see the following window where you can add a series of scenarios. Because of its nature, the scenario manager is commonly used for modelling exercises where you fix a combination of inputs in order to evaluate and compare their calculated outputs. ![]() And you can access it from the datatab in the What If analysis dropdown. The scenario manager allows you to save and access specific combinations of cell values. The Scenario Manager is the first of Excel's Data Analysis Tools. PrepAway's ETE files povide the MO-201 Microsoft Excel Expert (Excel and Excel 2019) practice test questions and answers & exam dumps, study guide and training courses help you study and pass hassle-free! Advanced Formulas & Macros 28. All Microsoft Excel Expert MO-201 certification exam dumps, study guide, training courses are Prepared by industry experts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |