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 .