A worksheet,created by a company making toothbrushes,contains the following information within specified cells (given in brackets): Number of toothbrushes sold (K10),Sale price * number of toothbrushes sold (K11),Transportation cost per toothbrush * number of toothbrushes sold (K12),the fixed cost (K13)involved in manufacturing the toothbrushes,and the net profit (K14).If the company wants to find the number of toothbrushes they have to sell to make a profit of $5,000,what must they enter in the "For set" field in the Goal Seek Dialog box?
A)$5,000
B)K14
C)K10
D)K13

Question

Quizplus · Accepted Answer

The "Set cell" refers to the cell where the required input is the objective (a profit of $5,000).This cell corresponds to K14.

A Worksheet,created by a Company Making Toothbrushes,contains the Following Information