Cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be thecopied formula in cell E6?
Question
You are given the formula in cell D5:
=$B5 + C$5
If this formula is copied to cell E6, what will be the copied formula in cell E6?
Solution
The copied formula in cell E6 will be =5. This is because in the original formula, the column B is absolute (indicated by the sign before 5). So, when the formula is copied to a new cell, the absolute column (B) will not change, but the row will increase by 1 (from 5 to 6) because it is relative. Similarly, the absolute row (5) will not change in the second part of the formula, but the column will change from C to D because it is relative.
Similar Questions
What would be the best formula to use in cell D4 that could be dragged to the other cells in the column, D5 and D6?
Question 6You are creating a formula off of the following spreadsheet, the formula is as follows:= C3+E4How will this look as a mathematic equation?
Identify which of the following Formula is Correct =(C35) =23+45–Sum(B5:B9) C3+B16 =Sum(42:D48)
Surya is writing a formula in the cell C2=A2+B2.He has copied the same formula to cell C3. Can you help him understand what will be the formula in C3.
What formula would you use if you wanted to convert 3 ½, in D6 to a 3.5 in E6?=FRAC(D6)=CONVERT(D6:E6)=N(D6)
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.