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

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

Image
  Hello, in this blog I will be documenting my progress on creating a customer database. Furthermore, I have used MS Excel to create it. Adding to that, MS Excel is famous for creating wonderful and organised databases and having all the needed tools to create it. My Progress: 1- I started by writing the title of the database. All I had to do is click on one of the cells and start typing. 2- I changed the colour of the text to red.   To do that I clicked on 'Home'. Then I went to the 'Font' section. After that I clicked on the letter 'A' that says font colour when you place the arrow of your mouse on top of it. 3- I then wrote the headers of each category. I also made the text bolder. 4-After that I started inserting all the information that was needed. 5- Finally, I added borders around it to make it look better. And that is the final look.
Read more

What is an ERD. Define the RED related terms, including entities, attributes, cardinalities and relationships

Image
Entity-Relationship Diagram (ERD): An ERD is a diagram that allows you to notice the entities and how they interconnect with each other. An ERD also has specific shapes, symbols, and arrows to describe the diagram. They are used to understand how a database system is going to be  structured. RED related terms: -Entities: They are considered as objects that can store data about it. In other words, they represent nouns. Also, they are placed into a rectangular on the ERD. There are also weak entities and strong entities. -Attributes: They are used to explain an entity. They can be described using an oval shape in an ERD. In addition, there are multiple types of attributes, such as simple, composite, and derived.  Attributes can involve single values or multi values. -Relationships: They explains how two entities are related to each other. They can be considered a verbs to explain the relationship better. Furthermore, there a types of relationships, such as one to one, ...
Read more

Research what Alt Tags and Title Tags are in HTML, and discuss how they improve SEO for your e-commerce website

Image
  Alt tags: -  Traditionally Alt tag is used on a simple images. Furthermore, Alt tags is an attribute on an <img> or <Figure> tag .  It is also useful as it provides a text alternative for search engines  ( McCall et all,2022). Title tag: - A title tag is an HTML code. Furthermore, the title tag of a web page can be found as title that appears in the search engine result. In addition, the information that is included in a title tag can be seen as a header at the top of the screen. An alt title should be added to every web page. However, the title tag should represent the content of the web page. How Alt tags and title tags improve SEO: - First of all, title tags are necessary as they affect the user experience. Also, they are a perfect place to apply a keyword. Furthermore, placing a good keyword can boost your search ranking. For instance, it is better to keep the keyword short and use some title modifiers (Kinsella, 2021). - Alt tags are important as ...
Read more