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: -Modifying values with cell references The formula in B3 will automatically recalculate and display the new value in cell B3. Excel will not always tell you if your formula contains an error, so it’s up to you to check all of your formulas.
Detailed explanation-2: -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. They exist for the sake of compatibility with other spreadsheet applications.
Detailed explanation-3: -You can also enter the value TRUE directly into cells and formulas without using this function. For example: =IF(A1=1, TRUE) If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.
Detailed explanation-4: -Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.