2. A closer estimate of the total cost can be made by including the estimated sales tax. Use a formula to calculate the estimated cost for July 2014 using 7% sales tax. Then, write the formula you used and the estimated cost in the cell below. Hint: Convert 7% into a decimal for the formula. (5 points)
Answers
i hope it's helpful to u..❤
plz Mark me brainlist
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:
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..