CIS 105 MENTOR Career Begins/cis105mentor.com CIS 105 MENTOR Career Begins/cis105mentor.com | Page 23

CIS 105 Week 6 Checkpoint Formatting Excel Spreadsheets FOR MORE CLASSES VISIT www . cis105mentor . com
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 Week 6 Checkpoint Formatting Excel Spreadsheets FOR MORE CLASSES VISIT www . cis105mentor . com

CheckPoint : Formatting Excel Spreadsheets
· Resource : Ch . 8 ( pp . 308-311 ) in Computing Fundamentals , the Computer Applications
Tutorial and Appendix D
· Due Date : Day 4 [ Individual forum ]
· Refer to Ch . 8 ( pp . 308-311 ) in Computing Fundamentals .