MRCH 1950, Excel for Business Applications Create charts in Microsoft Excel 10 points, In-Class Activity Objective Create professional charts using Microsoft Excel to provide visual representation of the assortment data you collect and input into a spreadsheet. Purpose Microsoft Excel provides chart tools that generate impactful visual representations of data. The concept of data visualization is essential for a world that is grounded in digital technology, fast paced, and looking for quick insights, and understanding of trends and relationships in data Criteria 1) Visit one of the following retail BRICK AND MORTAR STORE LOCATIONS (not online site) and perform an assortment review a) Pick one store i) Target, Macy's, JCPenney, Sears, Bloomingdales ii) Find their bedding section and select a fixture/section of the department b) Take a photo of the section and upload to chart assignment c) Document the inventory i) Count per style ii) Names of the colors/pattern offered (1) Count how many colors per style iii) Names of sizes offered (1) Count how many sizes per color 2) Begin with a new workbook and name the sheet (tab) Charts 3) Create a data set of your assortment count from the store visit 4) Create three different charts from your data set a) Include the question you are seeking to answer by creating each chart b) Edit and annotate your charts to highlight the important trends or relationships you find c) Do you need to hide any data to allow the focus to be on your charts? d) What other formatting can you execute to create the most dynamic and impactful visual spreadsheet Turn-in:report? 1) Save the file as FirstlnitialLastName_Charts (i.e. CKastanos_Charts) 2) Header with your name and date 3) Footer with file name, sheet name, and current date MRCH 1950, Excel for Business Applications Create charts in Microsoft Excel 10 points, In-Class Activity Objective Create professional charts using Microsoft Excel to provide visual representation of the assortment data you collect and input into a spreadsheet. Purpose Microsoft Excel provides chart tools that generate impactful visual representations of data. The concept of data visualization is essential for a world that is grounded in digital technology, fast paced, and looking for quick insights, and understanding of trends and relationships in data Criteria 1) Visit one of the following retail BRICK AND MORTAR STORE LOCATIONS (not online site) and perform an assortment review a) Pick one store i) Target, Macy's, JCPenney, Sears, Bloomingdales ii) Find their bedding section and select a fixture/section of the department b) Take a photo of the section and upload to chart assignment c) Document the inventory i) Count per style ii) Names of the colors/pattern offered (1) Count how many colors per style iii) Names of sizes offered (1) Count how many sizes per color 2) Begin with a new workbook and name the sheet (tab) Charts 3) Create a data set of your assortment count from the store visit 4) Create three different charts from your data set a) Include the question you are seeking to answer by creating each chart b) Edit and annotate your charts to highlight the important trends or relationships you find c) Do you need to hide any data to allow the focus to be on your charts? d) What other formatting can you execute to create the most dynamic and impactful visual spreadsheet Turn-in:report? 1) Save the file as FirstlnitialLastName_Charts (i.e. CKastanos_Charts) 2) Header with your name and date 3) Footer with file name, sheet name, and current date