Question

Dilip’s mother creates grocery list every month. Dilip asked his mother to give him the list of grocery items that she buys for a month. He used worksheets in Excel with items in one column and quantity in another column and their prices in the next column. Now he can very easily calculate the amount spent on each item and the total monthly bill. Ask you mother for grocery list of the month and help her by creating and printing the worksheet in Excel

Answer 1

Explanation:

This is a practical work. You have to do it on your own. This task is very easy as all you have to do is take any of the monthly bill from that of your monthly grocery shopping from whichever supermarket you do such as big bazaar, Spencer, Reliance fresh or any other local store. Make a worksheet as stated. You will get average monthly expenditure.