Computer Science, asked by 1239ssap2020shauryas, 3 months ago

Aman wants to calculate an 8% discount on the item price and then the net amount as given in the worksheet
i. What should be the formulas in cells C2 and D2?
ii. How will you copy the formula in cell C2 to C3:C5 and in cell D2 to D3:D5?

Attachments:

Answers

Answered by speerappagol
2

Answer:

i. C2 = B2 * 0.08

  D2 = B2 - C2

ii. First calculate the C2 and hold the selection and drag  to cell C5 and release. The results will be copied to cell C5. Do the same procedure for D2 also

Explanation:

Answered by sujan3006sl
1

Answer:

  1. The formula in cells C2 is  C2 = B2 * 0.08 and cell D2 is D2 = B2 - C2
  2. Calculate C2 first, then hold the selection and drag to cell C5 before releasing it. Cell C5 will get the results. Follow the same steps for D2.

Explanation:

Since it is given in the question that:

  • the percentage of discount is 8%

                                            ⇒ that is 8/100

                                            ⇒ 0.08

               Hence, Discount amount = item price * 0.08

                                                     C2 = B2 * 0.08

  • Hence, to the formula in cell C2 to C3:C5 and in cell D2 to D3:D5, Calculate C2 first, then hold the selection and drag to cell C5 before releasing it. Cell C5 will get the results. Follow the same steps for D2.

#SPJ2

Similar questions