Teller Crackers & Snacks (TCS) recently held a contest in which it awarded each of ten randomly
Question:
Teller Crackers & Snacks (TCS) recently held a contest in which it awarded each of ten randomly drawn entrants a large box of assorted crackers each week for a year. The names and addresses of the ten winners are available in the file tcswinners. The fields in the file are First Name, Last Name, Street Address, Apartment number, City, State, and Zip Code.
In order to create mailing labels to use to ship the boxes of crackers to the winners, TCS must create a new file with
● a field named Winner that contains the first and last name separated by a space for each record in the file tcswinners
● a field named Mailing Address that contains the street address, apartment number, city, state, and zip code separated by a comma and a space for each record in the file tcswinners (note that the field Apartment Number has legitimate missing values for many records)
Create these new fields for TCS, delete all other fields, and save the results as a file under the name tcswinnersmailing.xlsx.
Step by Step Answer:
Business Analytics
ISBN: 9780357902219
5th Edition
Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann