Answered

Westonci.ca is your go-to source for answers, with a community ready to provide accurate and timely information. Experience the convenience of finding accurate answers to your questions from knowledgeable 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..

We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Get the answers you need at Westonci.ca. Stay informed by returning for our latest expert advice.