Bissoy.com
Doctors Medicines MCQs Q&A

What is the value of the following MS-Excel function? =FLOOR(14, 4)

What is the value of the following MS-Excel function? =FLOOR(14, 4) Correct Answer 12

Key Points

 Excel FLOOR function:

The FLOOR function in Excel is used to round a given number down, to the nearest multiple of a specified significance.

Syntax: FLOOR(number, significance)

Number- the number you want to round.

Significance - the multiple to which you wish to round the number.

FLOOR(14, 4) = 12 Here 4 rounds down the nearest multiple of  4 (4 × 3 = 12 is nearer)

Hence the correct answer is 12.

Related Questions

Consider the pseudocode given below. The function DoSomething() takes as argument a pointer to the root of an arbitrary tree represented by the leftMostChild-rightSibling representation. Each node of the tree is of type treeNode. typedef struct treeNode* treeptr; struct treeNode {              treeptr leftMostChild, rightSibling; }; int DoSomething (treeptr tree) {              int value=0;              if (tree != NULL) {              if (tree->leftMostChild == NULL)              value = 1;    else               value = DoSomething(tree->leftMostChild);               value = value + DoSomething(tree->rightSibling);     }               return(value); } When the pointer to the root of a tree is passed as the argument to DoSomething, the value returned by the function corresponds to the 
In MS Excel, what is function inside another function called? A. Round Function B. Sandwich function C. Switch function D. Nested function 
Pick the correct statements.
I.   The body of a function should have only one return statement.
II.  The body of a function may have many return statements.
III. A function can return only one value to the calling environment.
IV. If return statement is omitted, then the function does its job but returns no value to the calling environment.
Which of the following statements related to 'C' language is/are FALSE? (i) A function must be declared globally in a C program to tell the compiler about the function name, function parameters, and return type. (ii) The parameter list must not differ in function calling and function declaration.
Validate the statement: “For a given image in one-dimension given by function f(x, y), to sample the function we take equally spaced samples, superimposed on the function, along a horizontal line. However, the sample values still span (vertically) a continuous range of gray-level values. So, to convert the given function into a digital function, the gray-level values must be divided into various discrete levels.”
If the result overflows, the function returns the value of the macro HUGE_VAL, carrying the same sign except for the _________ function as the correct value of the function.
If the result overflows, the function returns the value of the macro HUGE_VAL, carrying the same sign except for the . . . . . . . . function as the correct value of the function.
The following moves are performed on g(x). (i) Pick (x0, y0) on g(x) and travel toward the left/right to reach the y = x line. Now travel above/below to reach g(x). Call this point on g(x) as (x1, y1) (ii) Let the new position of (x0, y0)be (x0, y1) This is performed for all points on g(x) and a new function is got. Again these steps may be repeated on new function and another function is obtained. It is observed that, of all the functions got, at a certain point (i.e. after finite number of moves) the nth derivatives of the intermediate function are constant, and the curve passes through the origin. Then which of the following functions could be g(x)
In the two set given below, Set I mentions some of the evolutes of Prakarti white Set II indicates their nature and function in term of Sankhya philosophy. Match the two sets List I (Evolution of Prakiti) List II (Nature and function) 1. Mahat, the great (i) Are neither the qualities nor the differentia of gross elements nor the function. 2. Ego (Ahankar) (ii) It is cosmic in nature and functions as a psychological aspect of knowing. 3. Mind (Manas) (iii) It is the principle of individuation and its function is to generate self-sense. 4. Subtle essences (Tanmtras) (iv) It is the subtle and central sense organ which synthesizes sense data into determinate perception.   Select correct answer from the following options.
In which of the following cases inline functions may not word? i) If the function has static variables. ii) If the function has global and register variables. iii) If the function contains loops iv) If the function is recursive