When you have many input assumptions that will vary in each scenario, it is sometimes easier to identify the cells in the input section that will not change in the scenarios, thereby determining the scenarios' changing cells through a process of elimination.
Correct Answer:
Verified
Q3: To set up a scenario, you create
Q4: In a one-variable data table, you enter
Q5: In a two-variable data table, you use
Q6: What-if analysis allows you to see what
Q7: A one-variable data table allows only one
Q9: Cells that contain formulas should be specified
Q10: There is no right answer to the
Q11: A data table depends on values and
Q12: Technically, the number of scenarios you can
Q13: Because a PivotTable is interactive, you can
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents