CIS 105 MENTOR It's Your Life/cis105mentor.com CIS 105 MENTOR It's Your Life/cis105mentor.com | Page 24

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