Page 33 - Viva ICSE Computer Studies 8 : E-book

Step 5

5. The ‘Function Arguments’ dialog
box will appear. Type the cell
address in the respective text
boxes.
6. Click on the OK button. The result
will appear in the ‘cell A5’.

Step 6
GCD

GCD function calculates the greatest common divisor of two or more integers.

Follow these steps to use the GCD function.
1. Enter four numbers in the cells ‘A1, A2, A3 and A4’.

2. Click on the cell A5 where GCD of all the numbers will be displayed.
3. Click on the Math & Trig function on the ‘Function Library’ group of the ‘Formulas’ tab.
4. Select GCD from the drop-down list.

Step 3

Step 1

Step 4
Step 2

Step 5
5. The ‘Function Arguments’ dialog
box will appear. Type the cell
address in the respective text
boxes. Click on the OK button.
6. The result will appear in ‘cell A5’.

Step 6

21