FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Commands on the Formulas tab displays arrows that specify which cells affect the value of the current cell
A
Trace Precedents
B
Cell outline
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Formula Auditing Trace Precedents-Displays arrows that indicate what cells affect the value of the currently selected cell.

Detailed explanation-2: -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-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).

There is 1 question to complete.
Previous
Next