Page 55 - modular4.0
P. 55
Chapter Profile
4. Which mathematical function is used to find the remainder after a number is divided by the divisor?
a. REM b. SQRT
c. MOD d. ABS
5. What is the output of = average(3,6,3)?
a. 12 b. 3
c. 4 d. 1.2
B. Fill in the blanks using the words given below:
Arguments, parenthesis, mixed, range
1. Function must be followed by opening and closing .
2. A group of selected cells is called a .
3. are input to the functions.
4. $A6 is an example of referencing.
C. Write ‘T’ for true and ‘F’ for false.
1. Cell references are not helpful when you create complex formulas.
2. A mixed reference is basically a combination of relative and absolute references.
3. It is not possible to create references to cells in other worksheets within the
same workbook.
4. =Join(text1,text2) is used to concatenate two different text strings.
D. Short answer type questions.
1. What is the output of =LEFT(“ORANGE”,4)?
2. What are the two ways to enter a formula in a worksheet?
3. Which formula is used to obtain the output 46 for the input =INT(45.789)?
E. Long answer type questions.
1. What are the three elements of a formula?
2. What is the purpose of IF function?
Formulas and Functions 53

