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.

Computer Science & Information Technology

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?

Computer Science & Information Technology

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).

Computer Science & Information Technology

A Calc spreadsheet contains a minimum of three sheets

Indicate whether the statement is true or false

Computer Science & Information Technology

?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

Computer Science & Information Technology