..... cells are those cells containing formulas that refer to other cells. You can use this commands on the Formulas tab to check relationships between formulas in your workbooks.

HOW TO USE THE CONCATENATE FUNCTION 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]

____ cells are those cells containing formulas that refer to other cells. You can use this commands on the Formulas tab to check relationships between formulas in your workbooks.

A	Dependent
B	Precedent
C	Either A or B
D	None of the above

Explanation:

Detailed explanation-1: -Dependent cells-these cells contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5.

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: -Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria, -such as the last cell on the worksheet that contains data or formatting.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL