- Excel basics (1)
- Creating formulae (5)
- Formatting worksheets (9)
- Basic printing (8)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (17)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (6)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)
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.
You can learn how to do this exercise if you attend the course listed below!
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:
The worksheet before the borderlines and shading are added
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:
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
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:
Much better than the original plain worksheet!
Use File Save As... to save the workbook with the new name:
Formatted Interview Data