Learning task 1: Activity Drill 1
ns,
fic
of
MS Excel
Finding the result in a problem solving is very interesting and maybe some of
you might agree some are not. But whether we like it or not it is part of our daily lives
because mathematics is everywhere. But have you tried to count a bulk number of
items or getting the total grocery expenses you bought? If your answer is YES then
Congratulations, but if your answer is NO, then Join us and try to experience it.
* 33/
Here is the Activity, I want you to go to your room and clean all your stuff then
have an inventory of it or if you are not in your home maybe try to figure out or recall
those things that you have in your room. For example your stuff (shoes, clothes, toys,
gadgets, beds or whatever stuff you have on your room with a price) then list all of
that as the same as the sample table below.
Description of Items
Quantity
Hem
No.
1.
2.
3.
4.
5.
Android Phone RealMe &pro
Shoes
T-shirts
Short
Books
Grand Total
1
4
10
10
15
Estimated Total Price
Price
17,990 17,990
700.00 2800.00
250.00 2500.00
150.00 1500.00
200.00 3000.00
27,790.00
From the collected data create a chart that will show a graphical
representation of your Inventory. You can use pie graph or bar graph.
Apply the appropriate formulas you have learned.​