FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following commands on the Formulas tab displays arrows that specify which cells affect the value of the current cell?

A	Trace Precedents
B	Trace Formulas
C	Find
D	Lookup

Explanation:

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: -The reactants are listed on the left side of the equation, while the products are listed on the right. The direction of the reaction is shown by an arrow pointing from the reactants to the products.

Detailed explanation-5: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).

There is 1 question to complete.