# CIS 105 Uop courses/Uophelp

## CIS 105 Uop courses/Uophelp

• Submitted By: nhnhg21
• Date Submitted: 03/23/2015 11:55 PM
• Category: Book Reports
• Words: 486
• Page: 2
• Views: 1

CIS 105 Assignment Manipulating Data in Excel Spreadsheets

For more course tutorials visit
www.uophelp.com

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 justi

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

CIS 105 Capstone Discussion Question

For more course tutorials visit
www.uophelp.com

Capstone Discussion Question
• Due Date: Day 3...