# What effect does the comma style format have on the selected cells in excel?

Answer: It causes the cells to display with two decimal points and commas as thousands separators.

## Related Questions

What ordered pair is closest to a local minimum of the function, f(x)? (–1, –3)

(0, –2)

(1, 4)

(2, 1)

(2,1)

Explanation

a point is a local minim if it has the smallest y coordinate in that interval and the graph goes from decreasing to increasing.

D.    for Edge.....

Coy, Inc. initially issued 200,000 shares of \$1 par stock for \$1,000,000 in 2016. In 2017, the company repurchased 20,000 shares for \$200,000. In 2018, 10,000 of the repurchased shares were resold for \$160,000. In its balance sheet dated December 31, 2018, Coy, Inc.'s treasury stock account shows a balance of: Multiple Choice \$200,000. \$40,000. \$100,000. \$0.

\$100,000

Explanation:

The issue of original shares are at premium of \$4 per share.

As \$1 + \$4 = \$5 200,000 = \$1,000,000

When 20,000 shares were repurchased, there price would be \$200,000/20,000 = \$10 per share.

Now from this 10,000 shares are sold for \$160,000, at a price of \$160,000/10,000 = \$16 per share

Balance in treasury account will be \$200,000 - \$10,000 \$10 = \$100,000

The extra amount received of \$6 = \$16 - \$10 is paid in capital and shall not reduce the balance of treasury account.

Suppose the price of a substitute to lcd televisions rises. What effect will this have on the market equilibrium for lcd​ tvs? The equilibrium price of lcd tvs will a. Increase and the equilibrium quantity will increase.
b. Not change and the equilibrium quantity will not change.
c. Decrease and the equilibrium quantity will increase.
d. Increase and the equilibrium quantity will decrease.
e. Decrease and the equilibrium quantity will decrease.

Answer: The equilibrium price of lcd tvs will

a. Increase and the equilibrium quantity will increase.

When the price of a substitute of lcd tvs rise, the demand for lcd tvs will rise, since they become cheaper than the substitute.

This will cause the existing demand curve to shift outwards, resulting in a rise in quantity.

As a result of the outward shift, the quantity supplied will also rise and so will the equilibrium price.

Bob has saved \$285 each month for the last 6 years to make a down payment on a house. The account earned an interest rate of .37 percent per month. How much money is in Bob's account?

\$26000

Explanation:

Bob deposit \$285 into a bank account earning 0.39% simple interest per month.

The interest on this money for the 6 year period will first be obtained and then added to the total amount Bob deposited during this period.

Bob deposited a total of 285×72=\$20500 (72 is obtained by converting 6 years to months i.e. 6×12)

The interest during this period =p×r×t

Where p=\$285 (amount Bob saves per month)

r=.39/100 or 0.039 intrest rate earned per month

t=6 years or 72 months

Interes accred for 6 years= 285×0.039×72=\$80

Total amount Bob will have at the end of 6 years =80+20520=\$26000

You ran a little short on your spring break vacation, so you put \$1,000 on your credit card. you can only afford to make the minimum payment of \$20 per month. the interest rate on the credit card is 1.5 percent per month. how long will you need to pay off the\$1,000? how much interest will you pay?

Use the PV of an Annuity tables, where PV is \$1,000, Annuity is \$20, and Rate is 1.5%. But remember that the equation for this table is PV = Annuity x Factor. Since we know the PV and the Annuity, solve for the Factor.

PV / Annuity = Factor, so \$1,000 / \$20 = 50 (the Factor). From the table, find where a Factor of 50 meets a rate of 1.5%. A factor of 49.9724 appears at 1.5% and 93 Periods.

The formula for the PV of an Annuity is (1 - 1 / (1 + r)^n) / r. So 1,000 = (1 - 1 /(1.015)^n / .015.
To solve for n gets too difficult

Henry is Brad's softball coach and is training him for the upcoming playoffs. One day during practice, Brad is unable to focus and plays poorly. Henry tells Brad, "Let's stop for the day. I think this weather is making you sick." In the context of understanding individual behavior, Henry has made a(n) _____ about Brad's poor play. a.interpersonal attribution

Explanation:

Henry is Brad's softball coach and is training him for the upcoming playoffs. One day during practice, Brad is unable to focus and plays poorly. Henry tells Brad, "Let's stop for the day. I think this weather is making you sick." In the context of understanding individual behavior, Henry has made an external attribution about Brad's poor play.

Suppose the U.S. Treasury issued \$50 billion of short-term securities and sold them to the public. Other things held constant, wh would be the most likely effect on short-term securities' prices and interest rates? A. There is no reason to expect a change in either prices or interest rates. B. Prices and interest rates would both decline. C. Prices and interest rates would both rise. D. Prices would decline and interest rates would rise. E. Prices would rise and interest rates would decline.

D. Prices would decline and interest rates would rise.

Explanation:

since the U.S. Treasury issued \$50 billion of short-term securities and sold them to the public the will be a lot of supply and the demand will be low.

As a results of that orice will decrease and hence to kepp hold of that the price will decrease and the intreset rates would rise.

Complex Systems has an outstanding issue of ​\$1,000​-par-value bonds with a 15​% coupon interest rate. The issue pays interest annually and has 14 years remaining to its maturity date. a. If bonds of similar risk are currently earning a rate of return of 14​%, how much should the Complex Systems bond sell for​ today?

b. Describe the two possible reasons why the rate on​ similar-risk bonds is below the coupon interest rate on the Complex Systems bond.

c. If the required return were at 15​% instead of 14​%, what would the current value of Complex​ Systems' bond​ be? Contrast this finding with your findings in part a and discuss.

So the Bond must sell for \$1,156.47

Explanation:

FV  -1000

PMT (Payment Per Period)  -120

N  16

Rate  10.00%

PV  \$1,156.47

So the Bond must sell for \$1,156.47

Reasons could be reduced expected inflation than when Complex issued the bonds, or possibly strong demand for bonds due an improved economy.

It he required return were 12%, the bonds would sell at par, or at 1,000.

What three smart goals should you always have in place and be committed to when doing inbound?