CBSE Class 10 Computer Science Function in Calc MCQs

1. After name of the function, value provided in bracket is known ........

(A) variables of function region (B) cells of function region

(C) prefix of function region (D) arguments of the function

2. ........ can be given as the argument of the function.

(A) Cell address (B) Cell range (C) Constant value (D) Any of these

3. ........separator can be used for cell addre

(A) , (Comma) (B) ; (Semi colon) (C) : (Colon) (D) Any of these

4. Where you will find the result of the function?

(A) Title bar (B) Menu bar (C) Formula bar (D) Task bar

5. The cell mentioned in formula is displayed with........color.

(A) red (B) blue (C) green (D) yellow

6. The method for inclusion of formula is always

(A) similar (B) different (C) can't say (D) none of these

7. ........is compulsory for function.

(A) Variable of function (Argument) (B) Correct spelling of function

(C) Both (A) and (B) (D) None of these

8. Due to ........functions results into an err

(A) Spelling mistake in the name of the function (B) Not giving necessary variable for function

(C) Both (A) and (B) (D) None of these

9. Arrange the steps in ascending order for entering the function.

(1) Start the content with = sign (2) press enter key

(3) Enter the name of the function (4) Select the cell where function is to be entered.

(5) enter the variable of the function

(A) 4, 3, 1, 5, 2 (B) 4, 1, 3, 2, 5 (C) 4, 1, 5, 3, 2 (D) 4, 1, 3, 5, 2

10. .........option shows operator sign.

(A) + (B) * (C) % (D) #

11.When = sign is used ?

(A) In the beginning for entering variable (B) At the end of the variable

(C) In the beginning of entering the function (D) At the end of the function

12.For what Function Wizard is used?

(A) It is not possible to keep all the icons of the functions in the bar

(B) It is difficult to remember all the functions with their syntaxes

(C) Both (A) and (B) (D) None of these

13. Function wizard tool is displayed on........b

(A) Standard bar (B) Formula bar (C) Formatting bar (D) Status bar

14. ........is the shortcut key to open the function wizard.

(A) Ctrl + F2 (B) Shift + F2 (C) Alt + F2 (D) Ctrl + Alt + F2

15. ........is useful to open function wizard.

(A) View --» Function (B) View --» Function Wizard

(C) Insert --» Function (D) Insert --» Function Wizard

16. How many types of categories are there for the functions?

(A) 10 (B) 11 (C) 12 (D) 13

17. ........is the category for the function.

(A) Database, Time & Date, Financial, Information (B) Logical, Mathematical, Array, Statistical

(C) Spreadsheet, Text, Add-in (D) All of these

18. In sum function, maximum how many variable, values or Cell addresses can be given?

(A) 10 (B) 20 (C) 30 (D) 40

19. Which button is clicked to select values in function wizard dialog box?

(A) Select (B) Add (C) Value (D) Number

20. Which area is displayed by clicking on 1 select button of the function wizard?

(A) Area of function (B) Area of table (C) Area of worksheet (D) Area of menu

21. By clicking on which button of function wizard, the whole dialog box is converted into the small rectangle toolbar

(A) Select (B) Category (C) Formula (D) Array

22. The functions included in the categories of the calc are known .........

(A) Built-internal functions (B) Built-in functions

(C) Built-base functions (D) Built-inner functions

23. LN(8) gives the answer of.........

(A) log8e (B) loge8 (C) logn8 (D) log8n

24. LN(8) results to .........

(A) 2.0794415417 (B) 3.0794415417 (C) 4.0794415417 (D) 5.0794415417

25. LOG10 is ........ type of function.

(A) string (B) mathematical (C) logical (D) statistical

26. ........is the syntax for LOG10.

(A) =LOG10(n) (B) =LOG10(-n) (C) =LOG10(n,p) (D) =LOG10(n,x)

27. In LOGlO(n) , n displays .........

(A) negative number (B) positive number (C) (A) or (B) (D) none of these

28. ........is the syntax of POWER function.

(A) =POWER (n) (B) =POWER(-n) (C) =POWER(n, p) (D) =POWER(p)

