Formatting Excel Spreadsheets

    0
    Review the Excel portion of the Computer Applications Tutorial athttp:corptrain.phoenix.edu/office_tools/ 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:
    • Use at least two different font sizes.
    • Change the font.
    • Use at least one font style such as bold, italics, and underline.
    • Apply color to at least one set of text.
    • Apply a fill color to at least one set of cells.
    • Apply a border to at least one group of cells.
    • Format all cells with dollar amounts as currency.
    • 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.
    • Format all of the cells with dates as xx/xx/xxxx or mm/dd/yyyy
    Submit the spreadsheet as an attachment with the answers to the following questions as a post of 50 to 100 words:
    • What did you like about Excel? • What seemed frustrating? • What did you not understand?
    Note for Excel 2010 Users: The following tutorials are available from Microsoft:
    …….
    …..

                                                                                                                                      Order Now