Join Curt Frye for an in-depth discussion in this video Creating check boxes, part of Learning Excel What-If Analysis.
…Worksheet models let you combine a series of inputs into a coherent picture.…Some inputs are numbers, such as computer prices.…While others are costs that might or might not apply.…For example, you could choose whether to include a product category in an order.…In this movie, I'll show you how to turn…individual items on and off by using check boxes.…I'm going to work in the check boxes sample…file, which you can find in the chapter three folder…of your exercise files archive. This worksheet has a series…of elements to it. The first are the costs for given product…categories at given quantities, so, for example, 250 servers at $1500 each…with an 18.1% discount would cost just over $307,000.…
And the same for desktops, notebooks and tablets.…The other financial terms are the number…of years and the interest rate, and then I've…calculated my monthly payment, base price and total cost.…The discount scroll bar value is linked to the slider here.…That's currently positioned on row ten.…So if I click the left and right arrows, I can increase or decrease the discount.…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.