Tracking Your Clients Using MS Excel

In this activity, you will work on a medium revenue workbook. For

this, you will first read the following scenario and then complete the

steps given below.

Rosegrant Advertising sells advertising space to local companies in Dover, Delaware. They want to keep track of their clients and revenue by using the Medium workbook. One goal of the company is to see by percentage which customer sales are above average.

They have already created a workbook that contains the customer information organized by advertising medium. They have asked you to complete and format this workbook. Complete the following steps:

  1. Open the Medium workbook. Select the following link to access the Medium workbook:   download [XLSX file size 10.9 KB]
  2. In the documentation sheet, enter your name in cell B3 and the date in cell B4.
  3. Set the following formatting to the Documentation sheet
    1. In cell A1, apply the Title cell style, increase the font size to 24 points, and then change the font color to medium orange.
    2. Apply the Accent2 cell style to the range A3:A5.
    3. Wrap the text within the range B3:B5, and then left- and top-align the text in the cells.
    4. Set the column width to 27.00.
    5. Change the format of the date in cell B4 to the long date format.
    6. Add borders around all of the cells in the range A3:B5.
  4. Copy the cell format for cell A1 in the Documentation sheet to cell A1 in the Revenue worksheet.
  5. Format cell A3 using the Heading 4 cell style.
  6. Format the range A4:G4 using the Accent2 cell style.
  7. In cell F4, enter the text Total Sales. In cell G4 enter the text Percentage.
  8. Insert a blank row after each type of medium (TV, radio, billboard, Web sites).
  9. For each company, calculate the total sales, which is equal to the number of units multiplied by the price per unit. Store the results in the corresponding rows in column F.
  10. Format the range E5:F24 with the comma style and display two decimal places.
  11. Format the range G5:G24 as a percentage with two decimal places.
  12. Merge the cells in the range A5:A8, rotate the text up, and then center-align the cell content both horizontally and vertically. Change the fill color to medium blue, increase the font size to 14 point, and then change the font color to white.
  13. Place a thick box border around the TV-related cells in the range A5:G8.
  14. Repeat the previous two steps for the other three mediums.
  15. Calculate the Total Sales for each medium using the AutoSum Formula. Place the result for each medium in the appropriate cell in column F (the new rows created in step 8).
  16. To determine the percentage of sales for each customer, divide the sales for that customer by Total Sales for that medium. Use absolute addressing for Total Sales. Format each cell in Column G as a percentage with up to two decimal places.
  17. For each type of Medium, create a Conditional Formatting rule for the percentages (column G) to highlight those percentages that exceed the average in dark green text on a light green fill.
  18. Rename the worksheet Documentation as M5A1 Report
  19. Set the following print formats for the Medium Revenue worksheet:
    1. Change the page orientation to landscape.
    2. Add a footer that prints Prepared by [your name] in the left section, Page page # in the center section, and Revenue by Medium in the right section.
    3. Adjust the column widths so that all columns fit on one page.20. Return the worksheet to Normal View.
  20. Once you have successfully completed all the steps in this assignment, submit your Medium_Revenue workbook

Requirements:   |   Order any type of Service We Provide We are the best assignment service that can satisfy student’s demands in different scientific fields. We perform tasks of any kind. Our specialists provide diverse custom assignment writing services to students from all over the world every day. You can contact us for assistance with: • Essays of any type (application, scholarship, argumentative, personal, informative, persuasive, compare and contrast, narrative, analytical, cause and effect, critical, process, descriptive, expository essays); • Homework, • Assignments, • Reviews of all types (for a book, an article, or a film), • Reports, • Annotated bibliography, • Projects, • Thesis, • Term papers, • Presentations, • Lab works, • Research papers, • Speeches, • Critical thinking, • Capstone projects; • plan; • Coursework’s; • Dissertations. The list is far from complete! Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. ……. | Java

