Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can u please show me steps to do these. Malal Wattana is the director of social media for Orange Tree Labs, a software company in

can u please show me steps to do these. Malal Wattana is the director of social media for Orange Tree Labs, a software company in Cambridge, Massachusetts. Malai and her colleagues post content on the Orange Tree website and on social media sites to promote the company and its products. She asks for your help in analyzing the user response to this content. She also needs to complete a schedule for launching a website for a new product. Go to the Overview worksheet. In the range B5:B9, Malal wants to consolidate data that summarizes user responses to the Orange Tree website. In cell B5, insert a formula that references cell B17 on the Website worksheet to insert the total number of page views on the website during the last 12 weeks. Insert similar formulas in the range B6:B9 to insert the totals for likes, comments, shares, and follows on the website during the last 12 weeks. /r/n 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_EX19_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.]/r/n 6. In the range A 19: F 32, 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. FIII the range B21:B31 with the formula in cell B20 to consolidate the total page view data for the remaining weeks. Fill the range C 20: F 31 with the formulas in the range B 20: B 31 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. 9. Go to the Schedule worksheet, which contains the beginnings of a schedule for developing the new website. In cell B3, enter a formula using the DATE function to enter April 3,2021 as the date. 10. For milestones 2-10, the dates are five days after the previous start date. To exclude weekends for those days, enter a formula in cell C7 using the WORKDAY function that adds five days to the date in cell C6. Fill the range C8: C 15 with the formula in cell C 7 to complete the schedule. 11. Move the Website Project Timeline chart to the Overview worksheet. Position the chart so its upper-left corner is in cell H23 and its lower-right corner is in cell M36 on the overview worksheet. Change the number format of the horizontal axis values in the Website Project Timeline chart to display dates with an abbreviated month name, a hyphen, and the year abbreviated, as in Mar-21.12. Retum to the Schedule worksheet to prepare it for printing. Set top and bottom margins of 1") and then center the worksheet vertically on the page. Insert a footer that displays the sheet Name in the center section.

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_2

Step: 3

blur-text-image_3

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

8th Edition

013460153X, 978-0134601533

More Books

Students also viewed these Databases questions