CIS 105 help Making Decisions/uophelp.com CIS 105 help Making Decisions/uophelp.com

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