29. In POWER (n;p), n suggests .........

(A) number (B) exponent (C) (A) or (B) (D) none of these

30. In POWER (n,p), p suggests .........

(A) number (B) exponent (C) (A) or (B) (D) none of these

31. ........function is used to find out the exponent value of the numb

(A) POWER (B) PRODUCT (C) SQRT (D) ODD

32. POWER means .........

(A) square (B) square root (C) multiplication (D) exponent

33. =POWER(10,3) results to .........

(A) 10 (B) 100 (C) 1000 (D) 10000

34. PRODUCT function h.......syntax.

(A) =PRODUCT(n1,n2,n3,..........n30) (B) =PRODUCT(n1,n2,n3,..........n) (C) =PRODUCT(n) (D) =PRODUCT(n,p)

35. Maximu.......number of values can be multiplied using PRODUCT function.

(A) 10 (B) 20 (C) 30 (D) Infinite

36. SQRT, INT, PRODUCT, POWER, ROUND are ........type of function.

(A) string (B) mathematical (C) logical (D) statistical

43. What does n suggest in =ROUND(n,p) ?

(A) different (B) similar (C) variation (D) can't say

47. =ROUNDUP(12.15652;2) results to .......

(A) 12.15 (B) 12.16 (C) 12.00 (D) 12

48. =ROUNDDOWN(12.15652;2) results to ..

(A) 12.15 (B) 12.16 (C) 12.00 (D) 12

49. TRUNC is ........ type of a function.

(A) string (B) mathematical (C) logical (D) statistical

50. ........is the syntax of TRUNC function.

(A) =TRUNC(n) (B) -TRUNC (-n) (C) =TRUNC(n,p) (D) =TRUNC(p)

51. In TRUNC (n,p), what does n suggest ?

(A) A word (B) A number (C) Number of decimal points (D) Format

52. In TRUNC(n,p) What does p suggest ?

(A) A word (B) A number (C) Number of decimal points (D) Format

53. TRUNC stands for .........

(A) Truncation (B) Truncate (C) Traction (D) Tractor

54. .......type of function is Average.

(A) Statistical (B) Financial (C) String (D) Logical

55. ........is the syntax of average function.

(A) =AVERAGE(n) (B) =AVERAGE(n,p) (C) =AVERAGE(n1, n2, n3,.... n30) (D) Any of these

56. AVERAGE is known ....... .

(A) Mean of arithmetic (B) Mean of Statistics (C) Mean of string (D) Average mean

57. How the average is achieved?

(A) Multiply all the values and divide by number of values

(B) Subtract all the values and divide by number of values

(C) Addition of all the values and divide by number of values

(D) Divide all the values and divide by number of values

58. Values are separated usin.......in AVERAGE function.

(A) ; (B) * (C) . (D) &

59. ........function is used to display most repetitive value

(A) AVERAGE (B) MIN (C) MEDIAN (D) MODE

60. =MODE(10;7;6;8;6;5) results to .........

(A) 10 (B) 8 (C) 6 (D) 5

61. What is mode?

(A) The most common value (B) Average of numbers

(C) Division value (D) Counted value

62. ........type of function is GEOMEAN.

(A) Statistical (B) Financial (C) String (D) Logical

63. ........ is the syntax for GEOMEAN function

(A) =GEOMEAN(n) (B) =GEOMEAN(n, p) (C) =GEOMEAN(n1, n2, n3 ..... n30) (D) Any of these

64. What is the meaning of GEOMEAN?

(A) Mode (B) Maximum (C) Geometric mean (D) Counted mean

65. Usin.......type of values geometric mean can be achieved using GEOMEAN function.

(A) Positive (B) Negative (C) (A) or (B) (D) None of these

66. ........root is extracted by multiplying n numbers in GEOMEAN function.

(A) nx (B) nz (C) nth (D) an

67. ........type of function is HARMEAN.

(A) Statistical (B) Financial (C) String (D) Logical

68. ........is the syntax of HARMEAN function.

(A) =HARMEAN (n) (B) =HAR (n, p) (C) =HARMEAN (n1, n2, n3, ....n30) (D) Any of these

