Using MS Excel, create a customer database with at least 10 entries, with screenshots to document and show your progress

This is the database i made regarding my website.



Firstly I created a customer table that contained:
  1. Customer ID
  2. Full name
  3. Phone number 
  4. Address




I created a product table that contained :
  1. Product ID
  2. Product name
  3. Unit price
  4. Selling price
  5. Total Cost
  6. Total sale
  7. Profit
I then, did all the calculations and created the pie chart using the product table as shown.



 
These are all the formulas i used in my spreadsheet in order to calculate the values




Comments