Page 34 - TP_V5.1_C7_fb
P. 34
d. A __________ is a predefined formula in Excel.
e. The __________ function is used to get the length of the string.
3. Think and answer.
a. What are Mathematical functions? Write any two functions.
______________________________________________________________________________________
______________________________________________________________________________________
b. What is the use of IF(condition, value1, value2) function? Explain with example.
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
c. What is the use of the CONCATENATE() function? Explain with an example.
______________________________________________________________________________________
______________________________________________________________________________________
d. What are the rules to enter a function?
______________________________________________________________________________________
______________________________________________________________________________________
e. Explain the meaning of #NAME?, #REF! and #NUM! errors in Excel.
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
4. Define the following functions:
a. INT(number) __________________________________________________________________________
b. TODAY() __________________________________________________________________________
c. LEN() __________________________________________________________________________
d. SQRT __________________________________________________________________________
e. MOD __________________________________________________________________________
5. Differentiate between the following:
LEFT(text, num_chars) and RIGHT(text, num_chars) MAX(range) and MIN(range)
_____________________________________________ __________________________________
_____________________________________________ __________________________________
32 Premium Edition-VII

