Suppose you are a manager of a cafeteria. Create a worksheet using exc

Question

Suppose you are a manager of a cafeteria. Create a worksheet using excel maintaining the monthly expenses of the cafeteria under various heads, for a year. Your assignment should contain the following:

i. Make an account of purchases of fruits and vegetables

ii. You must find average expense per month

iii. Automatically find the month when a minimum amount was spent

iv. Create a chart for head wise expenditure per month

v. Use formulas to find sum and average

24 Nov 2020

Answer :

Word Count : 582

Creating a worksheet in Excel to maintain monthly expenses for a cafeteria involves several steps. I'll guide you through each of these steps to help you complete your assignment.

Step 1: Setting up the Excel Worksheet

1. Open Excel and create a new worksheet.
2. In the first row, create column headers for the following categories:
- A1: Month
- B1: Purchases of Fruits (in USD)
- C1: Purchases of Vegetables (in USD)
- D1: Total Expenses (in USD)
3. In cell A2, enter the first month (e.g., January). Then, fill in the months for the entire year in column A (A2 through A13 for a year).
4. Leave the cells in columns B, C, and D under each month empty for now.

Step 2: Enter Monthly Expenses for Fruits and Vegetables

Now, you'll __________ ___ _____ _______ _______ ______ ____ ________ ________.
_________ ______ _______ ___ _____ ________ _______ _______ ____.
_______ ________ ________ _______ __________ __________ ______ __________ _______ ______.
_______ ____ ___ ________ _____ _________ _______ _______ _____ _______.
___ ______ ____ ________ __________ ______ ______ ____.
______ ______ ____ ________ ___ _______ _________ _______ ____ ____.
______ _____ ____ _____ _________ ________ ____ _____ ___ ______ ___.
_________ ____ ________ _____ _____ _________ _______ __________ _____ _______.
__________ ______ ____ ___ ___ ___ _____ ________.
______ ____ _______ ______ ________ ____ _________ ________ ___ _______ _______.
______ ____ __________ _______ _________ _______.
________ ________ __________ __________ _______ _________ _______ ____ ___ ____ ________.
_____ ____ __________ _________ _______.
____ _________ _________ ___ _______ _______ ________ ____ _________ ___ ________ ______.
__________ ________ ______ _____ ________ __________ ___ ___ _______ _____ _____.
_______ ___ ______ _____ ________ _______ _____ _______.
________ __________ ________ ___ _____ _________ _______ _________ ____ ___ _____ ________.
_________ ___ _________ __________ ____ _______ __________ ______ ______ ______.
_______ __________ ____ _________ ______ ___ __________ ___ ______ ___ ___ _________.
________ ________ __________ ___ ________ ______ ____ ______.
_________ _______ __________ _______ ____ _______ _____ ___ ______ __________.
________ ___ _____ __________ ______ ____ ____ ___ __________ _____ ____ ____.
__________ _______ _______ _______ __________ _____ ___ __________ _________ ________.
_______ ______ __________ _______ ___ ___ ______ _____ ___ _______.
____ _____ _________ _________ _____ _____ _______.
___ ____ _________ _________ ____ _____ ________ ___ _______.
___ ________ _____ _____ ______ _________ ________ ____.
_______ ____ _______ ________ _________ _______ _______ ______.
____ ___ ___ ________ _______ ________.
_____ ___ ___ __________ ___ __________ ___ ______.
____ _________ ___ ___ _______ _______ ____ ___ ________ __________.
_____ ____ ___ ___ _____ ________ _________ _____.
____ ____ ________ _____ __________ ____ _______ ________ ______ ________ _________.
___ _______ ______ _____ _________ ________ ____.
________ ________ ___ ________ ___ _________ _______ _______ _______ __________ _________ _____.
______ _______ ______ _______ __________ ________.
___ __________ _________ _________ _________ _______.
__________ ________ ________ ______ ____.
________ ______ ________ ______ _____ _________ ___ ________.
_______ _______ __________ _________ ______ __________ ____ _____.
___ ________ _______ __________ ___ ________ __________ _____.
_________ ________ _____ ________ ________ _____.
______ _____ _________ _________ _________ __________ ______ ________ ___ ___ ________.
_____ __________ _______ __________ ___.
_________ ____ _________ ______ ________.
_______ ______ ____ ____ ________ _________ _______ ________.
________ ___ ____ __________ _________ _____ ___ _____ _______ ____ ________.
_______ _____ _________ _______ __________ _________ ____ _______ ____ _____.
_________ ______ ___ ________ ________ _____ ______ ___ _____.
________ __________ __________ ___.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★