Jul 20 2021 11:09 AM
Jul 21 2021 03:42 AMSolution
1) All your currency values are text values, not numbers. You should remove the Rs. from the cells, and set the number format to a currency format that uses Rs.
2) A data table will only work if you have formulas. Without formulas, Excel has no way of knowing what you want to calculate.
In E6, enter the formula =E4*E5. This causes Excel to calculate the total price based on the price per apple and the quantity.
In F8, enter the formula =E6. This makes the top right cell of the data table equal to the total price in E6.
See the attached version.