A newly formed company producing glass paperweights creates a worksheet using Excel for finding the number of units it has to sell to post a profit of $10,000 in the first year.In the Goal Seek tool dialog box,where must the required profit be entered?
A)In the "For set" field.
B)In the "To value" field.
C)In the "Time" field.
D)In the "By changing cell" field.

Question

Quizplus · Accepted Answer

In the Goal Seek dialog box,the "To value" refers to the value of the objective we want to achieve.In this case,the objective is posting a profit of $10,000.

A Newly Formed Company Producing Glass Paperweights Creates a Worksheet