Background
Microsoft Excel is one of the most used computer programs. It is extremely efficient at storing numbers and doing calculations. You can also
use it to store text, images, as well as make charts and graphs. Some jobs that might use Excel on a regular basis include accountants, bankers, stockbrokers, and scientists.
Directions
You have $1,000 to plan your upcoming birthday party. You're going to invite 49 of your friends and family to the party. So, that means you will have a total of 50 people at the party. Before you have the party, you want to make sure that you can afford all of the supplies. To do that, you're going to make a spreadsheet so you can budget your money.
Party Requirements
To have a good party, you need enough food and drinks for all 50 guests. You also need something for them to do. Your budget needs to include:
- At least one main course for each person such as a hamburger, hot dog, chicken sandwich, veggie burger, or burrito.
- At least two side dishes for each person such as chips, macaroni and cheese, veggie tray, or potato salad.
- At least two 12 oz. drinks for each person such as soda, tea, water, or juice.
- At least one slice of birthday cake for each person.
- At least one disposable plate, one set of utensils (fork, knife, and spoon), one 12 oz. cup, and two napkins for each person.
- Enough tables and chairs for each person to have a seat available.
- At least one type of entertainment for your guests such as a DJ, dance floor, petting zoo, photo booth, bounce house, or dunk tank.
You can assume that you have items like a grill or trash cans.
Content Rubric
- Cell A1 is labeled "Item". [1 Point]
- Cell B1 is labeled "Number of Items". [1 Point]
- Cell C1 is labeled "Cost Per Item". [1 Point]
- Cell D1 is labeled "Total Item Cost". [1 Point]
- Cell E1 is labeled "Budget". [1 Point]
- Cell F1 is labeled "Total Party Cost". [1 Point]
- Cell G1 is labeled "Cost Per Person". [1 Point]
- *NEW* Cell E4 is labeled "Average Food Cost" [1 Point]
- *NEW* Cell F4 is labeled "Average Supply Cost" [1 Point]
- *NEW* Cell G4 is labeled "Average Entertainment Cost" [1 Point]
- Enter "$1000" in cell E2. [1 Points]
- Enter a FORMULA in cells C2 to C50 to calculate TOTAL ITEM COST. [5 Points]
- Enter a FORMULA in cells D2 to D50 to calculate TOTAL COST. [5 Points]
- Enter a FORMULA in cell F2 to find the total cost of your party. [5 Points]
- Enter a FORMULA in cell G2 to calculate the cost per person. [5 Points]
- *NEW* Enter a FORMULA in cell E5 to calculate the Average Food Cost. [5 Points]
- *NEW* Enter a FORMULA in cell F5 to calculate the Average Supply Cost. [5 Points]
- *NEW* Enter a FORMULA in cell G5 to calculate the Average Entertainment Cost. [5 Points]
- Make the text in cells A1, B1, C1, D1, E1, F1, G1 bold and underlined. [2 Points]
- Format all cells C2:C50 as CURRENCY. [2 Points]
- Format all cells D2:D50 as CURRENCY. [2 Points]
- *NEW* Format cells F2, G2, E5, F5, G5 as CURRENCY. [2 Points]
- Format all CURRENCY cells to have TWO DECIMAL PLACES [5 Points]
- *NEW* Conditional Formatting is applied to all TOTAL ITEM COSTS for food items only.
- Items that are GREATER THAN the AVERAGE FOOD COST should have a LIGHT RED FILL WITH DARK RED TEXT. [5 Pts.]
- Items that are LESS THAN the AVERAGE FOOD COST should have a GREEN FILL WITH DARK GREEN TEXT. [5 Pts.]
Content Rubric
File name is lastname_firstname_birthday_budget [25 Points]
Project is submitted before 11:59PM on 10/06/2017. [25 Points]
Project cannot be submitted after 4:30pm on 10/10/2017.
Tutorial Video
Please click here to access the tutorial video.
