Step by step exercise. Spelling Correction.


Objective.

 

Practice the different spelling options available in Excel2003.

Step by step exercise.

 

1 If you do not have Excel open yet, open it in order to perform the exercise.

2 Start a new workbook.

 

We will start by testing the Autocorrection.

3 Intoduce the text ALso into cell A1, writing the first two letters in uppercase and the rest in lowercase.

Observe how Excel automatically changes the second letter to lowercase (note: the value needs to be introduced, that is, after writing it you need to press ENTER to check it).

This is due to the fact that in the Autocorrect box the COrrect TWo INicial CApitals is activated. To check this:

4 Go to the Tools menu.

5 Select the Autocorrect... options.

Observe that the option is activated.

6 Click on the Correct TWo INicial CApitals box to deactivate it.

7 Click on OK.

8 Write ALso again in cell A2.

Observe how the second letter has not been changed but remains in capitals.

9 Introduce the text we will start the sentence. now in cell A3.

Observe how the first letter is not changed to capitals while in the second phrase Now has. This is due to the Capital first letter of sentences box in the Autocorrect box. But Excel2003 only recognises a sentense after a full stop.

10 Go to the Edit menu.

11 Select the Autocorrect options... option.

12 Activate the Correct TWo INicial CApitals box again.

13 Click on OK.

14 Activate the Caps Lock key on the keyboard.

15 Write the following text ignoring the Uppercase button of being activated, Scarab.

Before enterring the value, notice how the first letter is in lowercase while the rest of the word is in capitals, due to the Caps Lock being activated (the final result must look like this: sCARAB).

16 Press ENTER to introduce the value.

Observe the change in text, and how the Caps lock is now deactivated. This is due to the fact that the Correct accidental use of cAPS LOCK key is activated in the Autocorrect box.

17 Write (c) in cell A7.

Observe how when we introduce the (c) value it changes to a copyright symbol, to see the cause:

18 Go to the Tools menu, and then the Autocorrect options... option.

19 Check that the Replace text as you type box is activated, and that in the list of text to replace the (c) is found for the copyright symbol.

20 Click on OK.

 

We will now try the spelling correction.

21 Delete everything that is written in the worksheet.

22 Write the text: This is a speling tist in cell A1. (be sure to copy the spelling mistakes)

23 Write It is verry importint to check the spelling before handing in the wurk in cell A3.

 

We will now go to spelling correction.

24 Situate yourself in the first cell of the worksheet, that is, cell A1.

25 Go to Tools.

26 Select the Spelling... option.

A dialog box will appear to correct the first mistake found.

27 We are told that the word speling is not found in the dictionary, and in the part below we see a list of suggestions. We need to select the adequate correction, that is, spelling.

28 Next, click on the Change all button so that each time the word speling is found it will be substituted with spelling.

 

It will automatically go to the next mistake, tist.

29 Select the word test and click on Change all.

30 The next mistake verry we substitute for very.

31 Then we change importint for important.

32 And to end we change wurk for work.

33 Depending on which cells we start the revision from, it is possible that when we reach the end of the sheet Excel asks us if we want to continue the correction from the beginning, and in this case we click on the Yes button.

34 And finally we will be advised that we have reached the end of our correction, and we click on OK.

35 Close the workbook without saving the changes performed.



 
 
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.