Which what-if analysis tool is the best option for complex calculations requiring constrained optimization? (a) Goal Seek (b) Scenario Manager (c) Data Tables (d) Solver What tool is used to view existing range names? (a) Name Box (b) Scenario Manager (c) Name Manager (d) Solver Which tool is most effective when comparing the impact of various combinations of production expenses and new customer acquisition on net sales profit? (a) Goal Seek (b) Solver (c) Two-variable data table (d) Scenario Manager This tool calculates the value required in a single cell to produce a result within a related cell. (a) Goal Seek (b) Solver (c) One- or two-variable data table (d) Scenario Manager This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals. (a) Goal Seek (b) Solver (c) One- or two-variable data table (d) Scenario Manager Which of the following is an Excel add-in? (a) Goal Seek (b) Solver (c) One- or two-variable data table (d) Scenario Manager Which of the following is not an acceptable range name? (a) Apr (b) Rate_2021 (c) 2021_Rate (d) Payment What is the keyboard shortcut to open the Paste Name dialog box? (a) F2 (b) F3 (c) F4 (d) F5