List the guidelines for planning and performing a what-if analysis.
What will be an ideal response?
1. Understand and state the purpose of the worksheet model.
2. Determine the data input value(s) that, if changed, affect the dependent cell results.
3. Identify the dependent cell(s), usually containing formulas, that will contain adjusted results once different data values are entered.
4. Formulate questions you want the what-if analysis to answer.
5. Perform the what-if analysis and explore the exact relationships between the input values and the dependent cell formulas.
You might also like to view...
Write a program to determine the size of a disk device or partition using only read(2) and lseek(2). Hint: aread of a disk device at end-of-?le returns 0, while a read past end-of-?le will usually fail
What will be an ideal response?
The ____________________ icon indicates that a linked file was modified after it was placed into InDesign.
Fill in the blank(s) with the appropriate word(s).
A Calc spreadsheet contains a minimum of three sheets
Indicate whether the statement is true or false
?In the context of in-house software development options, the choice between developing versus purchasing software often is called a _____ decision.
A. ?build or make B. ?subscription C. ?transactional D. ?build or buy