- Submitted By: mickymayer1
- Date Submitted: 05/21/2014 11:26 PM
- Category: Book Reports
- Words: 627
- Page: 3

CIS 105 Assignment Manipulating Data in Excel Spreadsheets (UOP)

For more course tutorials visit

www.tutorialrank.com

Tutorial Purchased: 3 Times, Rating: A+

Assignment: Manipulating Data in Excel Spreadsheets

• Resources: Appendix D, Appendix E, and Appendix F

• Due Date: Day 7 [Individual forum]

CIS 105 Survey of Computer Information Systems

Course Syllabus Page 20

• Use the chart tutorial in Appendix E and Appendix F to familiarize yourself with creating

charts and graphs in Excel.

• Continue to manipulate the data in the Appendix D Excel spreadsheet from the previous

CheckPoint in the following ways:

o Use the sum function to find the total number of gifts and the total value of the gifts.

o Use the average function to find the average number of gifts per person and the

average value of the gifts per person.

o Use a formula to find the average cost per gift for Mom. Then, use the fill handle to fill

in that formula for the remaining friends and family.

o Use a formula to find the percentage of monthly income Mom spent on the gift. Then,

use the fill handle to fill in that formula for the remaining friends and family.

o Use a formula to find the number of days, early or late, Mom presented her gift. Then,

use the fill handle to fill in that formula for the remaining friends and family.

o Format the total value of gifts, average cost per gift, and monthly income columns as

currency.

o Format the % of monthly income spent on gifts column as percentages.

o Create at least one chart to illustrate your analysis.

• Submit the spreadsheet as an attachment with the answer to the following question as a

post of 100 to 350 words: Based on the information in this spreadsheet, which of your

friends or family do you think loves you the most? Use the data to justify your answer.

..........................................................................................................................................

CIS 105 Assignment...

- CIS 105 UOP Course Tutorial / tutorialrank
- CIS 105 Uop Course Tutorial / Tutorialrank
- CIS 105 UOP Course Tutorial / Tutorialrank
- CIS 105 UOP Course Tutorial / tutorialrank
- CIS 105 UOP Course Tutorial/TutorialRank
- CIS 105 uop Course/ Tutorialrank
- CIS 105 UOP Course Tutorial/Shoptutorial
- CIS 105 UOP Course Tutorial/ uophelp
- CIS 105 UOP Course Tutorial / Uoptutorial
- CIS 105 UOP Course Tutorial / Uoptutorial