Question

A. Instructions: Create an Excel file for the expenses below. Using the
formulas and functions discussed calculate the following using MS Excel:
1. = SUM (total cost of ingredients used)
2. = COUNT (total number of materials used)
Marketing
Budget
Expenses
Allowance 700.00
Item Bought Quantity Cost/Unit Total
Chicken 1 ½ kg 150/ kg
Tilapia 1 kg 140/ kg
Assorted Vegetables ½ kg 120/kg
Garlic ¼ kg 80/kg
Eggs 1/2 6.50.00/each
Total
Expenses
Balance
Expenses
(Allowance minus
Total Expenses

Answer 1

Answer:

ok

Explanation: