Excel Exercises 1-5

Exercise 1 Excel

1. Welcome to the Boot Camp
2. Please visit my web site and register- Thank you http://w3.fiu.edu/gk/formregistration.htm
3. Go to START -  All Programs - Find Microsoft Excel and open it up.
4. Now, open Ex01 "Stores" by clicking on it
5. Copy it to the excel version of your desktop
6. Once you have copied it to your desktop - save it Your Name Exercise 1
7. Rename sheet 1 to Ex01Stores
8. Using table 1 "Stores" calculate for each WEEK the
   1. sum,
   2. average,
   3. minimum value,
   4. maximum value, and
   5. count  and save your work on your local drive
9. Using the saved work of table 1 "Stores" calculate for each STORE the
   1. sum,
   2. average,
   3. minimum value,
   4. maximum value, and
   5. Count 

6. Using the saved work of table 1 "Stores" insert Week 3 with the following information

8. Using the saved work of table 1 "Stores" insert Store 3 with the following information

9. Recalculate sum, average, min, max, and count for each week and store
10. Go to the bottom of the spreadsheet and right click on sheet 1
11. Rename sheet 1 to “Store Sales”
12. Format the numbers in Store Sales to include a dollar sign $
13. Format the numbers to 2 decimal places
14. Format the numbers with the comma style
15. Center all your data
16. Week 1 – 5 should be in RED, BOLD LETTERS
17. Store 1-5 should be in YELLOW FILL COLOR
18. All SUM figures should be underlined
19. All count results should be in italics
20. The AVERAGE results of Week 1-5 should be in Gray 25% Fill
21. The MAX results of Week 1-5 should be in Rose Fill
22. All fonts should be ARIEL and size 12
23. Once you have finished and saved it for the last time on your desktop - send it to me by attachment to my email with a cc to yourself.
24. Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 01

Exercise 2 Excel

1. Open EX 0203 There are two exercises - Exercise 02 and exercise 03 
2. Complete Exercise 02 - Car Payments

4. Using the Excel formula =-PMT  calculate the monthly payments JAG, BMW, VW, & BOXSTER
5. Save your work on the desk top under Yournameex0203 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 0203

Exercise 3 Excel

1. Open  EX 0203 There are two exercises - Exercise 02 and exercise 03 
2. Complete exercise 03
3. Rename it Ex03Mortgage - House payments

4. Calculate a down payment of 15%, interest rate of 7.5% p.a. and a 30 year period
5. Save your work on the desk top under Yournameex0203 and  email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 0203

Exercise 4 Excel

1. Open a new sheet in Yournameex04
2. Rename this new sheet Ex04Pie
3. Using the following information
4. Highlight A1:B8
5. Click on Chart wizard
6. Choose Pie
7. Choose Exploded pie with a 3D visual
8. Chart title should be "Populations"
9. Choose Legend in the corner
10. Choose Data Labels – Category name and %
11. Finish
12. Change the color of China to RED
13. Tidy up the fonts, the legend, the title 
14. Save your work on the desk top under Yournameex04 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 04
15. There is a catch here; Where is it?

Exercise 5 Excel

1. Open “Exercise 5 Share prices”
2. Copy it to a new sheet in Yournameex05
3. Rename this new sheet Ex05 Line graph prices
4. Use the information for IBM and HP share prices to draw a line graph
5. Highlight the area with the relevant information
6. Hit the chart wizard
7. Choose a line graph 
8. Expand the graph area
9. Change the color of the two lines to Green and Blue
10. Change the fonts on the X axis to 8
11. Change the font on the Y axis to 10
12. Change the font size to 10 in the legend
13. Title the graph “Stock price November”
14. Save your work
15. Save your work on the desk top under Yournameex05 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 05

Home  | Log in  |  Syllabus | Excel I Exercises | Excel II Exercises | Excel III Exercises | Excel IV Exercises | PowerPoint Exercises I |    Laptop and PC maintenance  Exercises I |  Exercises II  | Exercises III (Speed Test your connection)