Page 109 - Excle-En-V3

Figure 152: Choosing the LOWER function

- Click on the arrow that appears, then choose the first name (MOHAMED), then
click Enter on the keyboard, then OK.

You will notice that all lowercase letters are converted to uppercase letters, as
shown in the following figure:

Figure 153: The result of the LOWER function

Round:

The ROUND function rounds a number to a specified number of decimal places.
This is calculated by following these steps:

Click the cell in which you want to show the result and then click the function
key (fx) on the formula bar, to directly bring up the Math Function dialog box. Select
the "Round" function, then click (OK), then select the cell containing the number in
the Number box and the number of decimal places to which it will be rounded in the
Num_digits box, then click OK again.

Figure 154: Round Function

101 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024