< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
CheckPoint Formatting Excel Spreadsheets
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Review the Excel portion of the Computer Applications Tutorial athttp:
corptrain.phoenix.edu/office_tools/ and explore the spreadsheet program on your computer.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Use the information available in Appendix D to format a Microsoft® Excel data set. The scenario for this data set is as follows:
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
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:
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Use at least two different font sizes.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Change the font.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Use at least one font style such as bold, italics, and underline.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Apply color to at least one set of text.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Apply a fill color to at least one set of cells.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Apply a border to at least one group of cells.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Format all cells with dollar amounts as currency.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• 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.
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• Format all of the cells with dates as xx/xx/xxxx or mm/dd/yyyy
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Submit the spreadsheet as an attachment with the answers to the following questions as a post of 50 to 100 words:
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
• What did you like about Excel? • What seemed frustrating? • What did you not understand?
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Note for Excel 2010 Users: The following tutorials are available from Microsoft:
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Get to Know Excel 2010: Create your first spreadsheet
http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-your-first-spreadsheet-RZ101773335.aspx
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
Get to Know Excel 2010: Create Formulas
http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-formulas-RZ101862712.aspx
< pstyle=" font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; margin-bottom: 10px;">
How to create a basic chart in Excel
http://office.microsoft.com/en-us/excel-help/how-to-create-a-basic-chart-in-excel-2010-RZ102559017.aspx
