Ask Question
20 March, 12:06

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.

+3
Answers (1)
  1. 20 March, 15:57
    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?
Get 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 & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers