Question: 2. On the GuestData worksheet, in cell H2, use a function to determine the number of months listed in cells A6:A17. 3. In cell J2,

2. On the GuestData worksheet, in cell H2, use a function to determine the number of months listed in cells A6:A17.

3. In cell J2, use a date function to calculate the survey duration in years using the 2017 Fiscal Start date and 2018 Fiscal Start date. 2. On the GuestData worksheet, in cell H2, use a

AutoSave OFF @yoo... e02_grader_hw_Advertise_WalkerBailey a Home Insert Draw Page Layout Formulas Data >> Tell me Share 0 Comments X ( A- % v Conditional Formatting Format as Table Cell Styles O IN Analyze Data Paste Font Alignment Number Cells Editing E2 xv fx A 1 Painted Paradise 2 3 3 4 4 B D E F G . H K L 2017 Fiscal Year Guest Survey - Advertisement Results Survey Duration Months Year(s) RESORT & SPA 2017 Fiscal Start Date: 7/1/16 2018 Fiscal Start Date: : 7/1/17 How did you hear about the Resort? (#Guest Results = #of times a Guest Responded with this answer) Resor Word Of Total Month Season Magazine Radio Television Internet Mouth Other Surveyed Month 925 41 1,887 1,239 422 395 4,909 Jan 660 16 965 406 317 26 2,390 Feb 694 46 928 681 323 46 2,718 Mar 304 28 646 568 339 79 1,964 Apr 892 46 374 307 266 149 2,034 May 1,551 36 247 283 313 138 2,568 Jun 722 20 837 63 12 12 1,666 Jul 375 84 819 36 231 79 1,624 Aug 1,387 113 269 539 84 2,707 Sep 331 50 675 71 149 1,516 Oct 1,476 119 196 609 25 21 2,446 Nov 1,893 14 131 22 358 283 2,701 Dec Total 11.210 613 7,974 4,824 3,070 1,552 29,243 Average 315 5 M/Year / 6 2016 JUL 7 2016 AUG 8 2016 SEP 9 2016 OCT 10 2016 NOV 11 2016 DEC 12 2017 JAN 13 2017 FEB 14 2017 MAR 15 2017 APR 16 2017 MAY 17 2017 JUN 18 19 20 21 22 23 24 25 26 240 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 GuestData Advertising Plan Marketing Consultants + Ready HE + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

2 On the GuestData worksheet, in cell H 2 , use a function to determine the number of months listed in cells A 6 :A 1 7 .

File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 2 Wrap Text General x cut A copy Format Painter Clipboard 11AA == SA Paste BIU Merge & Center $ % *38% Conditional Formatan...

Insert Draw Arial Design Layout References 14 - A A Aar A Mailings Review View vers 33 zh Project Description: The Painted Paradise Resort and Spa has been investing in advertising using different...

Instructions for Widget Works Excel Expert 3 6 5 Project Complete the following steps on the Sales worksheet: In range P 3 : P 6 , use a function to determine the number of orders placed for each...

2 Click the 2-Summary worksheet. In cell J3, insert a function to count the number of employees in Iowa. Copy the function from cell J3 to the range J4:J5. 3 In cell K3, insert a function to total...

WHAT ARE THE FORMULAS USED FOR EACH Work Days Worksheet In cells C2:C12, use a function to calculate the number of work days between the start dates in cells A2:A12 and the end dates in cells B2:B12...

2 On the SalesData worksheet in cell B 4 , use an XLOOKUP function to retrieve the product name for the ProductID in cell A 4 , using the table of data about the products at Kelly Computers on the...

YO 2 2 _ Excel _ BU 0 3 _ Assessment 2 _ Kelly _ Computers Project Description: As the new accounting assistant at Kelly Computer Services, you have been asked to expand upon the content of an...

Part II: Directions for the Excel worksheets - 2 points each Follow these instructions for the 6 worksheets in this file. Save the file with your name on your computer and then upload into MyITLab,...

Obtain the signal flow graph of the system whose block diagram is given and hence determine the transfer function masons gain formula

Hurst Inc. is a new corporation that has just completed a highly successful first year of operations. Hurst is a privately held corporation, but its president, Byron Hurst, has indicated that if the...

Question 1 Which of the following standards represents levels of operation that can be attained with reasonable effort? theoretical BOTTIII datal variable Question 2 A report that summarizes actual...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...