This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Excel (113 exercises)
Topic ==>	Formatting worksheets (6 exercises)
Level ==>	Relatively easy
Subject ==>	Excel training

Apply some simple formatting changes to an Excel worksheet fo interview data

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.

Before you can do this exercise, you'll need to download and unzip this file .

Open the workbook contained in the folder shown above.

The initial worksheet without formatting.

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:
Looking better already

Now apply these additional changes:

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: