Reference no: EM131442218
Asssignemnt
1. In this exercise, you are going to create a chart showing the expenses in the categories listed below. You first need to calculate the data in a summary section of your spreadsheet. The data in the summary section will be used to create the chart.
o First, in cells O16-O21, enter the following labels (headers): "Summary," "Travel," "Meals," "Entertain," "Phone," and "Other." Do not include the quotes when entering the labels in your worksheet.
o Cells P17-P21 will hold the data you will calculate to get the total expense for each category. For example, if you went on a business trip, you would need to enter the amount you spent on travel in one cell, the amount you spent on meals in another cell, and so on. Then, you would use the Sum function to get a total of your expenses for the trip. Put the totals for each category next to the labels you have created. These formulas go in cells P17-P21.
o For Travel, include expenses for Ground, Air, Lodging, and Mileage $. Be sure to only include dollars in your formula. Enter the formula in cell P17.
o For Meals, include expenses for Brkfast, Lunch, and Dinner. Enter the formula in cell P18.
o Do the same for Entertain, Phone, and Other. If a category does not require the addition of one or more totals, do not use Sum or any other built-in functions. Use cell references for the data rather than entering the actual amount for each category.
2. Finally, in cell P22, enter a function to show the total of cells P17-P21.
3. After selecting the range O17-P21, create a pie chart to show the graphical representation of the expenses, using the figure below as a guide.
4. Move the chart on its own chart sheet named "Pie Chart." Include category names and percentages for data labels on your chart. Using the O17: P21 range will include your data labels and the data series to be charted.
5. Add line callouts as shown in the figure. (Click the Insert menu and then the Shapes icon)
o Travel consists of Air + Ground + Lodging + Mileage $.
o Meals consist of Brkfast + Lunch + Dinner.
6. Rename the sheet tab for the data spreadsheet as "Expense Report.
Attachment:- Greer_John.xlsx
|
Using harvard business review
: Using Harvard Business Review, The Economist, The New York Times, or the Wall Street Journal, find 1 article published in the current semester (Spring 2017) on a topic relevant to your marketing class. Write a summary of this article and explain h..
|
|
Explain each sampling technique discussed in visual learner
: Explain Each Sampling Technique discussed in the "Visual Learner: Statistics" in your own words, and give examples of when each technique would be appropriate.
|
|
Dining out in luogang case study
: When journalist Peter Hessler was invited for lunch in the rural Chinese village of Luogang in Guangdong Province, he was in for a surprise.32 After he was seated at a table in the Highest Ranking Wild Flavor Restaurant
|
|
How did you meet expected and unexpected challenges
: How unique was the context? How creative was your strategy? How did you meet expected and unexpected challenges? Have you included all the relevant details? Is it interesting? Is it well written?
|
|
Create a chart showing the expenses in the categories listed
: In this exercise, you are going to create a chart showing the expenses in the categories listed below. You first need to calculate the data in a summary section of your spreadsheet.
|
|
Orthodontists feel like wild weekend bikers
: After all, if Harley Davidson can build a brand that makes 55 year old orthodontists feel like wild weekend bikers - the road's wide open.
|
|
Identify the contributing factors that caused the disaster
: Research an article on one of the focusing events that occurred between the years of 1927-1950 (The Great Mississippi Flood of 1927, 1930s Dust Bowl, or Texas City Explosion). Respond to the following questions: Identify the contributing factors t..
|
|
What are project management processes
: 1. What are project management processes? What are product-orientated processes? Give examples of both. Why is there a balance between the two? (Craft this well to tie into Question 2).
|
|
Explain covenant mention in scripture and where they climax
: What four worlds does the vocalic world of interpretation include and explain. Drawing might help here but will not be sufficient. Explain the covenants mentioned in scripture and where they climax?
|