plz shows the ddetail of this exercise

Note: plz do not use pivottable in Q2. thanks

.      Introduction 
BeInformed is a social networking consulting company in Melbourne that plans, implements, and tracks social networking campaigns to help small business owners create a strong presence on the Internet. Your friend, Sally Lim regularly creates reports about the response rates for the social networking campaigns. Given the data file, she would like you to use Excel functions and features, especially pivot tables to help her analyse her data. Below are some of the features/task descriptions that she would like from her data file. 


.      1. A separate worksheet with the headers from the given data file (i.e. Name, Type, Description, Month and Responses) to allow Sally to selectively view the data, e.g. only Facebook campaigns; only Facebook and Twitter campaigns; data from January only, data from January and February and so on. She would also like to be able to sort her data, e.g. sort her client data in alphabetically order. 


2.                Sally would like to know the total number of responses from each type of social media by month, e.g. what was the total number of responses of the Facebook campaigns in January? 


3.                Sally wants to know which campaigns had the lowest responses. Create another worksheet that displays the 15 campaigns with the lowest Responses where each row represents a campaign. She would like you to show the lowest Responses first (i.e. first row on the worksheet). 


4.                Sally wants to view her data in charts so that she can quickly identify any trends from her data. Create a pivot table and a chart (she is not fussy about the type of chart) to show the campaign responses by month, i.e. for each month, what were the responses for Facebook, Twitter and Pinterest? Comments on the results. 


5.                She also heard about that slicers can be used to filter the data in pivot tables. Create slicers for Sally to:

.                             a)  View Responses by Type (of social media) 


.                             b)  View Responses by Type and Month 


Attachments:

• 1509527823-Introduction .docx
• 1509527830-Sales.xlsx