Create a chart showing the expenses in the categories listed

Assignment Help Basic Computer Science
Reference no: EM131070327

1. Open your submitted Unit 4 IP assignment that should be labeled as "(your last name_your first name)_U4 Expense Report 2.xlsx," and save it as "(your last name_your first name)_U5 Expense Report 3.xlsx" in your working folder on your computer.

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

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

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

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

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

7. Rename the sheet tab for the data spreadsheet as "Expense Report."

8. Save your final report as "(your last name_your first name)_U5 Expense Report 4.xlsx" (e.g., Doe_John_U5 Expense Report 4.xlsx).

9. Submit your report.

Reference no: EM131070327

Questions Cloud

Discuss the reasoning behind this claim : The quantity theory states that the impact of money on nominal GDP can be determined without details about the aggregate demand curve, so long as the velocity of money is predictable. Discuss the reasoning behind this claim.
Creates an atmosphere that is easy to move and manipulate : Electron beam welders are used in industries where high precision or complex welds are needed. Such industries include bio-medical and aerospace.
Demonstrate interference of sound waves : To demonstrate interference of sound waves, a buzzer is placed in the center of an empty mailing tube that is 0.80 m long. The sound waves emerge from the two ends of the tube in phase and interfere with each other in the region surrounding the tu..
Charge increase incrossing the battery terminals : A battery with an emf of 10.8 V and internal resistance of 1.07Ω carries a positive current of 0.520 A from its negative terminalto its positive terminal.
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.
Make a mirror-image layout of the plc trainer : By now, you should have been up in the PLC lab getting familiar with the HMI and how to program it; how to define new screens, label them, and access them from the F# tabs below; and how to design Icons/Images from the Library that links HMI image..
Velocity of the box at the top of the plank : If the incline is frictionless, and the pushing force is 600 to do the job, what is the work done by the push? What is the velocity of the box at the top of the plank? Please show work.
Culture and the meaning of a good life : What ways has the information in this course changed your life? Has it changed your personal belief system? Has it changed your understanding of your fellow human beings?
Problem regarding the ideal mechanical advantage : A large piano that weighs 4100 N is to be moved into a house by way of an opening that is 1.5 m from the ground. If the movers use an18 m plank as an incline and a force of 600 N, what is the ideal mechanical advantage?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd