Q31. Which function is used to converts rows to columns or columns to rows in Excel?
a) CHANGE
b) TRANSPOSE
c) COLUMN
d) ROW
Answer – [B]
Q32. Which function is used to calculates the average of a group of numbers?
a) AVERAGE
b) MID
c) AVERAGEA
d) SUM
Answer – [A]
Q33. Which function is used to calculates the average of a group of numbers and text?
a) AVERAGE
b) MID
c) AVERAGEA
d) SUM
Answer – [C]
Q34. Which function is used to count the number of cells that contains number?
a) COUNTA
b) COUNT
c) TOTAL
d) AVERAGE
Answer – [B]
Q35. Which function is used to convert a date in text format to valid date?
a) DATE
b) TIME
c) TODAY
d) DATEVALUE
Answer – [D]
Q36. Which function is used to calculate the number of working days between two dates (excludes weekends, Saturday and Sunday)?
a) WEEKNUM
b) DAYS
c) WEEKDAY
d) NETWORKDAYS
Answer – [D]
Q37. Which function is used to get the week number for a given date?
a) WEEKNUM
b) DAYS
c) WEEKDAY
d) NETWORKDAYS
Answer – [A]
Q38. Which function is used to counts the number of non-blank cells?
a) COUNT
b) COUNTA
c) COUNTBLANK
d) COUNTIF
Answer – [B]
Q39. Which function is used to returns the k-th largest value in a data set?
a) MAX
b) MIN
c) LARGE
d) SMALL
Answer – [C]
Q40. Which function is used to returns the k-th smallest value in a data set?
a) MAX
b) MIN
c) LARGE
d) SMALL
Answer – [D]