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: -The TRUE and FALSE functions There are TRUE and FALSE functions in Excel as well. For instance, if you type “=TRUE()” into a cell, it will return the value TRUE. If you type “=FALSE()” it will return FALSE. There is no need to use these functions in standard situations.
Detailed explanation-2: -When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you enter or select the cell reference A2, the formula uses the value of that cell to calculate the result.
Detailed explanation-3: -Select the cell with the formula, press F2, and then press ENTER. The cell displays the value.
Detailed explanation-4: -Value if true (optional)-the value to return when the logical test evaluates to TRUE, i.e. the condition is met. If omitted, the value if false argument must be defined.