All categories

2 years ago

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Business

1 answer:

shutvik [7]2 years ago

4 0

Answer:

Accounting.

Explanation:

In Microsoft Excel, to align currency symbols and decimal points in a column of numbers, you can apply the accounting number format.

When an individual (accountants or financial experts) wishes to display numbers as a monetary value, he or she is required to format the numbers as currency. The procedure for achieving this, is to apply an accounting number format to the required or necessary cells to be formatted.

In order to access the number formatting options, users should navigate to the Home tab which is found in the Number group on the Microsoft excel software application.

Also, worthy of mention is the fact that the accounting number format can be used to display negative numbers in parentheses and zeros as dashes.

You might be interested in

A well-known industrial firm has issued $1,000 bonds that carry a 4% coupon interest rate paid semiannually. The bonds mature 20

Flauer [41]

Answer:

5.59%

Explanation:

$1,000 bonds carrying a 4% coupon rate, semiannual coupon $20, matures in 20 years

if you purchase the bonds at $715, the nominal annual rate of return = coupon payments / bond price = ($20 + $20) / $715 = $40 / $715 = 5.59%

The nominal annual rate of return is calculated by dividing the revenue generated by an investment by the cost of the investment.

8 0

1 year ago

A small firm intends to increase the capacity of a bottleneck operation by adding a new machine. Two alternatives, A and B, have

Korolek [52]

Answer:

a. Alternative A Break-even point is 8,000 units Alternative B Break-even point is 7,500 units

b. Same profit with both alternatives at 10,000 units

c. Alternative A would have higher profit with a demmand of 12,000 units

Explanation:

a. FC/CMGu=BP

being:

FC= fixed costs

CMGu=contribution margin per unit

BP= Break even point

CMGu is the difference between price of sale and variable cost (per unit)

Alt. A Break-even point is $40,000/$5=8,000 UNITS

Alt. B Break-even point is $30,000/$4=7,500 UNITS

b. At 10,000 units both alternatives have the same profit

Alt. a.

Revenues= $150,000

Variable cost= $-100,000

Fixes Costs= $-40,000

------------------------------------

profit $10,000

Alt. b.

Revenues= $150,000

Variable cost= $-110,000

Fixes Costs= $-30,000

------------------------------------

profit $10,000

c. sales for 12,000 units

Alt. a.

Revenues= $180,000

Variable cost= $-120,000

Fixes Costs= $-40,000

------------------------------------

profit $20,000

Alt. b.

Revenues= $180,000

Variable cost= $-132,000

Fixes Costs= $-30,000

------------------------------------

profit $18,000

7 0

1 year ago

Read 2 more answers

Faux Trees Company produces artificial Christmas trees. A local shopping mall recently made a special order offer; the shopping

Arlecino [84]

Answer: $‭16,925.9‬0 increase

Explanation:

Company already has the excess capacity to handle this order so the fixed costs will not be included as they would have already been incurred.

Cost of manufacturing the trees would be:

= Variable cost + Fixed cost

= ((51.61 + 3.80 + 1.00 + 8.26 for white tree) * 230 trees) + 5,000 for molds

= (64.67 * 230) + 5,000

= $‭19,874.1‬0

Incremental revenue = 230 trees * 160

= $36,800

Incremental operating income = 36,800 - ‭19,874.1‬

= $‭16,925.9‬0 increase

Note: Options might be for a variant of this question.

7 0

2 years ago

A rug manufacturer has decided to use 7 compatible colors in her rugs. however, in weaving a rug, only 5 spindles can be used. i

zubka84 [21]

The number of available colors is n = 7.
The number of colors that can be selected at a time among the 7 colors is r = 5.

This means that the number of selections of 5 colors from 7 colors at a time is ₇C₅.
By definition,
$_{7} C_{5} = \frac{7!}{2!5!} = \frac{7.6.5!}{2.1.5!} = \frac{7.6}{2}=21$

Answer: The number of color groupings is 21.

3 0

2 years ago

Read 2 more answers

A depositor at a credit union is called a _____.

Alexandra [31]

The depositor at a credit union is called a customer

7 0

2 years ago

Read 2 more answers