Define the term what-if analysis. How could you use a spreadsheet in capacity planning?
What will be an ideal response?
What-if analysis allows you to vary one or more elements in a capacity planning model to measure the effect on the other elements. Capacity planning is a process that monitors current activity and performance levels, anticipates future activity, and forecasts the resources needed to provide the desired level of service.A spreadsheet is an extremely useful tool in capacity planning because it allows the analyze the overall effect when one or more variables are changed.
You might also like to view...
A Timer’s __________ property must be set to True before the Timer will generate events.
a) TimerEnabled b) EventsEnabled c) Events d) Enabled
To modify an existing formula in a table, from the shortcut menu select:
A) Edit Formula. B) Update Formula. C) Update Field. D) Edit Field.
A vector is similar to an array in that it stores elements that can be accessed using an integer index that starts at ___________________.
Fill in the blank(s) with the appropriate word(s).
Which of the following is a request for specific data from a database?
A. query B. formula C. resample D. function