Question: 4 . In the range A 1 3 :E 1 6 , Malai wants to include data about the types of posts the company makes

4. In the range A13:E16, Malai wants to include data about the types of posts the company makes on their website and social media webpages. This data is stored in a text file. Import the CSV file Support_EX365_2021_EOM5-2_Posts.csv as a table starting in cell A13 of the existing worksheet. [Mac Hint: Use column delimation while importing the .csv file.]
5. Apply the Orange, Table Style Light 11 style to the table to use a format similar to the other data ranges on the worksheet. Clear the formats from the header row and the range A14:A16. Resize columns B:E to a width of 11.88 characters.
6. In the range A19:F32, Malai wants to summarize the weekly engagement data for the Orange Tree Labs website, Facebook, and Twitter interactions.
In cell B20, enter a formula using the SUM function and a 3D reference to total the number of page views in Week 1(cell B5) for the website, Facebook, and Twitter. Fill the range B21:B31 with the formula in cell B20 to consolidate the total page view data for the remaining weeks. Fill the range C20:F31 with the formulas in the range B20:B31 to consolidate the data for likes, comments, shares, and follows.Online Engagement Overview
 4. In the range A13:E16, Malai wants to include data about

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!