Question

You are the manager of a canteen. Create a worksheet using excel maintaining the
monthly expenses of the canteen under various heads, for a year. Your assignment
should contain:
Formulas that automatically calculate
You must find the average expenses per month
Automatically find the month when the minimum amount was spent
Create a chart for head wise expenditure per month

31 Aug 2017
Answer :
Word Count : 264
  1. Open Excel:

    • Launch Microsoft Excel on your computer.
  2. Data Entry:

    • Create a table with the following columns: Month, Food Expenses, Staff Salaries, Utilities, Supplies, Miscellaneous.
  3. Data Entry:

    • In the "Month" column, enter the months of the year (January to December).
  4. Expense Data Entry:

    • In the respective columns, enter the monthly expenses under each head for the entire year.
  5. Calculations:

    • Average Expenses per Month:

      • In a cell below the last row of each expense column, use the AVERAGE
__________ _________ ____ _____ ___ _________ __________ ______ ___ _________.
______ ___ _________ ____ _______ ____ _______ _____ ______.
_____ ________ __________ _________ __________ ______ ____ _____ _____ _________ _________.
___ _______ ________ __________ __________ __________ __________ _________ __________.
_____ __________ _____ _________ ________ ________ _______ ____ ______ _____ _________ ________.
_______ ___ ______ ______ ______ __________ _____ _________ __________ _____ ________ _________.
_________ __________ ______ _______ _________ _____ ____ _____ ___ _______.
___ _______ _____ ________ ______ ___ _____ ________ ___.
_______ _____ ____ ________ ______.
_____ ___ ________ ___ __________ __________ ________.
____ ______ ___ _____ ____.
____ _______ ______ ____ _________ _________ ________ ___.
________ _____ _____ _________ __________ ____ _____ ________ __________ ______ __________.
_______ ___ ______ ______ _________ ______ __________ __________.
____ ______ ________ ________ ________ _______ _________ _________ ____ ___ ___ ________.
______ _____ ___ _______ _____ _________ ____ _______ ______ _______.
_______ _________ _________ _________ _________.
___ _____ ___ ___ ______ _____ ______ ________ ____ ________ __________ ____.
__________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MFN 8 2017 2018 - You are the manager of a canteen. Create a worksheet using excel maint | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→