Which tools have the ability to change values in the original data set?

(TCO 6) Which What-If Analysis tool would be best at comparing the combined ef Show more Question 9.9. (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments? (Points : 2) Scenario Manager Goal Seek One-variable data table Two-variable data table Question 10.10. (TCO 6) After entering the substitution values and the reference to a formula the next step to complete a two-variable data table and view the results is to: (Points : 2) enter the cell references in the Column input cell box. enter the cell references in the Row input cell box. click the What-If Analysis command. drag to select the data table boundaries. Question 11.11. (TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2) What-If Analysis Data Validation Consolidate Advanced Question 12.12. (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? (Points : 2) Scenario Manager Goal Seek Data Table Solver Question 13.13. (TCO 6) Where is Solver located if it is already loaded onto Excel? (Points : 2) Add-Ins tab Formulas tab Analysis group on the Data tab Data Tools group on the Data tab Question 14.14. (TCO 6) Which tools have the ability to change values in the original data set? (Points : 2) Data Tables & Solver Data Tables & Scenario Manager Goal Seek & Scenario Manager Goal Seek & Solver Question 15.15. (TCO 6) The initial results of a Goal Seek are: (Points : 2) automatically entered into the worksheet. inserted into a new worksheet. presented visually in a chart. shown in the Goal Seek Status dialog box. Show less

QUICK QUOTE

Approximately 250 words