Answer:
B) =COUNT(A2:A101)
Explanation:
The COUNT function in excel with count the <em>contents</em> of all selected cells in the range (it counts what is <u>in the cells themselves</u>, not the number of cells). The range is expressed as starting cell, a colon, and the ending cell.
=COUNT(Starting cell#<u>:</u>Ending Cell)
Answer:
$ 1,781.53
Explanation:
The future value of the 5-year CD can be determined by using the future value formula stated below:
FV=PV*(1+r)^n
FV is the future value which is expected future amount after 5 years
PV is the initial amount used in purchasing the CD i.e $1500
r is the rate of return on the CD on an annual basis which is 3.5%
n is the number of years the investment would last which is 5 years
FV=$1500*(1+3.5%)^5
FV=$1500*1.187686306
FV=$ 1,781.53
Answer:
True
Explanation:
In a perfectly competitive market, all producers sell identical goods or services. Additionally, there are many buyers and sellers. Because of these two characteristics, both buyers and sellers in perfectly competitive markets are price takers. Market price is set by the forces of demand and supply.
If the seller attempts to set his own price and sets it above the market price, the seller would lose all its customers and make zero sales.
If the seller attempts to set his own price and sets it below the market price, the seller would make losses .
I hope my answer helps you.
Answer:
$5,860
Explanation:
Computation for their tax savings from the preferential rate
First step is to calculate their tax liability
Using this formula
Tax liability =[Tax amount on $169,300 ordinary income-(Tax Amount on $120,300 ordinary income +Tax amount on $49,000 preferential income)]
Let plug in the formula
Tax Savings=[$35,648-($22,438+$7,350)]
Tax Savings=$35,648-$29,788
Tax Savings=$5,860
Therefore their tax savings from the preferential rate is $5,860
I would say that Dan should learn how to type with a keyboard instead of by hand as I know that with practice one can learn to type quite fast and with a keyboard one doesn't need to worry about writing neatly or legibly since all the letters and numbers are pre-determined and always the same.