Case 6-2 TemplateINSTRUCTIONS: Read the case in the textbook. As a team answer t

Case 6-2 TemplateINSTRUCTIONS: Read the case in the textbook. As a team answer the questions in this spreadsheet then save and submit the assignment as one Microsoft Excel attachment. Also submit a 1-paragraph MicrosoftWord document explaining any issues or successes you had in answering these questions.Refer to and use the following abbreviations for the problems below: PS = Public Subscribers AD = Advertisers TC = Telephone Customers ISP = Internet Customers TOT = Total Customers1. What percentage of the total does each of the four customer groups represent? Round to the nearest hundredth of a percent.