15x Formatting

1. Open a new Excel book and type in the following data:



2. Use the font style icons on the formatting toolbar to:


1. set the table headings in bold



2. set the highest salesperson's name and figures (row 4) in italics



3. underline the table headings

The table should look like this:



3. Use the centre align icon to centre the:


1. table headings



2. the sales and commission figures

The table should look like this:



4. Use the Currency icon to show the sales and commission figures in pounds and pence.
   
   The table should look like this:



5. Add colour to the table as follows:


1. set Raj in red text



2. highlight Raj's sales and commission figures in yellow

The table should look like this:



6. If you want to, save the spreadsheet in your folder with the name 'Formatted Table'.



7. Close Excel.

Back to Word Home Page