Question: You need to analyze the data with Microsoft Excel software for several sub tasks below: 1.1 Count the number of Product Family for PF12 (using

You need to analyze the data with Microsoft Excel software for several sub tasks below: 1.1 Count the number of Product Family for PF12 (using COUNTIF formula). 1.2 Display the name of the customer who most frequently complained (using INDEX formula with other possible formulas). 1.3 List all complaint types raised by the customer identified in the task 1.2 (using VLOOKUP formula with other possible formulas).

have doubt related in 1.3

This is are just upto 10 only there is much data upto cell 720

Complaint ID Date Initiated Response Date Customer Name Department Complaint Type Product Family Raised By Referred To ActionedBy Date Completed Effectiveness Time Closed By
CC5116
29/05/2015 5/06/2015 C1 Warehouse Wrong Product PF7 P4 EMAIL12 45 18/06/2015 Not Given P9
CC5115
29/05/2015 5/06/2015 C2 Warehouse Delivery PF3 P5 EMAIL11 48 18/06/2015 Not Given P5
CC5114
29/05/2015 5/06/2015 C3 Warehouse Wrong Product PF1 P4 EMAIL13 38 18/06/2015 Not Given P10
CC5113
29/05/2015 5/06/2015 C4 Warehouse Damaged PF13 P5 EMAIL18 38 18/06/2015 Not Given P9
CC5112
28/05/2015 4/06/2015 C5 Warehouse Delivery PF10 P3 EMAIL27 46 17/06/2015 Not Given P9
CC5111
28/05/2015 4/06/2015 C6 Warehouse Delivery PF2 P5 EMAIL16 38 17/06/2015 Not Given P8
CC5110
28/05/2015 4/06/2015 C7 Warehouse Wrong Quantity PF11 P1 EMAIL14 31 17/06/2015 Not Given P1
CC5109
27/05/2015 3/06/2015 C3 Warehouse Poor Response PF1 P3 EMAIL28 48 16/06/2015 Not Given P8
CC5108
26/05/2015 2/06/2015 C8 Warehouse Wrong Quantity PF1 P6 EMAIL16 31 15/06/2015 Not Given P4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Requirements Task 1- Analysis You need to analyze the data with Microsoft Exce. software fo several su Las: s below: 1.I count the number of Product Family for PF12 (using COUNTIF formula). 1.2...

Q:

5-407-753 MARK JEFFERY Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Rob Griffin, senior vice president and U.S. director of search for Media Contacts, a...

Q:

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

Q:

MGMT 2100 - Assignment #1: Spreadsheet Skills General Instructions: For this assignment you will complete a tutorial introduction to some important features of Microsoft Excel, and then search for...

Q:

2) For each of the following groups, discuss whether each was better-off or worse-off after the launch of Napster and why: 1) Consumers; 2) Super-star artists; 3) Unknown artists; 4) One of the big...

Q:

What is the working capital, current ratio, and quick ratio of Intuit? Please use the attached annual report. Frequently, management will comment on liquidity in the MD&A (management's discussion and...

Q:

I am attaching all of the questions. These are basically small questions which are required to be answered as per the exact requirements. These are all related to finance. No irrelevant details are...

Q:

Steps Case 1: Scenario: Cloud Data Services (CDS), headquartered in Memphis, provides information technology services, specifically application hosting services in the cloud for several clients in...

Q:

Sam Project for Advanced functions and conditional formatting Excel 2013 I am having trouble with questions 14-19. Assignment do tomorrow Computer Software 178 New Perspectives Excel 2013 Tutorial 8:...

Q:

Can someone help me correct these two things for my project? (1) Residential Service Revenue: Revenue is recognized on a monthly basis ($18 per month). Therefore if the contract starts from 2/1/2015,...

Q:

Repeat Problem 17.18 assuming that the volatility of gold is 20% and that once opened, the mine can be costlessly shut down forever. What is the value of the mine? What is the price at which the mine...

Q:

a. Do a bar chart: lunch, dinner, and delivery sales by day (interpret). B. Do line chart: lunch, dinner, and delivery sales by date of the month (interpret). Restaurant Sales Date 1-Apr 2-Apr 4-Apr...

Q:

Cullumber Corporation's comparative balance sheet is presented below. \ table [ [ CULLUMBER CORPORATION Balance Sheet December 3 1 ] , [ Assets , 2 0 2 4 , 2 0 2 3 ] , [ Cash , $ 1 5 , 4 4 0 , $ 1 1...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

2. What role does culture and leadership play in the success of Kiwi Experience?

Q:

2. Compare the sales and service departments at Auto World.

Q:

3. How do Dr. Beckett and her staff educate patients about the service they are receiving? What else could they do?