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

Making simple formatting changes to a list of enquiries and complaints

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.

Make the following formatting changes:

Insert a few extra blank rows at the top and then type in the new title shown below
Format the font, size and colour of the title and add underlining

The new title at the top of the worksheet.

Now apply the following formatting to the column titles row:

Change the font and colour of the titles on row 4
Increase the row height of row 4 and make it top aligned

Here's what the row should look like before you change the vertical alignment:

Row 4 before the alignment changes

And here's what it should look like after this:

Row 4 after the alignment changes.

Make the following additionalc changes:

Make everything in the Call ID and the Date columns centre aligned.
Select the whole of column D (click on the column letter) and add text wrap so that you can see all of the longer text entries.

You can now see all of the entries in the Description column.

We haven't finished yet!

Click in the middle of the worksheet and press CTRL + A to select it all, then add borderlines everywhere (apart from on the title at the top)
Add light yellow shading to the titles on row 4 so that they look similar to this: