MS Excel

 In this blog I will be talking about my progress in creating a product table for my website. I will also be talking about the formulas I have used to complete the table.


First, I used (*) to calculate the total cost. I multiplied the 'unit price' with the 'stock quantity'. To do it you need to put an '=' sign first. Then, choose the correct columns. Lastly, click enter and the equation will be solved.

The picture above shows the formula I have used.


After I wrote the formula I just clicked enter and it solved it for me. 


Instead of writing the formula in each column, you can place the arrow on the corner of the column. After that, the arrow will turn into a plus sign. Then, you drag mouse downwards and Excel will automatically solve the rest.



Lastly, this is what it looks like.


I used the same formula for the total sale.



The picture below is what my table looks like. I have also added charts to complete it.







Comments

Post a Comment

Popular posts from this blog

Invention of WWW and E-commerce

Image
  Invention of WWW and E-commerc e Tim Berners-Lee, 41, is the person who invented the World Wide Web. Which means he is the creator of WWW. Tim Berners-Lee has stated that he developed some software to keep track of his “memory” since he said he is neither good at names nor faces. So he created it as a “memory substitute”. For this reason, technology has advanced increasingly. He is the reason that we can look at a photo online and click on it to find out the photographer’s name. ( Wright, R., 1997) Michael Aldrich is the person who created e-commerce. Moreover, 1995 was the year when e-commerce started growing. Furthermore, the internet and the web were the main factors that helped e-commerce grow ( Laudon and Traver., 2013).  Even though e-commerce has become more popular over the last decade, it has been around for over 30 years. Furthermore, the  idea of e-commerce is associated with notions of the internet economy and digital economy. In addition, all these concepts...
Read more

Analyse and compare different examples of product pages

Image
Introduction: In this blog I will be analysing and comparing different product pages from websites. I have also chosen websites that sell clothes since I am creating a similar website.    White Fox boutique: This product page is quite simple. Both the description and image are available and in good quality. And the description is short and simple. Also, you can easily navigate your way through the pages. Furthermore, this website has different categories. In addition, you can see the prices of the products and the different colours that are available. Overall, this is a good product page and very straightforward. ZARA: Although Zara's homepage appears attractive, many people complained that shopping and browsing the website were difficult. First of all, the size of the description is small. Furthermore, it can be a bit challenging to find what you are looking for. Also, it seems to appear that they are cramming several product images in one row. On the other hand, the colours ...
Read more

Essentials features of an e-commerce website

Image
                    What features should I use for my website?                  _______________________________________________________ The sources that I have used to write this blog all agreed that there are some points that developers must do in order to get a number of satisfied customers. For instance , many e-commerce website creators spend an amount of time in these unnecessary and irrelevant features. These include, use of frames , consistency , cohesion , and amount of advertisement   ( Udo, G.J. and Marquis, G.P., 2002.   42 (2), pp.10-16.) .  These four elements might not satisfy customers and have a rather negative affect on your website.  On the other hand, according to   Udo, Godwin J., and Gerald P. Marquis   focusing your attention on the download time can have a noticeable increase in your ranking. It can also be considered the most beneficial an...
Read more