Overview of Excel Tables

http://www.techrepublic.com/blog/10-things/10-reasons-to-use-excels-table-object/

http://office.microsoft.com/en-us/excel-help/overview-of-excel-tables-HA010342749.aspx?CTT=1

 Sorting and filtering Filter drop-down lists are automatically added in the header row of a table. You can sort tables in ascending or descending order or by color, or you can create a custom sort order. You can filter tables to show only the data that meets the criteria that you specify, or you can filter by color.

 Formatting table data You can quickly format table data by applying a predefined or custom table style. You can also choose Table Styles options to display a table with or without a header or a totals row, to apply row or column banding to make a table easier to read, or to distinguish between the first or last columns and other columns in the table.

 Inserting and deleting table rows and columns You can use one of several ways to add rows and columns to a table. You can quickly add a blank row at the end of the table, include adjacent worksheet rows or worksheet columns in the table, or insert table rows and table columns anywhere that you want. You can delete rows and columns as needed. You can also quickly remove rows that contain duplicate data from a table.

 Using a calculated column To use a single formula that adjusts for each row in a table, you can create a calculated column. A calculated column automatically expands to include additional rows so that the formula is immediately extended to those rows.

 Displaying and calculating table data totals You can quickly total the data in a table by displaying a totals row at the end of the table and then using the functions that are provided in drop-down lists for each totals row cell.

 Using structured references Instead of using cell references, such as A1 and R1C1, you can use structured references that reference table names in a formula.

<ACTIVITY>

Perform each above feature on the customers worksheet

<ACTIVITY>