Question

Cell D5 contains the formula =$B5+C$5 and this formula is copied to cell E6, what will be the copied formuoa in the cell E6

Answer 1

Answer:

it will remain the acc. to the absolute and mixed cell referencing

Answer 2

=$B5+C$5 is a formula which is hold by the cell E6, because the formula will be unchanged when it will be copied:

Explanation:

• The formula is used in the excel sheet to calculate some new value on behalf of the old value of the cell.
• So when a user writes the formula for any different cell and then copy the formula and paste for the other cell, then the formula and the calculated value will remain the same.
• So when the user copies the formula of D5 into E6, then the formula will be the same for the cell E6.

Learn More :

• Excel : https://brainly.in/question/13842386