Project: 1 Due on: 08/31/2016 11:59PM
Total points: 10
Mode of submission: Online through your blackboard account. No email submissions will be accepted.
Assignment 3 Description: You work for Miss Lexi’s Baked Goods which sell Cookie Baskets. You are given the price and quantity sold for each item as follows
Cookie
Baskets |
Product |
Price ($) |
Quantity Sold |
Almond Crunches |
15.95 |
559 |
Cinnamon Sleds |
15.95 |
1,026 |
Coconut Snowmen |
19.95 |
1,598 |
Molasses Chews |
19.95 |
2,287 |
Raspberry Bells |
21.95 |
787 |
Gingerbread Men |
21.95 |
1,065 |
Chocolate Delights |
25.95 |
1,076 |
You are asked to create a sales summary worksheet in excel 2013. All calculations involved in the worksheet preparation must be completed using appropriate formulae. Your finished worksheet should contain the name of the business in the top in large font, additional column for cost of each item, and total cost in the bottom of the cost column.
Strictly follow the below mentioned naming convention.
Name your excel worksheet as follows
- Lastname Firstname Project 1.xlsx
Use the following instruction for submission
Step 1: Go to the assignment submission section
Step 2: click on “Browse My Computer” button then select and attach the excel file from your computer.
Step 3: Click “Submit” button.