All categories

3 years ago

Before protecting a worksheet to avoid people from editing the formulas, you must ________.

Business

1 answer:

mario62 [17]3 years ago

6 0

Answer:

Lock the Formulas Cells

Explanation:

Now, go to lock the selected cells with formulas. To do this, press Ctrl - 1 to open the Format Cells dialog again, switch to the Protection tab, and check the Locked checkbox. The locked option prevents the user from overwriting, deleting or changing the content of the cells.

You might be interested in

Use the information below to answer the following questions. Currency per U.S. $ Australia dollar 1.2377 6-months forward 1.2356

NikAS [45]

Answer:

Missing word "a. What must the six-month risk-free rate be in Japan"

a. Spot rate = 1 US $ = 1.2377 Aus.dollar

Forward rate = 1 US $ = 1.2356 Aus.dollar

1.2356 = (1 + i Ad)

1.2377 (1 + 0.05)

0.9983 * (1.05) = 1 + i.Ad

1.048215 = 1 + i.Ad

i.Ad = 1.048215 - 1

i.Ad = 0.048215

i.Ad = 4.82%

b. Spot rate = 1 US $ = 100.3300 Japan Yen

Forward rate = 1 US $ = 100.0500 Japan Yen

100.0500 = (1 + i Ad)

100.3300 (1 + 0.05)

0.9972 * (1.05) = 1 + i.Ad

1.04706 = 1 + i.Ad

i.Ad = 1.04706 - 1

i.Ad = 0.04706

i.Ad = 4.71%

4 0

2 years ago

King Nothing is evaluating a new 6-year project that will have annual sales of $410,000 and costs of $284,000. The project will

motikmotik

Answer:

Option (a) is correct.

Explanation:

Given that,

Sales = $410,000

Costs = $284,000

Depreciation Expense = $510,000 × 0.1920]

= $97,920

Therefore,

Operating Cash Flow:

= [(Sales - Variable Costs - Fixed Costs) × (1 - Tax Rate)] + [Depreciation × Tax Rate]

= [($410,000 - 284,000) × (1 - 0.35)] + [$97,920 × 0.35]

= [$126,000 × 0.65] + [$97,920 × 0.35]

= $81,900 + $34,272

= $1,16,172

7 0

3 years ago

Transactions for the Sheldon Cooper Company, which provides welding services, for the month of June are presented as follows.

dem82 [27]

Answer:

June 1 Sheldon Cooper invests $4,000 cash in exchange for shares of common stock in a small welding business.

Account Debited: Cash

Account Credited: Common Stock capital

2 Purchases equipment on account for $1,200.

Account Debited: Equipment

Account Credited: Accounts Payable

3 Pays $800 cash to landlord for June rent.

Account Debited: Rent expense

Account Credited: Cash account

12 Bills P. Leonard $300 after completing welding work done on account.

Account Debited: Accounts receivable

Account Credited: Service revenue

5 0

2 years ago

Cragmont has beginning equity of $277,000, net income of $63,000, withdrawals of $25,000 and no additional investments by owners

Andrew [12]

The ending equity is $315,000 This is just a matter of adding income and subtracting withdraws. So let's do it. "Cragmont has beginning equity of $277,000," x = $277000 "net income of $63,000" x = $277000 + $63000 = $340000 "withdrawals of $25,000" x = $340000 - $25000 = $315000

3 0

3 years ago

Sturdy Construction has been a successful, small, home-building firm for years. The owner pays subcontractors slightly more than

bazaltina [42]

In this case, the Sturdy Construction is engaging in an effective supply chain management.

<h3>What is supply chain management?</h3>

The management of Supply chain means the process of handling the flow of goods & services, right from the raw manufacturing process to the final production which facilitate its consumption by the consumer.

In conclusion, the the Sturdy Construction is engaging in an effective supply chain management.