69. HARMEAN stands f........

(A) Harmonic Mean (B) Harman Mean (C) Hardware Mean (D) Harford Mean

70. ........is the syntax of MEDIAN function.

(A) =MEDIAN(n) (B) =MEDIAN(n, p) (C) =MEDIAN(n1, n2, n3, ....n30) (D) Any of these

71. ........is used to get the middle value by arranging them either in ascending or descending order

(A) AVERAGE (B) MEDIAN (C) RANK (D) COUNTA

72. What is the meaning of MEDIAN function?

(A) Arrange the values and get the middle value (B) Maximum value

(C) Most common value (D) Counted value

73. MEDIAN function displays........value after arranging all value

(A) maximum (B) minimum (C) middle (D) any of these

74. If there are two middle values after arranging the numb.......is done in Median function.

(A) Average of first two numbers is taken

(B) Average value of two middle values is taken

(C) Average of last two numbers is taken

(D) Displays error message

75. COUNTA, MAX, MEDIAN, MODE, MIN are........type of function.

(A) Statistical (B) Financial (C) String (D) Logical

76. ........ is the syntax of COUNTA function.

(A) =COUNTA (n) (B) =COUNTA (n, p) (C) =COUNTA (n1, n2, n3,....n30) (D) Any of these

77. To display number of cells containing values ........function is used.

(A) AVERAGE (B) MEDIAN (C) RANK (D) COUNTA 

78. COUNTA function counts........types of c

(A) empty cells (B) cells having values

(C) both empty cells and cells having values (D) none of these

79. ........type of value can be there in a c

(A) Text (B) Number (C) Formula (D) All of these

80. COUNTA function does not consider the empty ce Choose the correct options.

(A) True (B) False (C) Can't say (D) None of these

81. =RANK(67;x;0), where values of x are 67, 47, 56, 78, 59, 66 then result will be .........

(A) 2 (B) 3 (C) 4 (D) 5

82. ........is the syntax for MAX function.

(A) =MAX(n) (B) =MAX(n, p) (C) =MAX(n1, n2, n3, ....n30) (D) =MAX(number; range; order)

83. ........function can simply return the maximum number within the argument

(A) LARGE (B) MAX (C) BIG (D) TOP

84. =MAX (67, 47, 56, 78, 59, 66) results to .........

(A) 47 (B) 56 (C) 66 (D) 78

85. ........is the syntax of MIN function.

(A) =MIN (n) (B) =MIN (n, p) (C) =MIN (n1, n2, n3, ....n30) (D) =MIN(number; range; order)

86. ........function can take up and simply return the minimum number within the arguments

(A) SMALL (B) MIN (C) SMALLER (D) DOWN

87. MIN stands for .........

(A) Minimum (B) Minima (C) Minimal (D) Minimums

88. ........shows the relational operatoin

(A) AND, OR, NOT (B) =, >, <, >=, <=, < > (C) IS, LIKE, BETWEEN (D) All of these

89. What does Relational operator = suggest?

(A) One operand is smaller than second operand. (B) One operand is bigger than second operand.

(C) Both operands are different. (D) Both operands are same.

90. What does Relational operator < suggest?

(A) One operand is smaller than second operand. (B) One operand is bigger than second operand.

(C) Both operands are different. (D) Both operands are same.

91. What does Relational operator > suggest?

(A) One operand is smaller than second operand. (B) One operand is bigger than second operand.

(C) Both operands are different. (D) Both operands are same.

92. What does Relational operator >= suggest?

(A) One operand is bigger than second operand or both operands are same.

(B) One operand is smaller than second operand or both operands are same.

(C) Both operands are different. (D) Both operands are same.

93. What does Relational operator <= suggest?

(A) One operand is bigger than second operand or both operands are same.

(B) One operand is smaller than second operand or both operands are same.

(C) Both operands are different. (D) Both operands are same.

94. What does Relational operator < > suggest?

(A) One operand is bigger than second operand or both operands are same.

(B) One operand is smaller than second operand or both operands are same.

(C) Both operands are different. (D) Both operands are same.

