|
Step by step exercise. Format cell fonts. |
|
Objective |
|
Differentiate between, and use the various options to change the aspect of the font available in Excel2003.
|
| Step by step exercise |
|
1 If Excel2003 is not open, open it in order to perform the exercise. 2 Open the Fruit sales workbook found in the Exercises folder of the course. 3 Select the range A1:A2 . Even though the text of cell A1 occupies also cells B1, C1, D1 and so on, it is not necessary to select them as we are going to change the type of letter, and this is found only in cell A1. 4 Go to the Format menu. 5 Select the Cells... option. 6 Click on the Font tab. 7 In the Font box is indicated the type of letter used in the selected cells, clic on the arrow below the list of possible fonts until Times New Roman, and then click on this to select it. 8 Select 14 in the Size option to make the letters bigger. 9 Clic on the arrow in the Color option to open the list, and select Red. 10 Clic on the Accept button. Observe the result (check the results now like the colour change, it is necessary to select another cell so that the change can be seen). 11 Select cell G4.
12 Click on the arrow to the right of the A list of fonts is opened. 13 Select the Comic Sans MS font, if not availible select another. 14 Click on the arrow to the right of the 15 Select size 12. 16 Click on the arrow to the right of the 17 Select Blue. 18 Select the range A5:A14. 19 Go to the Format menu. 20 Select the Cells... option. 21 If we are not in the Font tab, click on this to select it.
22 In the Style box, select the Bold option. 23 Click on OK. 24 Select the range B4:F4. 25 Click on the 26 Select the range A5:A12. 27 Click on the Instead of using the button on the toolbar, we could have selected the Normal option from the Style box in the Cell Formats... box.
28 Select cell A1. 29 Clic on the arrow of the 30 Select Automatic. 31 Select cell A2. 32 Go to the Format menu. 33 Select the Cells... option. 34 If you are not in the Font tab, click on it to activate it. 35 Select Cursive in the Style box. 36 Click on OK. Observe the result. 37 Select cell A1. 38 Click on the 39 Click again on the 40 Select cell A1, if you have not already. 41 Go to the Format menu. 42 Select the Cells... option. 43 If we are not inside Font, click on it to activate. 44 In the Underline box click on the arrow to open the list of underlines. 45 Select the Double option. 46 Clic on OK. 47 Select cell A2. 48 Clic on the
49 Save the workbook with the same name. 50 Close the workbook.
|
|
Legal
warning: Authorised on-line use only. It is not allowed the use
of these courses in companies or private teaching centres.
|