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:
- Customer ID
- Full name
- Phone number
- Address
I created a product table that contained :
- Product ID
- Product name
- Unit price
- Selling price
- Total Cost
- Total sale
- 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
Post a Comment