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