95. ........is the logical operator

(A) IF (B) TRUE, FALSE (C) AND, OR, NOT (D) All of these

96. ........type of function is

(A) Statistical (B) Financial (C) String (D) Logical

97. ........is the syntax of IF condition.

(A) =IF(TEST) (B) =IF("TRUE","FALSE")

(C) =IF(TEST,"TRUE","FALSE") (D) =IF(TEST, "FALSE", "TRUE")

98. ........function is used for logical proc

(A) MEDIAN (B) IF (C) AVERAGE (D) MODE

99. How many arguments are there in IF function?

(A) 2 (B) 3 (C) 4 (D) 5

100. ........is the argument of If function.

(A) TEST (B) TRUE (C) FALSE (D) All of these

101. One IF condition used within another IF condition is known ........

(A) Master IF (B) Secondary IF (C) Nested IF (D) Loop IF

102. ........is useful for not allowing the error to occur in a function.

(A) Function board (B) Function menu (C) Function view (D) Function wizard

103. ........is the main advantage of function wizard.

(A) We don't have to select the function (B) We don't have to type the correct name of function

(C) Values are not to be selected (D) All of these

104. If there is a mistake in the function wizard ........colored dots are displayed.

(A) green (B) red (C) blue (D) purple

105. TRUE, FALSE, NOT, AND, OR are ........ type of function.

(A) statistical (B) financial (C) string (D) logical

106. ........is the syntax of TRUE function.

(A) =TRUE () (B) =TRUE (TEST) (C) = ("TRUE", "FALSE") (D) = ("FALSE", "TRUE")

107. ........function displays TRUE as logical result of function.

(A) YES (B) OK (C) TRUE (D) FALSE

108. ........is the syntax of FALSE function.

(A) =FALSE () (B) =FALSE (TEST) (C) = ("TRUE", "FALSE")(D) = ("FALSE", "TRUE")

109. ........ is the syntax of NOT function.

(A) =NOT() (B) =NOT(TEST)

(C) =NOT("TRUE", "FALSE") (D) =NOT("FALSE", "TRUE")

110. ........function reverse the logical value

(A) AND (B) OR (C) IF (D) NOT

111. ........is the syntax of AND function.

(A) =AND() (B) =AND(TEST) (C) =AND(Condi1, Condi2, ..... Condi30) (D) =AND("FALSE", "TRUE")

112. AND function can compare maximum ........ result

(A) 10 (B) 20 (C) 30 (D) 40

113. ........ can be used to compare the result

(A) AND (B) NOT (C) IF (D) Any of these

114. AND function displays ........ as result.

(A) YES, NO (B) AND, OR, NOT (C) TRUE, FALSE (D) OK, CANCEL

115. The result displayed as TRUE and FALSE are known as ........ value

(A) boolean (B) binary (C) biometric (D) master

116. If all the results of conditions/arguments are True then what will be the result?

(A) TRUE (B) FALSE (C) (A) OR (B) (D) ERROR

117. If all the results of conditions/Arguments are False then what will be the result ?

(A) TRUE (B) FALSE (C) (A) OR (B) (D) ERROR

118. =AND(12=12, 12=6) will display........as result.

(A) TRUE (B) FALSE (C) YES (D) OK

119. ........ is the syntax of OR function.

(A) =OR() (B) =OR(TEST) (C) =OR (Condi1, Condi2, ..... Condi30) (D) =OR("FALSE", "TRUE")

120. ........is the case sensitive function.

(A) TRIM (B) CONCATENATE (C) EXACT (D) SMALL

121. EXACT function shows ........ as result.

(A) 0 (B) 1 (C) 0 or 1 (D) -1, 0 or 1

122. If two strings are same then EXACT function shows........ as result.

(A) 0 (B)  1 (C) -1 (D) Any of these

123. LEFT, RIGHT, MID, LEN is ........ type of function.

(A) Statistical function (B) String function  (C) Mathematical Function (D) Logical function

124. ........ is the syntax for LEFT function.

(A) =LEFT(text) (B) =LEFT(text, n)

