Excel | Formatting worksheets exercise | Formatting in Excel - INterviews

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Excel  (151 exercises)
Version ==> Excel 2016 and later
Topic ==> Formatting worksheets  (9 exercises)
Level ==> Relatively easy
Subject ==> Excel training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the workbook contained in the folder shown above.

Make the following formatting changes:

  • Press CTRL + A to select the whole table and add borderlines
  • Select just the titles on row 1 and add shading as shown below:
Original worksheet

The worksheet before the borderlines and shading are added

With borderlines and shading

Looking better already!


  • Change the column width of column F and centre everything in this column

  • Select all of column E (click on the column letter) and add wordwrap so that you can see all the longer text entries in this column

  • Make column D wide enough to fit the longest text (double-click the column width icon on the line to the right of column D)

Columns D, E and F should now look much better:

The columns with better wdiths

You can now see all the text in columns D and E


  • Insert 3 new rows at the top of the worksheet and add the title shown below
  • Change the font, colour and size of the title and add underlining
The new title

Feel free to choose a more exciting font and colour!

  • Change the colour and font size of all the titles on row 4 to enhance them so that your worksheet now looks something like this:
Finished workbook

Much better than the original plain worksheet!

Use File  Save As...  to save the workbook with the new name:

Formatted Interview Data 

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post