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
Cell D5 contains the formula =5 and this formula is copied to cell E6, what will be thecopied 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
If the formula below is written in cell C4, = B$5then copied into cell C5.The formula in cell C5 will be: = Blank 1 Question 1 Blank 2 Question 1A B C D $A $B $C $D4 5 6 $4 $5 $6
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?
Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:D6.
Identify which of the following Formula is Correct =(C35) =23+45–Sum(B5:B9) C3+B16 =Sum(42:D48)
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.