Bus 155

Good Essays
Topics: Spreadsheet, Mail
2. Fact Pattern: Question 2:
You own your own small party supply and rental business. You maintain an Excel list of potential customers and clients who have rented or purchased from you in the past two years. The list includes both physical mailing addresses and e-mail addresses for each person listed. You have a “category“ code to show whether the contact is a client. If they have done business with you, they show a code of “CUST” for customer. If they are potential customers who have not yet purchased or rented from you, they are coded as “PROS” for prospect. You want to grow your business, and feel the best way to do this is to solicit business from customers who show a physical address in the same zip code as your business location. Respond fully to the following questions regarding this task: A - (TCO 4) Explain how you will use Excel to find in your list the people you are targeting for new business. Be specific.

Assuming that the excel list has a column labeled “Customer Category” and a column labeled “Zip Code”, I would first adjust the entire list so as to apply filters, using the “filter” function from the “Sort and Filter” category. I would then first apply in the “Customer Category” column to select on the values “PROS”. This would show only the potential customer list. I would then go to the “Zip Code” column, and apply a filter for the zip code choosing the specific zip code of interest, and this would give me the list of potential clients located within the stores location.

B - (TCO 8) You want to send a letter to each person on your list from Part A of this question. You have a nice form letter that you have used in the past. Explain how you might personalize the letter by adding your customer names.

If the list was of less than 10 potential clients, I would modify each letter individually, by adding the customers mailing information for each. But if it was a list of, say over 100, I would use the “Mail Merge” function in MSWord

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Com 155

    • 325 Words
    • 2 Pages

    I’m not good at writing papers so the steps that I want to learn to accomplish and learn from this class are is how to talk to different audiences using tones, and purposes. When I’m writing papers what I mainly do is talk a little about the subject and talk about how I feel and what can change about the subject. When writing documents and using tones I tend to be sarcastic with my words. It’s not being two be rude or disrespectful, it is just the way I talk and carry myself. That is why I want…

    • 325 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    bis 155

    • 899 Words
    • 3 Pages

    BIS 155 Exam 1. (TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: Note: This is a one part question. • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly…

    • 899 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Comm 155

    • 2284 Words
    • 10 Pages

    Associate Program Material Appendix C Rhetorical Modes Matrix Rhetorical modes are methods for effectively communicating through language and writing. Complete the following chart to identify the purpose and structure of the various rhetorical modes used in academic writing. Provide at least two tips for writing each type of rhetorical device. NOTE: You may not copy and paste anything directly from the textbook or a web site. All information included in this assignment must be written…

    • 2284 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    com 155

    • 256 Words
    • 2 Pages

    Chronic Disease Outline SCI/162 Outline (Cancer) I. Introduction Chronic Disease continues to plaque many people each year. The number of cases reported continues to rise and the majority of them end in fatality. Most of these diseases are preventable and new treatment has been discovered. While the five year survival rates have risen dramatically since the 1900s and all cancer is not fatal, cancer is one of the leading causes of death in the United States. II. Causes…

    • 256 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cis 155 Unix

    • 535 Words
    • 3 Pages

    CIS 155 Unix Operating System Homework 2 Vi Editor Cursor Movement h j k l h j k l SAPACEBAR right +, - First character of next, previous Line forward word: w back word: b end of word: e start of line: ^,0 end of line: $ start of file: gg,:1<Enter>,1G end of file: G go to line nn: :nn<Enter>,nnG use ESC to switch between Input…

    • 535 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    155 Appendix D

    • 354 Words
    • 2 Pages

    Associate Program Material Appendix D Selecting a Topic and Brainstorming Worksheet Complete the following and post as an attachment. |What two objects, people, subjects, or concepts are you going to |I would compare and contrast renting a home vs. owning a home | |compare and/or contrast? | | |What are the similarities between the two objects, people, |Agents or real estate…

    • 354 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Com/155 Final

    • 925 Words
    • 4 Pages

    Compare and Contrasting Plants and Animals Man has come a long way from the caveman days and so has our understanding of the world around us. Humans have always used plants and animals in one capacity or another, yet when a person thinks of the phrase 'plants and animals', they automatically begin thinking about the differences between the two. Well I say that plants and animals have been known far too long for their differences. And as different as they seem, plants and animals are very…

    • 925 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Elements Of Com 155 Essay

    • 350 Words
    • 2 Pages

    Week 1 COMM 155 Week 1 When writing a paragraph explaining what I would hope to accomplish in COMM 155, I would begin by stating the four elements of a successful essay. I would begin by stating my topic in the first sentence while keeping in mind my audience which would be my professor so the tone that I would use would be formal as with any academic writing. The purpose of the topic is to see what knowledge I have learned in class so far and what my understanding is on this topic. The content…

    • 350 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    the bus

    • 613 Words
    • 3 Pages

    THE BUS IS LATE. waiting for the bus in the RAIN in the RAIN wh wh WAITING FOR THE BUS IN THE RAIN waiting for the bus in the rain in the rain wh wh waiting for the bus in the rain waiting for the bus in the RAIN in the RAIN wh wh WAITING FOR THE BUS IN THE RAIN waiting for the bus in the rain in the rain wh wh waiting for the bus in the rain waiting for the bus in the RAIN in the RAIN wh wh WAITING FOR THE BUS IN THE RAIN waiting for the bus in the rain in the rain wh wh waiting for…

    • 613 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Bio 155 Lab Report

    • 1344 Words
    • 9 Pages

    Effect of Enzyme and Substrate Concentration on Reaction Rate by Zachary A. Poché Biology 155 Laboratory October 15, 2014 Lab Partners: Cade White, Hannah Ragas, Russheka Aremillion ABSTRACT In order to increase the reaction rate, substrates attach to the active site of enzymes which decrease the activation energy required to convert substrates to products. We examined the effect of enzyme concentration and substrate concentration on the overall rate of the reaction. To determine…

    • 1344 Words
    • 9 Pages
    Better Essays