USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Error Checking
|
|
|
Evaluate Formula
|
|
|
Trace Dependents
|
|
|
Trace Precedents
|
Detailed explanation-1: -To use Trace Error in Excel, select the formula cell with the error displayed in it. Click the “Trace Error” drop-down button in the “Formula Auditing” button group on the “Formulas” tab in the Ribbon. Then select the “Trace Error” command in the drop-down menu to draw arrows to the cells causing the error.
Detailed explanation-2: -Enter a formula in cell B7 to display the text from cell A7 with only the first letter of each word in upper case. Formulas Ribbon Tab Function Library Ribbon click the Text button. In the Text menu click PROPER Inside the Function Arguments dialog, you typed A7 in the Text input, clicked the OK button.
Detailed explanation-3: -Go to Formulas tab > Formulas Auditing > Trace Dependents. Click on the Trace Dependents button to see the cells that are affected by the active cell. It will show a blue arrow that links the active cell and the other cells related to the selected cell.
Detailed explanation-4: -ISERROR is a logical function that is used to identify whether the cells being referred to have an error or not. This function identifies all the mistakes. If any error is found in the cell, it returns “TRUE” as a result, and if the cell has no errors, it gives “FALSE” as a result.