| Assignment #1- QB Stats |
| Assignment #2- The Weather |
| Assignment #3- Nutrional Facts |
| Assignment #4- Car Dealership |
Directions for Assignment #4:
1. Take the handout given and type in the figures where they belong on the spreadsheet
2. Find Sales Totals (Add amounts for the three months)
3. Find the Sales points (Sales total / 100,000; make sure this number is not a dollar amount)
4. Find Total Points (Service Points + Sales Points)
5. Who is the winner?
1. Take the handout given and type in the figures where they belong on the spreadsheet
2. Find Sales Totals (Add amounts for the three months)
3. Find the Sales points (Sales total / 100,000; make sure this number is not a dollar amount)
4. Find Total Points (Service Points + Sales Points)
5. Who is the winner?
| Assignment #5- Stock Price |
Directions for Assignment #5:
1. Use the handout to type in the correct prices next to the dates
2. Create a Line Chart showing the price going up and down over the month (go to the "Insert" ribbon)
3. Find the High, Low, & Average (these are all under the "Auto Sum" button)
4. Lastly, find the Capital Gain for the month if 50 shares were bought at the beginning of the month and sold on the last day of the month. (Please ask if you need help)
Your equation should look like this: (Price sold - Price paid) * 50
1. Use the handout to type in the correct prices next to the dates
2. Create a Line Chart showing the price going up and down over the month (go to the "Insert" ribbon)
3. Find the High, Low, & Average (these are all under the "Auto Sum" button)
4. Lastly, find the Capital Gain for the month if 50 shares were bought at the beginning of the month and sold on the last day of the month. (Please ask if you need help)
Your equation should look like this: (Price sold - Price paid) * 50
| Assignment #6- Checkbook |
| Practice for Quiz |
