I

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.

Landholdt 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: Medium Workbook [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 a 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 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 percent 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.

Reference

• Parsons, J. J. (2015). New Perspective Computer Concepts 2016, Comprehensive + Microsoft Office 2013, First Course(Enhanced ed.). Course Technology, Inc.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

“Imagine that you are an absolutely unscrupulous district attorney, willing to do anything—including convicting an innocent person – in order to get a conviction in a particularly notorious criminal case. (i.e., you don’t much care who is convicted – guilty or innocent – so long as you get a conviction of someone). You have two witnesses to the crime – a murder during the robbery of an all-night diner – but neither is very confident of being able to identify the killer. What could you do to influence those witnesses so that they will not only identify someone as the killer, but also testify confidently (you are not concerned about whether they testify accurately) that person is the killer and that the murder was a particularly brutal one.” (Ch 16, p. 309)

Initial Post: Your initial post should be at minimum 250 words.  It should be posted by Thursday.   In your post accomplish the following:  Describe steps you would take, from the first steps of “identification” to the day of the trial. [Chapter 16 is your guide]

*******ONlY NEED THE REPLY TO OTHERS PART*******

Reply to Others: Reply to at least one student that has not had more than two replies.   Your reply should be at minimum 250 words.  Pretend you are the assistant district attorney and you are equally unscrupulous.   You will further the district attorney (i.e., student’s) response by suggesting how to construct false causal claims that will support the steps outlined by the district attorney. [Chapter 15 is your guide).

HERE IS THE INITIAL POST OF ONE STUDENT

If I were trying to influence two witnesses in order to make a convection there are multiple steps I would take to get a false convection. The first step would be to follow the “Photo-Bias” experiment done at the University of Nebraska. I would show the witness multiple videos of people who look like a particular suspect and then place that suspects mug shot in front of them. After doing this I would later have the witnesses look at a lineup containing the suspect and they would be bound to pick them out. Witnesses seeing these photos and multiple videos would cause an unconscious transference resulting in them identifying in a line up the suspects who’s mugshot they saw. Next, I would have the witness pick from a line up but in that line up I would have someone who works at the all night diner. This would cause an unconscious transference because odds are they would recognize them from just eating at the dinner while that person was working. Which would most likely result in a false identification. Then I would move on to creating a prejudice with the witness for someone in the lineup. I would tell them negative stories about them and say they are capable of doing a crime like this to help the witness connect them to the crime. Finally, I would ask the witnesses questions that helped fill in the fuzzy details of the murder and robbery with details I needed to make a convection. With a play on words I would ask questions that make suggestions about the person I needed to convict. Such as does the person have hair similar to the one picked from a line up. Does the person have the same build and skin tone as the one from the line up. Questions like these would help the witness make a false id and help me get a convection. 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

 Imagine you are working as a cognitive psychologist who specializes in visual perception. In this role, you are assigned to create a short presentation that will help a target audience in a professional setting (for instance, teachers, marketing professionals, driving instructors, pilots, etc.) understand the basic principles of visual perception and why they are important for everyday life and their profession. You should create a five-minute presentation that meets the previously mentioned goals. Be sure to identify at least two different theories from your reading that support your presentation. Discuss the theories in terms of how they can help people understand strengths and weaknesses in visual processing and how the theories might help us overcome weaknesses. 

MAke sure to answer every part of questions asked. Explain each in detail APA format and no Grammar issues Teacher is strict

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

“””Imagine you work for the first of these companies (Fantastic Holdings Limit(http://www.aspecthuntley.com.au.ezproxy.scu.edu.au/af/company/mainview?ASXCode=FAN). The second is one of your company’s competitors(Nick Scali Limited). Task 2: Risk and Return (15 marks) Your Aunty Jane has some savings she wants to invest in shares. She has asked for your advice because she knows you are doing a finance unit in your university degree. Aunty thinks you are brilliant and so wants to invest all her savings in shares of the company your work for (that is, the one assigned to your for this assignment). Your Aunty is risk averse and from your study you know that investing in only one asset is risky. You decide you need to explain this to Aunty. You approach this task as follows. 2.Calculate the monthly returns on the S&P/ASX 200 index during the same period.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

http://img841.imageshack.us/i/integral.gif/Picture of the graph above:Do the following. a = 16(a) Use six rectangles to find estimates of each type for the area under the given graph of f from x = 0 to x = 48.Sample points are midpoints.M6 = 3I don’t know what is the answer.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"