Rosegrant Advertising Company
Monthly Advertising Revenue Chart
Medium Company Type of Units Units Price per unit
TV Porterhouse Molding, Inc. 30 second commercial 6 200
Round Candle Company 30 second commercial 12 200
McGregor & Sons Trash Removal 30 second commercial 4 200
Elegant Accents 60 second commercial 2 350
Radio J & R Construction 30 second commercial 15 100
Miracle Redemption Bottle Store 60 second commercial 12 200
Maxell Manufacturing 30 second commercial 20 100
Pit Bakery 60 second commercial 6 200
Billboard Advanced Plumbing & Heating Full board per month 12 350
Goldberg Collection Agency Half board per month 6 200
Chopping Insurance Co. Half board per month 12 200
Rhine lake Hospital Full board per month 6 350
Web Sites Perfect Computer Consulting 5 sites per months 6 150
Gino’s Auto Parts 5 sites per months 12 150
Pennywise Second-Hand Store 10 sites per month 12 275
Franklin Ford Dealership 5 sites per months 6 150

Order any type of Service We Provide

We are the best assignment service that can satisfy student’s demands in different scientific fields. We perform tasks of any kind. Our specialists provide diverse custom assignment writing services to students from all over the world every day. You can contact us for assistance with:

  • Essays of any type (application, scholarship, argumentative, personal, informative, persuasive, compare and contrast, narrative, analytical, cause and effect, critical, process, descriptive, expository essays);
  • Homework,
  • Assignments,
  • Reviews of all types (for a book, an article, or a film),
  • Reports,
  • Annotated bibliography,
  • Projects,
  • Thesis,
  • Term papers,
  • Presentations,
  • Lab works,
  • Research papers,
  • Speeches,
  • Critical thinking,
  • Capstone projects;
  • plan;
  • Coursework’s;
  • Dissertations.

The list is far from complete!

Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Your college assignment will never turn out an untoward surprise! Whether you need research for high school, an undergraduate program, or a Master’s or Doctoral degree, you will get exactly what you are looking for to sound smart and well-informed.

If you are pressed for time, request our experts!

We are your academic saver. It is a perfect solution for people who need academic help but has no professionals nearby to provide it. Just redirect your home tasks to us and forget about any educational issues. With us, you will get 100% plagiarism-free content delivered on time by an experienced specialist in a particular field.

Main Advantages of Collaboration with Us

When you order professional assignments here, you will get:

Original custom papers. We value your academic reputation. Just as well, we value the years of thorough work on our reputation for reliability and never compromise the originality of delivered papers. We will never endanger both. Every custom assignment is written from zero – the only possible first stage of work on the order is research. We apply the latest plagiary checking tools on the final stage, so plagiarism has no chance to emerge in your college assignment writing.

Control over the order completion. To make the process of collaboration comfortable and efficient, we offer our clients to choose the writer themselves taking into account all the requirements and the budget. For you to save nerves, having entrusted your fateful task to some qualified “stranger”, we enable communication with the assigned writer in the process of order completion.

Affordable assistance. . help with college assignments. We are eager to help you start investing in your career growth today. That is why our service is so affordable. We don’t charge to pay for the latest marketing tricks or advertisements – we choose the best experts in the labor market who write great custom papers in any area, level of complexity, and time frame. Our client’s grateful feedback is a top advertising trick.

On-time delivery. The quality of a paper is only valued when it is delivered within the determined time frame – you will get your custom assignment writing service in time and have a couple of days to revise it and ask for changes in case they are needed. And you will still have time to learn the material.

Protection. We value your trust and take all measures needed to keep your private and banking details safe. We offer only well-tested payment methods. Due to the system of encryption and protected servers, no third party can have access to your data.

Custom support 24/7. We do our best to make the process of collaboration comfortable for the customer. Our “write my assignment” help is always here for you to provide a solution to your problems, give you a prompt answer to any question, and offer clarification as to any issue related to the services. Feel free to contact us anytime!

If you feel that your dissatisfaction with student life is growing every day and you just feel exhausted, don’t hesitate to change the situation for the better today. Order your first assignment from reliable custom assignment services today to evaluate the advantages.

Having seen the difference once, you won’t want to go back to your previous lifestyle. You deserve to find fulfillment in other spheres of your life, have hobbies, spend time with close people but continue making progress. It is possible when you have a professional helper. Don’t put off your life for someday after graduation!

Order your paper now! 

 

 

 

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code GURUH