Analyze data to answer questions course challenge answers
1. Scenario 1, Questions 1-7
For the past six months, you have been working for a direct-mail marketing firm as a junior marketing analyst. Direct mail is advertising material sent to people through the mail. These people can be current or prospective customers, clients, or donors. Many charities depend on direct mail for financial support.
Your company, Directly Dynamic, creates direct-mail pieces with its in-house staff of graphic designers, expert mail list services, and on-site printing. Your team has just been hired by a local nonprofit, Food Justice Rock Springs. The mission of Food Justice Rock Springs is to eliminate food deserts by establishing local gardens, providing mobile pantries, educating residents, and more. Click below to read the email from Tayen Bell, vice president of marketing and outreach.
You begin by reviewing the dataset. To use the template for this dataset, click the link below and select “Use Template.”
Link to template: Dynamic Dataset
Or, if you don’t have a Google account, download the file directly from the attachment below.
The client has asked you to send two separate mailings: one to people within 50 miles of Rock Springs; the other to anyone outside that area. So, to research each donor’s distance from the city, you first need to find out where all of these people live.
You could scroll through 209 rows of data, but you know there is a more efficient way to organize the cities.
Which of the following procedures will enable you to sort your spreadsheet by city (Column K) in ascending order? Select all that apply.
- Select A2-R210, then use the drop-down menu to Sort Sheet by Column K from A to Z
- Use the SORT function syntax: =SORT(A2:R210, 11, TRUE)
- Select A2-R210, then use the drop-down menu to Sort Range by Column K from A to Z
- Use the SORT function syntax: =SORT(A2:R210, K, TRUE)