(C) =LEFT(textl,text2,text3, .....) (D) =LEFT(t1, t2, ..... t30)

125. ........function returns the first character from the string text, or a specified number of n characters starting from the left.

(A) LEFT (B) EXTRACT (C) TRIM (D) LEFTSPACE

126. In =LEFT (text, n) ........is the optional part.

(A) text (B) n (C) both (A) and (B) (D) each part is compulsory

127. For =LEFT (text, n), if n is not provided then ........will be the result.

(A) displays first character from the left side (B) displays first word from the left side

(C) displays first division from the left side (D) gives error message

128. ........is the syntax for RIGHT function.

(A) =RIGHT(text) (B) =RIGHT(text, n) (C) =RIGHT(textl,text2,text3, .....) (D) =RIGHT(tl, t2, ..... t30)

129. ........ function returns the last n characters from the end (right side) of the string text.

(A) RIGHT (B) EXTRACT (C) TRIM (D) RIGHTSPACE

130. RIGHT function is used for .........

(A) compare the strings from the right side (B) remove the extra space from the right side

(C) get the characters from the right side of string  (D) change the right side characters of string

131. ........is the syntax for MID function.

(A) =MID(text) (B) =MID(text, start) (C) =MID(text, start, number) (D) =MID(tl, t2, ..... t30)

132. ........ function provides utility to find middle of a string

(A) RIGHT (B) MID (C) EXTRACT (D) SPACE

133. MID function is used fo........

(A) get the characters from the left side of string (B) get the characters from the right side of string

(C) get the characters from the center part of string (D) all of these

134. In =MID(text, start, number), what does start suggest ?

(A) Given string (B) Location from where the characters are to be extracted

(C) Value for how many characters to be extracted (D) Beginning characters of string

135. In =MID(text, start, number), what does number suggest

(A) Given string (B) Location from where the characters are to be extracted

(C) Value for how many characters to be extracted (D) Beginning characters of string

136. =MID("Tejas Thakkar",3,3) shows ...... as result.

(A) Tej (B) jas (C) Tha (D) kar

137. ........is the syntax for LEN function.

