CIS 105 All Assignments CIS 105 All Assignments | Page 22

CheckPoint: Formatting Excel Spreadsheets
· Resource: Ch. 8 (pp. 308-311) in Computing Fundamentals, the Computer Applications
Tutorial and Appendix D
· Due Date: Day 4 [Individual forum]
· Refer to Ch. 8 (pp. 308-311) in Computing Fundamentals.
· Review the Excel portion of the Computer Applications Tutorial and explore the spreadsheet
program
on your computer.
· 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.