Computer MCQ . (1 Marks)

What can be a function argument ?

How many arguments one can use with a Calc function ?

A function can start with which of the following options ?

In which of the following way we can enter a function in Calc ?

= RANK (67: Al: F1; ______) function returns the rank of a given number from the cell range A1 to F1 after arranging it in ascending order.

= RANK (67: A1: F1; _____) function returns the rank of a given number from the call range Al to F1 after arranging it in descending order.

48. The _______ returns the rank of a given number in the given set of numbers.

The ________ returns the kth smallest numeric value found in the given set of values X.

The ______ considers the numbers specified in a range in a descending order and number at kth position is returned.

The ______ returns the kth largest numeric value found in the given set of values x.

Which of the following function do not consider empty cells?

The __________ returns the total number of cells or arguments which have some value in it.

The _______returns the most common value in a data set.

The _______ returns the middle number of the group in which numbers are ranked in order.

The_______ gives harmonic mean of n numbers.

The ______ multiplies non-negative number and returns ath root.

The ________ returns the geometric mean of numbers given to it.

The _______ returns the average of numbers given to it.

Which of the following function support forecasting, predicting as well as decision making activities ?

______ functions help in collection, analysts, explanation, and presentation of data.

Which of the following is not a mathematical function ?

Which of the following function does not round the number ?

Which of the following function / s takes two argments ?

The output of =TRUNC (-15.72) will be______.

The output of =TRUNC (1.219; 1) will be ______.

The ______chops off the fractional part of a given number leaving some digits after decimal point.

The output of =ROUNDUP (45.345: 1) will be______.

The output of = ROUNDDOWN (45.345; 1) will be_______.

The output of =ROUND (45.345; 1) will be ______.

_______ rounds the given number to the specified places.

The ______rounds the given number down to the nearest integer

The_______ returns the square root of a positive number.

Which of the following function multiplies up to 30 arguments ?

The ________ returns the number raised to the given number.

The______ returns the value of logarithm base 10 for the given positive number.

The _______returns the value of natural logarithm

Which of the following function returns the value of the factorial function for the given number ?

The _____ returns the values of exponential function ex for the given number x

The______ converts a negative number into positive number.

_______ functions are very helpful to work with numbers in Cale.

Which sign is used to specify cell range in function ?

In which of the following way a function wizard can be activated ?

Which of the following built in standard functions are provided in Cale ?

Which of the following a function wizard contain?

Sometimes operators such as _______ may also be used with functions and formulas.

What will happen if function is not started with sign ?

Which of the following is mandatory in the syntax of the function?

The arguments of a function is separated using______ sign.

The function arguments are given in ________brackets.

_________can be used as an argument of the function