(A) =LEN(text) (B) =LEN(text, start (C) =LEN(text, start, number) (D) =LEN(tl, t2, ..... t30)

138. ........function returns the length of the given string including the white space

(A) LENGTH (B) LEN (C) COUNT (D) COUNTA

139. LEN function is used f........

(A) count characters with white space (B) count characters without white space

(C) count characters removing white space (D) display characters without white space

140. LEN function shows ........ as result.

(A) character (B) number (C) sign (D) any of these

141. =LEN("Good Morning") shows........as result

(A) 10 (B) 11 (C) 12 (D) 13

142. ........is the syntax for DATE function.

(A) =DATE() (B) =DATE(date) (C) =DATE(date,type) (D)=DATE(date,mode)

143. To display valid date as per given year, date and day........ function is used.

(A) DAY() (B) TODAY() (C) DATE() (D) WEEKDAY()

144. DATE function is used for.........

(A) display valid date as per given year (B) display valid date as per given date

(C) display valid date as per given date (D) display valid date as per given year, date and date

145. DATE function requires the value of year, date and day in........ format.

(A) integer (B) real value (C) decimal value (D) any of these

146. DAY, WEEKDAY, DATE, MONTH, YEAR, DAYSINYEAR, DAYS are ........ type of function.

(A) Statistical function (B) Date and Time(C) Mathematical function (D) Logical function

147. ........is the syntax for DAY function.

(A) =DAY() (B) =DAY(date) (C) =DAY(date,type) (D) =DAY(date,mode)

148. If only date is to be displayed from the date ……...function is used.

(A) WEEKDAY() (B) TODAY() (C) DATE() (D) DAY()

149. DAY function is for .........

(A) getting date only (B) getting month only

(C) getting year only (D) all of these

150. if the system date is 18/02/2014 then =DAY (TODAY ()) will give ........result.

(A) 18 (B) 02 (C) 2014 (D) 18/02/2014

151. =DAY(date((2014,2,18)) will give ........ as result.

(A) 2014 (B) 02 (C) 18 (D) 18/02/2014

152. ........is the syntax for WEEKDAY function.

(A) =WEEKDAY() (B) =WEEKDAY(date)

(C) =WEEKDAY(date, type) (D) =WEEKDAY(date, month, year)

153. Th....... function is used to convert a validate given into a day of the week.

(A) WEEKDAY() (B) TODAY() (C) DATE() (D) DAY()

154. WEEKDAY function is used to .........

(A) convert a valid date given into a day of the week (B) convert a valid date given into a number of the month

(C) convert a valid date given into a number of the year (D) any of these

155. If the system date is 18/02/2014 then, =WEEKDAY(TODAY()), will .......as result

(A)  3 (B) 2 (C) 1 (D) 0

156. For =WEEKDAY(date, type) if we take type=1 then days are taken as .........

(A) For Monday 0, Tuesday 1.......Sunday 6 (B) For Monday 1, Tuesday 2,......Sunday 7

(C) For Sunday 1, Monday 2, ......Sunday 7 (D) Any of these

157. ........ is the syntax for MONTH function.

(A) =MONTH() (B) =MONTH(date) (C) =MONTH(t) (D) =MONTH(date, month, year)

158. .......... is not enough for the real world application.

(A) Process of taking complex decisions (B) Analyzing a large amount of data

(C) Both (A) and (B) (D) Entering data and simple mathematical expressions

159. ........is done for the real world application.

(A) Process of taking complex decisions (B) Analyzing a large amount of data

(C) Both (A) and (B) (D) Entering data and simple mathematical expressions

160. ........ is used for process of taking complex decisions and analyzing a large amount of data

(A) Writer (B) Calc (C) Impress (D) Draw

161. ........types of functions are provided by c

(A) Mathematical, logical (B) Statistical, time & date (C) Financial, string (D) All of these

162. Functions start with........sign.

(A) = (B) & (C) @ (D) %

163. ........ is important to use a function.

(A) = sign (B) Name of function (C) Function variable in bracket (D) All of these

164. How many variables can be inserted in bracket of function ?

(A) Only one (B) Only two (C) One or more (D) Variable cannot be inserted

165. ........ operator is used with function a operator

(A) % (B) + (C) @ (D) #

166. ........is used to specify textual string

(A) = (B) % (C) # (D) @

167. ........ can be used as a variable for function

(A) Value, cell address (B) Text, constant value (C) One or more functions (D) All of these

168. ........function is used for addition.

(A) PLUS (B) SUM (C) ADD (D) JOIN

169. ........sign can be used for addition.

(A) £ (B) 3 (C) 6 (D) ¥

170. =SUM(A1:A10), where........is the prefix

(A)  = (B) SUM (C) A1 and A10 (D) :

171. Th....... function is used to convert a valid date given into a number of the month

(A) WEEKDAY() (B) MONTH() (C) DATE() (D) YEAR()

172. MONTH function is used for .........

(A) convert a valid date given into a day of the week.

(B) convert a valid date given into a number of the month

(C) convert a valid date given into a number of the year

(D) any of these

173. If system date is 18/02/2014 then = MONTH (NOW()) will give ........as result.

(A) 3 (B) 2 (C) 1 (D) 0

174. =MONTH(DATE(2014,2,18)) will give ........ as result.

(A) 3 (B) 2 (C) 1 (D) 0

175. ........ is the syntax for MONTH function.

(A) =YEAR() (B) =YEAR(date) (C) =YEAR(t) (D) =YEAR(date, month, year)

176. ........function is used to convert a valid date given into a number of the year

(A) WEEKDAY() (B) MONTH() (C) DATE() (D) YEAR()

177. ........is the syntax for DAYSINYEAR function.

(A) =DAYSINYEAR () (B) =DAYSINYEAR (date)

(C) =DAYSINYEAR(t) (D) =DAYSINYEAR (date, month, year)

178. The ........ function is used to convert a valid date given into number of days of that yea

(A) WEEKDAY() (B) DAYSINYEAR() (C) MONTH() (D) YEAR()

179. DAYSINYEAR function is used f........

(A) convert a valid date given into number of days of that year. (B) convert a valid date given into number of weeks of that year.

(C) convert a valid date given into number of years of that year. (D) any of these

180. ........function is used to check whether the year is a leap year or not.

(A) WEEKDAY() (B) DAYSINYEAR() (C) MONTH() (D) YEAR()

181. DAYS function has ........ synt

(A) = DAYSINYEAR () (B) = DAYSINYEAR (date2,date1)

(C) =DAYSINYEAR(t) (D) = DAYSINYEAR (date, month, year)

182. Th....... function calculates the number of days between two dates.

(A) WEEKDAY() (B) DAYSINYEAR() (C) MONTH() (D) DAYS()

183. DAYS() function is used for .........

(A) convert a valid date given into number of days of that year. (B) convert a valid date given into number of weeks of that year.

(C) convert a valid date given into number of years of that year. (D) calculate the number of days between two dates.

184. =DAYS(date2, date1) where date2 should be ........ than date

(A) bigger (B) smaller (C) same (D) any of these

185. In =DAYS(date2, date1) if date2 is smaller than date1 then........will be the result.

(A) positive (B) negative (C) real value (D) can't say

186. For =DAYS(date2,date1), not to have negative result........can be used.

(A) ABS (B) VAR (C) PRODUCT (D) INT

187. DAY function suggests.........

(A) day of month (B) date of month

(C) number of days between two dates (D) number of dates between two dates

188. DAYS function suggests.........

(A) day of month (B) date of month (C) number of days between two dates (D) number of dates between two dates

189. DAYS function displays ........ as result.

(A) word (B) number (C) symbol (D) any of these

190. To display the age as number of days..... function is used.

(A) DAY() (B) DAYINYEAR() (C) DAYS() (D) DATE()

191. To display the age as number of days.....function is used, (where B1 cell holds the birth date of student)

(A) =DAY(NOW(),B1) (B) =DAYS(NOW(),B1)

(C) =DATE(NOW(),B1) (D) =DAYSINYEAR(NOW(),B1)

192. WEEKS has ........ synt

(A) = WEEKS (StartDate,EndDate) (B) = WEEKS (date2,date1)

(C) = WEEKS (StartDate, EndDate, WeekType) (D) = WEEKS (date, month, year)

193. ........function calculates the number of weeks between two date

(A) WEEKDAY() (B) DAYSINYEAR() (C) WEEK() (D) DAYS()

194. WEEKS() function is used f........

(A) convert a valid date given into number of days of that year. (B) convert a valid date given into number of weeks of that year.

(C) convert a valid date given into number of years of that year. (D) calculate the number of days between two dates.

195. In =WEEKS(StartDate,EndDate,WeekType), WeekType has which values ?

(A) 0, 0 (B) 0, 1 (C) 1, 1 (D) -0, 1, 0

196. ........function calculates the number of years between two date

(A) YEARS() (B) WEEKDAY() (C) DAYS() (D) DAYSINYEAR()

197. YEARS() function is used for .........

(A) convert a valid date given into number of days of that year. (B) convert a valid date given into number of weeks of that year.

(C) convert a valid date given into number of years of that year. (D) calculate the number of days between two dates.

198. =YEARS (StartDate, EndDate, Type) has which values ?

(A) 0, 0 (B) 0, 1 (C) 1, 1 (D) -0, 1, 0

199. To display age as number of years, ........ function is used.

(A) DAY() (B) DAYINYEAR() (C) DAYS() (D) YEARS()

200. To display age as number of years, ........ function is used. (where Bl is the cell of birth date)

(A) =DAY(B1,NOW(),0) (B) =YEARS(B1,NOW(),0) (C) =DATE(B1,NOW(),0) (D) =DAYSINYEAR(B1,NOW(),0)

201. ........ software has the functions like c

(A) Microsoft word (B) Microsoft powerpoint (C) Microsoft excel (D) Microsoft access

202. ........can be a difference between calc and exc

(A) May be slight change in syntax (B) May be slight change in spelling

(C) , can be used as a separator of arguments instead of ; (D) Any of these