Mt. Eden Computer Essentials & Applications I Classes

Excel ASSIGNMENT 1...

Complete the following exercises:

1. CREATE A BUDGET

Your boss asks you to help organize the next office party. She gives you a budget of $250. You decide to create an Excel worksheet that tracks the party’s budget.

 

List the flowing categories in the first column:

• Food
• Music
• Decorations
• Gift

In the second column list your budgeted cost of each item. At the bottom of that column set-up AutoSum to automatically add up the column so that as you enter your cost for each item they accumulate there, and that will help you figure out amounts that add up to $250.

2. CALCULATE TOTAL COSTS

After looking at the your figures for the office party, your boss asks you to use these figures instead:

• Food = $85
• Music = $150
• Decorations = $25
• Gift = $40

So then in the third column of your worksheet list your boss's costs for each item. Use AutoSum to add up that column.

3. CREATE AN ALTERNATIVE BUDGET

Later your boss asks you to revise the budget once again: this time down to add up to $200.

In a forth column reduce your budgeted cost of each item so that they add up to $200. Use AutoSum to add up that column so that it will help you figure out costs for each item that will add up to $200.

 

TO GET CREDIT, you must type YOUR NAME and PERIOD NUMBER in the cells of your worksheet.

• Put your name in Cell B8.
• Put your period number in Cell B9

WHEN YOU ARE DONE...

TURN IN THE COMPLETED FILE THROUGH GOOGLE CLASSROOM.

This assignment is worth 25 points.