I have been asked by my college to submit a project on excel. Being a student of nutrition I don't have much knowledge in MS Excel, only the basics! So please help me out with this project as I don't have any clue about it & how to do it! The description of d project & the guidelines are as follow:
"Suppose you are a manager of a Cafe House. Create a worksheet using excel maintaining the monthly expenses of the Cafe house under various heads, for a year. your assignment should contain:
1. Formulas that automatically calculate.
2. You must find the Avg. expenses per month.
3. Automatically find the month when the min. amount was spent.
4. Create a chart for head wise expenditure per month."