Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5 . Apply the Orange, Table Style Light 1 1 style to the table to use a format similar to the other data ranges on
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.
Go to the Website worksheet. Use the text in the range A:A to fill the range A:A with the week numbers.
Malai has set a goal of page views per week on the Orange Tree Labs website. In the range B:E project the page views per week by filling the series with a linear trend. She also wants to increase follows by percent every four weeks. In the range B:E project the follows based on a growth series using as the step value.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started