Excel SUM Calculation Exercises

Download the latest Stationary calculation exercise file. Furnish all the empty columns & rows in the sheet.



Hints:
  1. To calculate the total price, you may use the formula =Price per unit * No. of Units.
  2. To get CGST @12%, you can use the formula =12%*Total Price
  3. To get SGST @12%, you can use the formula =12%*Total Price
  4. To get Gross Amount, you can use the formula =Total Price+CGST+SGST
  5. The sale price should be Profit% of Gross Amount i.e., you can use the formula =Profit %*Gross Amount
  6. To get Profit Amounts, you have to Subtract Sale Price with Gross Amount.

Practice File: DOWNLOAD HERE