Exercise (Sort and Format a Table)

  • Create a new word processing file.
  • Click Table on the Menu bar. Choose Insert Table.
  • In the Number of columns box enter 4.
  • In the Number of rows box enter 19.
  • Click the OK button.
  • Enter the following information into the table:
Expenses YTD 1999 1998
Property taxes $1785.20 $2103.79 $2458.75
Interest and bank charges $1901.23 $2300.78 $2158.45
Advertising & promotion $458.12 $584.12 $512.49
Operating supplies $406.15 $784.52 $632.72
Utilities $4912.35 $5213.73 $5618.75
Amortization $4607.12 $5231.72 $3892.12
Interest - long term $0.00 $0.00 $0.00
Travel and meals $3041.51 $2857.89 $2587.90
Repairs & maintenance $3578.45 $3810.78 $3678.12
Rent $9145.78 $9900.12 $9700.96
Professional fees $478.78 $303.78 $567.90
Licences, fees and dues $3200.78 $3400.78 $3300.85
Laundry & uniforms $710.45 $645.89 $730.73
Janitorial $1032.78 $1300.85 $1400.00
Insurance $3200.52 $3850.20 $3720.89
Automotive $458.23 $895.75 $745.69
Wages and benefits $7784.12 $8025.12 $8274.32
Office $3041.51 $2857.89 $2587.90
  • Add a row at the bottom of the table. (To add a row at the bottom of the table you can simply click the very last cell in the table and then press the Tab key once.)
  • Type Telephone in column A.
    $1258.45 in column B.
    $1378.71 in column C.
    $1273.79 in column D.
  • Delete the row that starts with Interest – long term.
  • Insert a column between columns A and B. (Expenses and YTD.)
  • Add the title Source to the first row of the new column. Add the word PL to the remaining cells in the column.
  • Select the entire table.
  • Click Table on the Menu bar. Choose Cell Height and Width.
  • Click the Column tab.
  • Click the AutoFit button.
  • Click Table on the Menu bar. Choose Sort.
  • Sort the table by Expenses in ascending order.
  • Click the Header row button under My list has field.
  • Click Table on the Menu bar. Choose Table AutoFormat.
  • Click the Classic 2 option from the Formats list box.
  • Click the OK button.
  • Take a look at your table. It is now sorted by Expenses (1st column) in ascending order.
  • Save your file.
  • Your table should look something like this:
Expenses Source YTD 1999 1998
Advertising & promotion PL $458.12 $584.12 $512.49
Amortization PL $4607.12 $5231.72 $3892.12
Automotive PL $458.23 $895.75 $745.69
Insurance PL $3200.52 $3850.20 $3720.89
Interest and bank charges PL $1901.23 $2300.78 $2158.45
Janitorial PL $1032.78 $1300.85 $1400.00
Laundry & uniforms PL $710.45 $645.89 $730.73
Licences, fees and dues PL $3200.78 $3400.78 $3300.85
Office PL $3041.51 $2857.89 $2587.90
Operating supplies PL $406.15 $784.52 $632.72
Professional fees PL $478.78 $303.78 $567.90
Property taxes PL $1785.20 $2103.79 $2458.75
Rent PL $9145.78 $9900.12 $9700.96
Repairs & maintenance PL $3578.45 $3810.78 $3678.12
Telephone PL $1258.45 $1378.71 $1273.79
Travel and meals PL $3041.51 $2857.89 $2587.90
Utilities PL $4912.35 $5213.73 $5618.75
Wages and benefits PL $7784.12 $8025.12 $8274.32

Click any where inside your table.
Click Table on the Menu bar. Choose Table AutoFormat.
Click the Contemporary option from the Formats list box.
Click the OK button.
Now, your table has a new look:

Expenses Source YTD 1999 1998
Advertising & promotion PL $458.12 $584.12 $512.49
Amortization PL $4607.12 $5231.72 $3892.12
Automotive PL $458.23 $895.75 $745.69
Insurance PL $3200.52 $3850.20 $3720.89
Interest and bank charges PL $1901.23 $2300.78 $2158.45
Janitorial PL $1032.78 $1300.85 $1400.00
Laundry & uniforms PL $710.45 $645.89 $730.73
Licences, fees and dues PL $3200.78 $3400.78 $3300.85
Office PL $3041.51 $2857.89 $2587.90
Operating supplies PL $406.15 $784.52 $632.72
Professional fees PL $478.78 $303.78 $567.90
Property taxes PL $1785.20 $2103.79 $2458.75
Rent PL $9145.78 $9900.12 $9700.96
Repairs & maintenance PL $3578.45 $3810.78 $3678.12
Telephone PL $1258.45 $1378.71 $1273.79
Travel and meals PL $3041.51 $2857.89 $2587.90
Utilities PL $4912.35 $5213.73 $5618.75
Wages and benefits PL $7784.12 $8025.12 $8274.32

Back Index Next