Ask Question
15 May, 15:26

Construct a formula in cell D11 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C11 and the sales tax rate in cell C8 so that your formula can be reused for the remaining transations.

+4
Answers (1)
  1. 15 May, 16:24
    0
    Formulas! D11: = C11*0.0675

    4 / 7 (57.1%)

    Feedback:

    [-2] The formula in cell D11 does not reference the sales tax rate

    [-1] The tax rate reference is not absolute

    Copy the formula you used in cell D11 down to calculate the sales tax amount for the remaining transactions.

    1 / 1 (100.0%)

    Feedback:

    Construct a formula in cell E11 to calculate the total amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C11 and the sales tax amount in cell D11 so that you can reuse your formula to calculate the total for the remaining transactions.

    Formulas! E11: = SUM (C11:D11)

    6 / 6 (100.0%)

    Feedback:

    Copy the formula you used in cell E11 down to calculate the total for the remaining transactions.

    2 / 2 (100.0%)

    Feedback:

    Use the SUM function to calculate the "Grand Total" in for all transactions in cell E24.

    Formulas! E24: = SUM (E11:E23)

    4 / 4 (100.0%)
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Construct a formula in cell D11 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers