Which of the following tools will enable you to sort your spreadsheet by city (Column K) in ascending order?

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.

C5 Course Challenge, Email From Tayen Bell, Directly Dynamic .pdfPDF File

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.

Dynamic Dataset.xlsx

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.