Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Get quick and reliable solutions to your questions from a community of experienced experts on our platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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)

Sagot :

MrRoyal

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..

Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. Get the answers you need at Westonci.ca. Stay informed by returning for our latest expert advice.