Answered step by step
Verified Expert Solution
Link Copied!

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

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.
7. Go to the Website worksheet. Use the text in the range A5:A6 to fill the range A7:A16 with the week numbers.
8. Malai has set a goal of 400 page views per week on the Orange Tree Labs website. In the range B21:E21, project the page views per week by filling the series with a linear trend. She also wants to increase follows by 10 percent every four weeks. In the range B23:E23, project the follows based on a growth series using 1.10 as the step value.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Networking is a two-way street. Discuss this statement.

Answered: 1 week ago