Question

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

Answer 1

The formula is "=$B5+C$5", which is copied on the cell E6.

Explanation:

• If any formula is copied to any cell, then that cell holds that formula and it also holds the value which is generated by the formula.
• The above formula is used to add the cell value of B5 and C5 and then that value is displayed on the cell D5 and E6 if the formula is copied from the cell D5 into E6.
• This type of formula is used, if anyone wants to perform any operation for any cell.

Learn More:

• MS-Excel : https://brainly.in/question/9086619