CIS 105 help Making Decisions/uophelp.com CIS 105 help Making Decisions/uophelp.com | Page 11

· Use the information available in Appendix D to format a Microsoft®
Excel data set. The
scenario for this data set is as follows:
You just had a birthday a couple of weeks ago and you were somewhat
surprised by
some of the presents you received, pleasantly in several cases and
unpleasantly in
others. On a whim, you lightheartedly decide to find out who loves you
the most based
upon the gifts you were given. You use a spreadsheet to analyze the
information. For this
CheckPoint, you refine the spreadsheet, manipulating the document in
the following
ways:
o Use at least two different font sizes.
o Change the font.
o Use at least one font style such as bold, italics, and underline.
o Apply color to at least one set of text.
o Apply a fill color to at least one set of cells.
o Apply a border to at least one group of cells.
o Format all cells with dollar amounts as currency.
o Use the fill handle to fill in the remaining cells in the Birthday column.
Note: The fill
sequences the dates, so you need to choose the option to copy cells.
o Format all of the cells with dates as xx/xx/xxxx.
· Submit the spreadsheet as an attachment with the answers to the
following questions as
a post of 50 to 100 words: