Excel Exercises 11-15

 

Exercise 11 Excel

  1. Open Exercise 11 markup
  2. Copy the information to your desktop temporarily under Your nameEx5-10
  3. How many companies do you have on record?
  4. Calculate the average purchases for 2001.
  5. How many companies have purchased from you in 2001?
  6. What was the smallest amount purchased in 2001, not including zero purchases?
  7. What was the highest amount purchased in 2001?
  8. What is the average markup of 2001?
  9. What is the average margin for 2001?
  10. Send your answers to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 012

     

Exercise 12 Excel

  1. Split the column city and state into two columns, one for city and one for state using the "text to columns wizard " under data.

  2. Send your answers to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 012

Exercise 13 Excel

  1. Using "CONCATENATE" join the two columns "address" and "suite"
  2. Send your answers to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 13
     

Exercise 14 Excel

  1. Sort now this table by city and produce a new work sheet name it "delivery" with only company name, address and phone

  2. Send your answers to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 14

 

Exercise 15 Excel

  1. Count column Suite for blank

  2. Count column city for "TAMPA"

  3. Send your answers to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 15

 

 

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)