Question: 4 . In the range A 1 3 :E 1 6 , Malai wants to include data about the types of posts the company makes
In the range A:E 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 SupportEXEOMPosts.csv as a table starting in cell A of the existing worksheet. Mac Hint: Use column delimation while importing the csv file.
Apply the Orange, Table Style Light 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 A:A Resize columns B:E to a width of characters.
In the range A:F Malai wants to summarize the weekly engagement data for the Orange Tree Labs website, Facebook, and Twitter interactions.
In cell B enter a formula using the SUM function and a D reference to total the number of page views in Week cell B for the website, Facebook, and Twitter. Fill the range B:B with the formula in cell B to consolidate the total page view data for the remaining weeks. Fill the range C:F with the formulas in the range B:B to consolidate the data for likes, comments, shares, and follows.Online Engagement Overview
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
