211k views
0 votes
Nolan has just created a linked cell to another cell in a separate worksheet in his current Excel 2016 workbook.

What kind of cell relationship has Nolan created in the linked cell?


precedent

dependent

external

nonfunctional

User Shawnte
by
4.0k points

2 Answers

4 votes
the answer is dependent!
User Krajol
by
4.3k points
7 votes

Answer: dependent

Step-by-step explanation:

A Cells containing formulas which refer to other cells are known as dependents.

These are cells that depend on values in the selected cell.

A dependents cell can either contain a formula or a constant value.

(Ctrl + ] ) Is used as a shortcut when selecting dependents cells in an active cell.

Another option is to make use of you (Tools > Formula Auditing > Trace Precedents).

User APerson
by
4.5k points