Bissoy.com
Doctors Medicines MCQs Q&A

Suppose the value of cell E5 in MS-Excel sheetis 3500. If we apply the formula = IF ( E5 < 20000,E5 * 10%, E5 * 20%) , what will be the result ?

Suppose the value of cell E5 in MS-Excel sheetis 3500. If we apply the formula = IF ( E5 < 20000,E5 * 10%, E5 * 20%) , what will be the result ? Correct Answer 350

We put a value 3500 in E5 cell. Then we apply a formula = IF ( E5 < 20000, E5* 10%, E20%). This formula calculate if value in E5 is less then 20000 is true then multiply the value in E5 i.e, 3500 with 10%. But if the condition is false the multiply the value in E5 with 20%. Thus 3000 is less then 20000 so we multiply ( 3500*10%) = 350.

Related Questions

Suppose the value of cell E5 in MS-Excel sheetis 3500. If we apply the formula = IF ( E5 20000,E5 * 10%, E5 * 20%) , what will be the result ?
Suppose the value of cell E5 in MS-Excel sheet is 3500. If we apply the formula =IF(E520000,E5*10%,ES*20%), what will be the result ?
Suppose the value of cell E5 in MS-Excel sheet is 3500. If we apply the formula =IF(E5<20000,E5*10%,ES*20%), what will be the result ?
Consider three software items: Program-X, Control Flow Diagram of Program-Y and Control Flow Diagram of Program-Z as shown below Program-X: Control Flow Diagram of Program-Y sumcal (int maxint, int value) {       int result=0, i=0;       if (value <0)       {           Value = -value;       }       while ( (i
In an MS-Excel sheet, cell A1 contains 5, A2 contains 6, and cell A3 contains the formula = A1 + A2. The formula in cell A3 is copied into cell B3 by dragging. Which of the following will be the result (output) displayed in cell B3?
Suppose the A1 cell of an MS-Excel worksheet contains the formula " =C5+A4". If A1 cell is copied and pasted into D5 cell, then what will be formula in D5?
Column A lists the cell parts and Column B lists the functions of the cell part. Column A Column B i. Cell wall A. Control what happens ii. Cell membrane B. Supports the cell. iii. Cytoplasm C. Controls what passes in and out of the cell. iv. Nucleus D. Cell reactions happen in it. Which one of the following options is correct?
Suppose cells A5 and B5 contain the values 35,000 and 100 respectively . In cell C5, if you apply the formula = IF (A5 > 20000, B5 * 10%,B5 * 20%), what will be the result in C5 ?
Suppose cels A5 and B5 contain the values 30000 and 100, respectively . In cell C5, if we apply the formula = IF (A5>20000, B5*10%, B5*20%), what will be the result in C5 ?
Suppose cells A5 and B5 contain the values 35,000 and 100 respectively . In cell C5, if you apply the formula = IF (A5 <> 20000, B5 * 10%,B5 * 20%), what will be the result in C5 ?