3B: MS Excel Functions
What is Microsoft Excel Functions?
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
This is the data that I encoded to my excel sheet and the tasks that I need to do are getting the line total, the total cost, the total items ordered, the most expensive item, and the most ordered item.
For me to get the line total, I need to multiply of each item to the quantity of it by using the formula =(column headings)*(row headings)
For the next task which is getting the total cost by adding all of the amounts in the line total. To get the sum of these, you just need to click the AutoSum on the home tab and let microsoft excel do the math for you.
In getting the total items ordered, use the formula =COUNT(<column headings and row headings>:<column headings and row headings>). Remember that the headings that your formula need are from the items you want to include in this section. In my case, I put =COUNT(B2:B11)
To get the cost of the most expensive item, use the formula =MAX(<cells that you want to find the largest number from>).
For the last task which is getting the most ordered item, it will base on the quantity of each item sold. Use the formula =MAX(<cells that you want to find the largest number from>)
After doing this activity, I realized that learning these formulas can help me to do this kind of activity easier and consume less of my time.