Step by step exercise. Format cell fonts.
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.
We are going to change some of the aspects of the title font:
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.
Observe this effect in the Preview box.
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).
We will now try and affect the same changes as before but using the toolbar.
11 Select cell G4.
12 Click on the arrow to the right of the button of the toolbar.
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 button on the toolbar.
15 Select size 12.
16 Click on the arrow to the right of the button on the toolbar.
17 Select Blue.
Lets try some other font options.
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.
We will now make the same changes as before but using the toolbar.
24 Select the range B4:F4.
25 Click on the button on the toolbar.
If we realise now that we do not want the range A5:A12 in bold:
26 Select the range A5:A12.
27 Click on the button on the toolbar - it also severs to deactivate the option.
Instead of using the button on the toolbar, we could have selected the Normal option from the Style box in the Cell Formats... box.
We will remove the colour from cell A1.
28 Select cell A1.
29 Clic on the arrow of the of the toolbar.
30 Select Automatic.
Lets try some more options.
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.
We are going to perform the same operation now using the toolbar.
37 Select cell A1.
38 Click on the button on the toolbar.
39 Click again on the button on the toolbar to deactivate it. This button acts as the bold button.
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.
Observe the result.
47 Select cell A2.
48 Clic on the button of the toolbar.
Observe the result of the operation. With the button we can only put a simple underline. It also serves to remove the bold and cursive buttons.
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.