Question

8. Set cell: is an input associated with which tool ?


(a) Scenario Manager
(b) Goal Seek
(c) Data Table
(d) None of these​

Answer 1

Answer:

goal seek in ms Excel

Explanation:

when we need to set a cell with the target number by the changing of some others cell value it is used in goal seek

Answer 2

Set cell is an input associated with (b) Goal Seek

Explanation:

Set cell is the value of cell [D5] is now "Fred. You can use this command to alter or set the value of another cell in the template.

Scenario Manager:It is an excel-based what-if analysis tool. It allows you to investigate how a change in values affects the sheet's outcomes. Scenario Manager, Goal Seek in Excel, and Data Table in Excel are the three components of What-If analysis.

Goal Seek:The word "goal seeking" refers to the act of determining your input value based on a previously determined output value. The method entails the use of a certain operator in a formula that may be calculated with computer software.

Data table:To display detailed information from a source, use data tables. Data tables, like lists, display data in rows and columns. Each column displays all of the values for a database data item or a calculation based on database data items.