Division of Business and Information Management,
Bristol Community College

Excel-HW-2: Excel Text Formatting

Description

The purpose of this assignment is to experiment with Microsoft Excel text formatting options.

Instructions

1. Download file hw_excel_L02P23.xls and open it in Microsoft Excel.

2. While working with Excel, save your document often. Give it a descriptive name, for example, "InvoiceSample.xls".

3. Change formats of every cell that contains a date to the format type March 14, 2008.

4. Modify text colors and cell background colors on every distinct part of the sample invoice. At a minimum, you should alter the colors of address, detail section, and the invoice dollar amount.

5. Modify fonts, font sizes, and styles used by the title, the text labels, and the data. There are no restrictions on any of your text appearance options, except that when the invoice is printed, it should fit on a single sheet of a Letter-size paper.

   Hint: use Print Preview function to make sure that your document fits on a single page.

6. When you are done, save the document, close it, and exit Excel.

7. Submit your Excel document via e-mail attachment sent to:
   Igor Kholodov Igor.Kholodov@bristolcc.edu