In this project, you will open the workbook and add a column
Not what you're looking for?
In this project, you will open the workbook and add a column chart to show how expenses were divided. To view these instructions while you work in Excel, do either of the following: Print this page of instructions or move back and forth between this page and Excel by clicking each application's button on the Windows taskbar.
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. Then, you can use that data in that summary section to create the chart. First, in cells K16:K21, enter the following labels (headers): Summary, Travel, Meals, Entertain, Phone, Other. Cells M17 through M21 will hold the data you will add 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 add function to get a total of your expenses for the trip.
For Travel, include expenses for Ground and Air transportation, Lodging, and Mileage $.
For Meals, include expenses for Brkfast, Lunch, and Dinner.
2. Finally, in cell M22, enter a function to show the total of M17:M21.You can now use this summary to create the column chart.
3. Create a column chart to show the graphical representation of the expenses, using the figure below as a guide. Create the chart on its own chart sheet, named Expense Report Chart. Do not include a legend but include the title "Expenses." Include data labels.
4. Add Line Callouts as shown in the figure. (Click the Insert menu, then the Shapes icon)
Travel consists of Air + Ground + Lodging + Mileage $.
Meals consist of Brkfast + Lunch + Dinner.
5. Rename the sheet tab for the spreadsheet Expense Report.
6. Fill in the blank cells in range A8:M11 with numeric values. You may choose to fill those cells with 0s (zeros).
Purchase this Solution
Solution Summary
The solution provides detailed explanations and answer for the problem.
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.