ICAn Save
You are given ₱200.00 as your allowance for today. Think of how you are going to spend your money. You can only buy from one store selling the following items:
₱ 50.00
₱ 35.00
₱ 65.00
₱ 40.00
₱ 25.00
₱ 30.00
₱ 25.00
-
Open a new blank worksheet in Excel.
-
Enter the items you have bought from the store and the prices
-
Compute for the amount paid using formulas.
-
Compute for the total amount of everything you have bought and the amount you saved for the day.
-
Monetary values should have ₱.
-
Save your work with filename Ican Save Section CN.
The number of rows vary depending on the items you have bought.
Rubric
Entering Text 4
Number format (Currency) 5
Cell Format (borders and font) 3
Formula 8
Total 20