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
Answer :
Word Count : 264
__________ _________ ____ _____ ___ _________ __________ ______ ___ _________.
______ ___ _________ ____ _______ ____ _______ _____ ______.
_____ ________ __________ _________ __________ ______ ____ _____ _____ _________ _________.
___ _______ ________ __________ __________ __________ __________ _________ __________.
_____ __________ _____ _________ ________ ________ _______ ____ ______ _____ _________ ________.
_______ ___ ______ ______ ______ __________ _____ _________ __________ _____ ________ _________.
_________ __________ ______ _______ _________ _____ ____ _____ ___ _______.
___ _______ _____ ________ ______ ___ _____ ________ ___.
_______ _____ ____ ________ ______.
_____ ___ ________ ___ __________ __________ ________.
____ ______ ___ _____ ____.
____ _______ ______ ____ _________ _________ ________ ___.
________ _____ _____ _________ __________ ____ _____ ________ __________ ______ __________.
_______ ___ ______ ______ _________ ______ __________ __________.
____ ______ ________ ________ ________ _______ _________ _________ ____ ___ ___ ________.
______ _____ ___ _______ _____ _________ ____ _______ ______ _______.
_______ _________ _________ _________ _________.
___ _____ ___ ___ ______ _____ ______ ________ ____ ________ __________ ____.
__________.
Skip in 10
-
Open Excel:
- Launch Microsoft Excel on your computer.
-
Data Entry:
- Create a table with the following columns: Month, Food Expenses, Staff Salaries, Utilities, Supplies, Miscellaneous.
-
Data Entry:
- In the "Month" column, enter the months of the year (January to December).
-
Expense Data Entry:
- In the respective columns, enter the monthly expenses under each head for the entire year.
-
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
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.