2023 In this assignment use the information from the previous unit s Individual Project to | Assignment Collections

Computer Science 2023 project 5

2023 In this assignment use the information from the previous unit s Individual Project to | Assignment Collections

In this assignment, use the information from the previous unit’s Individual Project to create an expanded worksheet with a summary area and a chart showing this summary area.

  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.
    • 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 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)
    • Travel consists of Air + Ground + Lodging + Mileage $.
    • 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.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Grading Rubric

Step 1:

  • Open correct file and create new document with “Save As”

10%

Step 2:

  • Create a chart with the specified categories and data

45%

Steps 3-4:

  • Step up function in cell P22
  • Create pie chart for range O17: P21

18%

Step 5-6:

  • Create new sheet for Pie Chart with specified name and formatting
  • Add specified line callouts as shown in figure

17%

Steps 7-8:

  • Rename data spreadsheet as specified
  • Save and submit document with required file name

10%

 

 
 

 

Instructions:

Preparing For Week 5 Rubrics and Wrapping Up Week 4

Greetings Students,

Unit 4 covered the Introduction to Excel.

Unit 5 is here and we will discuss Excel intermediate skills.

 

 

Instructor’s Comments:

PLEASE USE THE SOFTWARE APPLICATION EXCEL TO COMPLETE YOUR INTELLIPATH ASSIGNMENT

 

 

 Legend

  • Extra Credit
  •  

  • View Assignment Rubric
 

 

We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.

Place Order Now

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational