Use the following scenario and Google Sheets simulation to answer Questions 1-3. The simulation is for you to practice working with Google Sheets. The questions serve as a tool to further reflect on its components and to give practical experience. Use the simulation and questions however you see fit to build your knowledge of how to use Google Sheets for marketing purposes.
Scenario: Inu + Neko have a physical store and a website where they sell toys and food for pets, and you are their marketing analyst. Your manager sends you a report based on some research she did. She conducted surveys of 350 Inu + Neko customers to better understand who they are and what their needs are. Customers were presented with six features of the Inu+Neko product offerings and asked to indicate which is most important to them.
- Organic dog food options
- Nutrient enriched dog food options
- Dog food delivery
- A variety of dog food options
- Auto delivery of dog food
This information will help you later to market to this audience. Your manager asks whether you can provide her with an easy to understand horizontal bar chart so that she can share her findings with stakeholders. Here is the spreadsheet with the data she provides to you.
Simulation: In this simulation, you will use Google Sheets to create a horizontal bar chart based on the information from the survey responses your manager collected. Clicking the simulation link will open it in a new window.
- True
- False