174k views
2 votes
The formula "=B89+P90+$L$67" contains absolute reference(s) and

a. 0:3
b. 3:1
c. 2:2
d. 1:2
Please select the best answer from the choices provided
relative reference(s).

1 Answer

2 votes

Final answer:

The formula "=B89+P90+$L$67" includes 1 absolute reference ($L$67) and 2 relative references (B89 and P90), making the option 'd). 1:2' the correct answer.

Step-by-step explanation:

The formula "=B89+P90+$L$67" contains both absolute and relative references.

An absolute reference is indicated by the dollar signs before the column letter and row number (e.g., $L$67). This means that if you copy the formula to another cell, the reference to cell L67 will remain the same.

On the other hand, relative references like B89 and P90 will change depending on where the formula is copied because they lack the dollar signs that lock the reference to a specific cell.

The correct answer to the question as to how many absolute and relative references the formula contains is: there is 1 absolute reference and 2 relative references.

Hence, the best choice from the provided options is d). 1:2.

User Hans Doggen
by
8.1k points