Question

A. Open an Excel workbook and do the following :-

1. Type the data in the cell as shown in the figure

2. Enter the formula in the cell D2 under the Amount column. Using fill handle option enter the formula in cell D3,D4 & D5

3. Type the formula in cell D6 to calculate the total amount .

4. Apply fill colour effect to the cells as shown in the figure​

Answer 1

here is your answer

hope it helps you

Answer 2

Answer:

here is your answer

I hope it helps you