DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Trace Precedents
|
|
Trace Formulas
|
|
Find
|
|
Lookup
|
Detailed explanation-1: -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-2: -Formula Auditing Trace Precedents-Displays arrows that indicate what cells affect the value of the currently selected cell.
Detailed explanation-3: -There are a few different keyboard shortcuts you can use to trace precedents in Excel, but the most commonly used are F5 and Ctrl + F5. To use either of these shortcuts, simply select the cell you want to trace precedents for and press the shortcut key.
Detailed explanation-4: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-5: -Trace Precedents – Draws tracer arrows from the cells that supply values directly to the formula in the active cell. You can press this button multiple times to see additional levels.