Answer :
Answer:
=([Cost] * 1.07)
Explanation:
The question has missing details.
The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax
Assume that the table heading for estimated cost in July 2014 is Cost
The formula to calculated the total cost which includes the sales tax is:
=([Cost] * 1.07)
The above uses structured reference to make reference to the cost in July 2014.
To calculate the total which includes sales tax, we use:
[tex]Total = Cost * (1 + Sales\ Tax)[/tex]
[tex]Total = Cost * (1 + 7\%)[/tex]
Convert percentage to decimal
[tex]Total = Cost * (1 + 0.07)[/tex]
[tex]Total = Cost * 1.07[/tex]
Hence, the Excel equivalent is:
=([Cost] * 1.07)
Answer:
=([Cost] * 1.07)
Explanation:
The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax
Assume that the table heading for estimated cost in July 2014 is Cost
The formula to calculated the total cost which includes the sales tax is:
=([Cost] * 1.07)
The above uses structured reference to make reference to the cost in July 2014.
To calculate the total which includes sales tax, we use:
Total = Cost x ( 1 + Sales Tax )
Total = Cost x ( 1 + 7% )
Convert percentage to decimal
Total = cost x ( 1 + 0.07 )
Total = Cost x 1.07
Hence, the Excel equivalent is:
=([Cost] * 1.07)
Plz mark as brainlist..