USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You can create a new range by selecting the cells and typing a name in the Name box next to the formula bar. The order of operations determines which parts of a formula are calculated before other parts of the formula. The formula = 6 * 2 / 3 produces the same result as =6 * (2 / 3).
Detailed explanation-2: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-3: -FALSE function returns the logical value FALSE. It does not take any input arguments.
Detailed explanation-4: -Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values.
Detailed explanation-5: -In MS-Excel, the address of any cell starts with “A1‟. Hence statement 2 is false.