computer science microsoft

Sep 27th, 2014
DotaCN
Category:
Computer Science
Price: $15 USD

Question description

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.

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.

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.

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.

For Meals, include expenses for Brkfast, Lunch, and Dinner. Enter the formula in cell P18.

Do the same for Meals, Entertain, 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.

Finally, in cell P22, enter a function to show the total of cells P17–P21.

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. 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.

Add line callouts as shown in the figure. (Click the Insert menu and then the Shapes icon)

Travel consists of Air + Ground + Lodging + Mileage $.

Meals consist of Brkfast + Lunch + Dinner.

Your pie chart must show the graphical representation of the expenses in range O17-P12

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UCLA
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
kevin12622
Nov 29th, 2016
" Goes above and beyond expectations ! "
kiln82
Nov 20th, 2016
" awesome work thanks "
ashleyisgod
Nov 16th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Nov 7th, 2016
" Excellent work as usual "
Molly_Moon
Oct 24th, 2016
" AMAZING as always! "
kpcutie
Oct 15th, 2016
" Excellent job "
Hemapathy
Oct 2nd, 2016
" all I can say is wow very fast work, great work thanks "
pmallory
Sep 23rd, 2016
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors