Case-Based Critical Thinking Questions
Case 2-2

Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure.
-Nevia has told you that the desired value is 325. In which text box should she insert the desired value?
A) #1
B) #2
C) #3
D) none of the above

Question

Case-Based Critical Thinking Questions
Case 2-2
  
Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure.
-Nevia has told you that the desired value is 325. In which text box should she insert the desired value?
A) #1 
B) #2 
C) #3 
D) none of the above

Quizplus · Accepted Answer

Nevia should insert the desired value, 325, in the "Set cell" text box (#2). This is because Goal Seek is used to determine the input value necessary to achieve a desired output in a specific cell (the "set cell"). In this case, Nevia is trying to determine what input value (in the "By changing cell" text box, #1) is necessary to achieve an output of 325 in the set cell (#2). The "To value" text box (#3) is not applicable in this scenario.