Market Share Analysis at Aldon Industries
  1. Open the workbook called
  2. Use the Save As command to save the workbook as Aldon2.xls
  3. Study the Market Share worksheet and answer the question - do these ranges contain text , values or formulas?
    1. B13:G13
    2. C3:C10
    3. A3:A10
    4. G3:G10
  4. What is Aldon Industry's overall market share?
  5. Examine the worksheet to determine in which state Aldon Industries has the highest market share
  6. Which company leads the overall market?
  7. What is Aldon Industry's overall ranking in total market share?
  8. Which companies rank ahead of Aldon Industries in total market share?
  9. What formula was used to calculate Total Installations in Illinois? Develop an alternative formula to calculate Total Installations in Illinois without using the sum function.
  10. Save and print the worksheet