1. Open the NP_EX_5-4.xlsx workbook located in the Excel5 > Case1 folder included with your Data Files. Save the workbook as NP_EX_5_Medicina in the location specified by your instructor. 2. In the Documentation sheet, in the range B3:B4, enter your name and the date. 3. The January through June worksheets contain the monthly social media logs. In each worksheet, change the entries in column C to hyperlinks by double-clicking each cell, and then pressing ENTER. (Note that you cannot make this change in a worksheet group.) Excel will automatically convert the cells to hyperlinks using the addresses stored into the cells. (Note that these fictional web addresses will not open real pages if clicked.) 4. One important social media metric is the number of engagements for each post where an indi-vidual is actively engaged in the post by retweeting the post, liking the post, mentioning the post in other forums, or clicking links within the post. In column I of the January through June worksheets, use the SUM function to calculate the total number of retweets, likes, mentions, and clicks. Do not include the number of followers in the total. 5. Another important social media metric is the Engagement Rate, which is the percentage of fol-lowers that are actively engaged with the post. In column J of the January through June work-sheets, calculate the Engagement Rate by dividing the number of engagements by the number of followers for each post. 6. In the Metric worksheet, calculate the following summary statistics: a. In cell C5, use the COUNT function to count the number of data values in column B of the January worksheet. b. In cell D5, use the SUM function to sum the total retweets in column D of the January worksheet. c. In cell D6, use the AVERAGE function to calculate the average number of retweets in column D of the January worksheet. d. Use AutoFill to copy the formulas from the range D5:D6 over the range D5:H6. e. In cell I5, use the AVERAGE function to calculate the average Engagement Rate from column J of the January worksheet. 7. Repeat Step 6 for February through June rows in the table to calculate summary statistics of the media metrics for each month. 8. Calculate summary statistics of the media metrics across all months by doing the following: a. In cell C19, use the COUNT function applied to column B of the January:June worksheet group to calculate the total number of posts made over the six month period. b. In cell D19, use the SUM function to sum up the total retweets in column D of January through June worksheets. c. In cell D20, use the AVERAGE function to average the number of retweets from column D of the January through June worksheets.