Make an expenditure plan for July month using Excel.total pocket money will be rs .500 (1) total expenditure made by the person in july.display it in B15(2)Total Savings for July
Answers
"Excel helps us in or daily calculations and to record things in a systematic way. Excel is generally used in the organization or by the students for their project or housewife to keep the expenses and income intact as it serves multipurpose for everything by using the function key or sum and total.
1. You can have multiple sheets in one work book, rather than having so many files.
2. It consists of 1 million rows and that is much more sufficient to work for a huge data base.
3. The data can be enhanced by using formatting options like font, size, colour, border, calculation, etc.
Usage of formatting also helps in underlining the important things.
For example I have a pocket money of Rs. 500/-
My Expenditure for the month is: Travelling to and fro to the market: 20* 8 days (average ) = Rs.160/-
Recharge my mobile: Rs. 199/-
Other Expenses: 100
Total Expenses: =Sum(160+199+100)
= Rs.459/-
Total Saving for month of July = 500- Rs.459 = Rs.41/-"
Made an expenditure plan for july month using Excel.total pocket money will be Rs.500. calculate the total expenditure made by a person in july.display it in B1...