Cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be thecopied formula in cell E5?
Question
Cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be thecopied formula in cell E5?
Solution
The copied formula in cell E5 will be =) in the formula creates an absolute reference to column B. So, when the formula is copied from D5 to E5, the reference to column B remains the same, but the reference to C5 (without a dollar sign) changes to D5 because it is a relative reference.
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
Identify which of the following Formula is Correct =(C35) =23+45–Sum(B5:B9) C3+B16 =Sum(42:D48)
Which of the following is a valid formula?*3 points(D5*F5)=F15=C3-C4F2/F3
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?
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.