Answered step by step
Verified Expert Solution
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 B:B Malal wants to consolidate data that summarizes user responses to the Orange Tree website. In cell B insert a formula that references cell B on the Website worksheet to insert the total number of page views on the website during the last weeks. Insert similar formulas in the range B:B to insert the totals for likes, comments, shares, and follows on the website during the last weeks. rn 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.rn 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. FIII 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. Go to the Schedule worksheet, which contains the beginnings of a schedule for developing the new website. In cell B enter a formula using the DATE function to enter April as the date. For milestones the dates are five days after the previous start date. To exclude weekends for those days, enter a formula in cell C using the WORKDAY function that adds five days to the date in cell C Fill the range C: C with the formula in cell C to complete the schedule. Move the Website Project Timeline chart to the Overview worksheet. Position the chart so its upperleft corner is in cell H and its lowerright corner is in cell M 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 Retum to the Schedule worksheet to prepare it for printing. Set top and bottom margins of 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
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