Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Customers can rate their service representative by completing a four-question survey at the end of each call. Tiana entered the scores in columns Question

image text in transcribed
2. Customers can rate their service representative by completing a four-question survey at the end of each call. Tiana entered the scores in columns Question 1, Question 2, Question 3, and Question 4 of the Calls table. She wants to calculate the average rating for each call in the Average column. In cell J5, enter a formula using the AVERAGE function and structured references to average the values in the Question 1 to Question 4 columns of the Calls table. Fill the formula into the range 36:3143, if necessary. 3. In the range L4:N13, Thana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell MS, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting. 4. Tiana also wants to average the combined scores for each employee. in cell N5, enter a formula using the AVERAGEIF function and structured references to the Service Rep and Average columns in the Calls table to average the scores Barry (cell L.5) recelved for all the calls he handled. Fill the formula into the range N6:N13 without formatting. 5. Go to the Call Type by Rep worksheet. Tiana wants to compare the call data by type for each service rep. In cell A3, insert a PivotTable based on the Calls table. Use RepCalls

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions