Question

Write outputs of the following:
1. INT(501.69)
2. POWER(4,3)
3. LEN(“Welcome to Excel”)
4. MOD(15,4)
5. SQRT(49)

Answer 1

Answer:

1. 501
2. 64
3. 16
4. 3
5. 7

Step-by-step explanation:

1. Int returns the answer in integer form without any decimal.
2. power function in this case took 4 raised to 3 as input and hence the answer 64.
3. len function calculates the number of characters including spaces.
4. mod function returns the remainder after performing division of two numbers. In this case 15 divided by 4 gives 3 as remainder.
5. sqrt function finds the square root of a number.