part 1 Continue Excel Projects
Assignment Instructions:
1. Do textbook Projects 9 and 10 (save as one file) pages E77 to E78 *Use formulas (review prior formulas and video lessons)
2. Attach and Submit Project 10 when done
3. make sure your name is in the worksheet and as part of the filename
(*to help with this project you can review a similar example from the Built-in function exercise video link in week 5)
part 2 Price after Discount Project
Directions:
1. Textbook page E78 Project 11 (*use formulas that make sense)
2. Attach and submit Project 11 (include your name in worksheet and as part of the filename)
3. Make sure you have the correct formula to find the Price after the discount (think about the formula carefully) You can do this in one step (or two if you like)
**Hint: If
you are buying a shirt in a store that is 20% off, what will you be
paying? First take the % off the shirt then deduct (subtract the
original shirt price minus the discount found).
you are buying a shirt in a store that is 20% off, what will you be
paying? First take the % off the shirt then deduct (subtract the
original shirt price minus the discount found).
Example: original
price of shirt=$40. The sale is 20% off the original
price. We multiply 20% times $40, which is $8. However, you pay now
$32 for the shirt after the discount. Why do we pay $32 for the shirt?
Think about the calculation here
price of shirt=$40. The sale is 20% off the original
price. We multiply 20% times $40, which is $8. However, you pay now
$32 for the shirt after the discount. Why do we pay $32 for the shirt?
Think about the calculation here
part 3 Charting exercise
Assignment Directions:
1. Watch the Charting Basics video.
2. Create the Sports Company Worksheet along with the column chart that is presented in the video.
3. Attach the Excel file (Sports Company) when done and submit with your name in the spreadsheet.
4. For review please work on pgs. E49-E59 (do not submit these practice pages)