Question

Suppose you are a manager of a cafeteria. Create a worksheet using excel maintaining the
monthly expenses of the cafeteria under various heads, for a year. Your assignment should
contain the following:
i. Make an account of purchases of fruits and vegetables
ii. You must find average expense per month
iii. Automatically find the month when a minimum amount was spent
iv. Create a chart for head wise expenditure per month
v. Use formulas to find sum and average

Answer 1

Answer:

ii. You must find average expense per month

Answer 2

Suppose you are a manager of a cafeteria. Create a worksheet using excel maintaining the monthly expenses of the cafeteria under various heads, for a year.