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

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
www.cis105mentor.com
CheckPoint: Formatting Excel Spreadsheets
· Resource: Ch. 8 (pp. 308-311) in Computing Fundamentals, the
Computer Applications