Mt. Eden Computer Essentials & Applications I Classes

Google Sheets logoGoogle Sheets ASSIGNMENT 1...

 

Complete the following exercises:

1. CREATE A BUDGET

OfficePartyYour boss asks you to help organize the next office party. She gives you a budget of $250. You decide to create a Google Sheets spreadsheet 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 an Add Function 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 your Add Function 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 your Add Function to add up that column so that it will help you figure out costs for each item that will add up to $200.

 

WHEN YOU ARE DONE...

TURN IN THE COMPLETED FILE THROUGH GOOGLE CLASSROOM.

 

 

This assignment is worth 25 points.