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.


B. In the "To value" field.

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.

Business

You might also like to view...

Why would a company issuing credit cards use a code that is much larger than the minimum length?

A) to allow for expansion, since the customer growth may increase exponentially B) because the numbers are assigned sequentially and the codes should not use all possible numbers C) so that a person would not be able to guess a credit card number and illegally use it to purchase goods D) because the codes use the alphabetic derivation format E) since the codes are used to do inquiries on the data within them

Business

Find the current yield of a bond whose coupon rate is listed as 9.375% and currently selling at a premium of 100.875. (Round to the nearest tenth percent)

A) 9.3% B) 9.4% C) 10.0% D) 10.1%

Business

A company creates highly independent operating units in each new country when using the multidomestic strategy

Indicate whether the statement is true or false.

Business

Match the following terms to their correct definition.

A. Document that authorizes the creation of the corporation, setting forth its name and purpose and the names of the incorporators. B. If a corporation has only one class of stock, this is usually it. C. The sum of all preferred stock, common stock, and additional paid-in capital account balances D. Another term for articles of incorporation E. Provides that current dividends must be paid to preferred stockholders before any dividends are paid to common stockholders. F. Shareholders holding the shares on this date are the ones who receive any dividends that have been declared. G. Date on which the Board of Directors votes to pay a dividend. H. Cumulative preferred dividends that have not been paid. I. Represents the owners' claims against the assets of a corporation after all liabilities have been deducted. J. In a stock option plan, the price at which employees can buy the stock. K. Dividends that are paid out of contributed capital because retained earnings have been reduced to zero. L. Stock without a par value. M. Date on which shareholders receive dividends that have been declared. N. Individuals who hold this stock receive priority over common shareholders in the payment of dividends and the distribution of assets in the event of liquidation. O. Refers to a situation where an error resulted in a misstatement of net income and the correction requires a debit or credit to retained earnings. P. A performance measures that assesses the growth in equity from operating activities.

Business