A key activity for marketing professionals is to analyze how population demographics change in certain regions. This is especially important for specialty retail stores that target a specific age group within a population. This exercise utilizes the skills covered in this module to analyze hypothetical population trends. The decisions that can be made with such information include where to open new stores, whether existing stores should be closed and reopened in other communities, and whether the product assortment should be adjusted. The purpose of this exercise is to use the skills presented in this module to analyze hypothetical population trends for a fashion retailer.InstructionsNote: Depending on your installation and configuration, color choices available to you may be different than what is specified in the instructions. Simply choose something similar.1.Start Microsoft Excel and create a new blank workbook.2.In the Sheet1 worksheet, enter the year 2008 into cell B3.3.Use AutoFill to fill the years 2009 to 2012 in the range C3:F3.4.Change the font style to Arial and the font size to 12 points for all cell locations in the Sheet1 worksheet.5.Format the range B3:F3 as bold.6.Merge and center the cells in the range A1:F1.7.Make the following formatting adjustments to the range A1:F1: bold; italics; change the cell fill color to Green, Accent 6, Lighter 60%; change the font size to 14 points.8.Enter the title for this worksheet into the range A1:F1 on two lines. The first line should read Population Trends by Age Group. The second line should read for Region 5.9.Increase the height of Row 1 so the title is visible.10.Delete Row 2.11.Increase the height of Row 2 to 21 pixels.12.Enter the row titles in column A. Enter 0 to 11 in A3, 12 to 21 in A4, 21 to 40 in A5, and 41 to 60 in A6.13.Format the range A3:A6 as bold14.Enter the data in the range B3:F6.Enter 100000 in B3, 176000 in C3, 240000 in D3, 330000 in E3, and 370000 in F3.Enter 185000 in B4, 190000 in C4, 195000 in D4, 200000 in E4, and 205000 in F4.Enter 200000 in B5, 220000 in C5, 240000 in D5, 270000 in E5, and 300000 in F5.Enter 400000 in B6, 330000 in C6, 280000 in D6, 180000 in E6, and 150000 in F6.15.Format the values in the range B3:F6 so a comma separates each thousands place with zero decimal places.
