CIS 105 All Assignments CIS 105 All Assignments | Page 21

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.
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
Click Below Link To Purchase
www.foxtutor.com/product/cis-105-week-6-checkpoint-formatting-
excel-spreadsheets