USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Trace Precedents
|
|
|
Cell outline
|
|
|
Either A or B
|
|
|
None of the above
|
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: -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.