Excel Project help!

Copper Contributor

Hello everyone,

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."


Thank you in advance!

4 Replies
Please attach your sample file with the inputs and your desired outputs.

No sir my college didn't provide me any sample data, file or anything like that except only this!@Twifoo 

You need to do your own homework.