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
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
1
Answer:
- The formula in cells C2 is C2 = B2 * 0.08 and cell D2 is D2 = B2 - C2
- 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