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.
Question
Surya's Formula in Cell C3
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?
Solution
Sure! When Surya copies the formula from cell C2 to cell C3 in a spreadsheet (like Excel or Google Sheets), the formula will adjust automatically to reflect the new row it is in. This phenomenon is known as relative referencing.
- Original Formula: In cell C2, the formula is
C2 = A2 + B2
. - Copying the Formula: When he copies the formula to cell C3, the references to A2 and B2 will automatically adjust to point to the cells in the same columns in row 3.
Adjusted Formula in C3
Thus, the formula in cell C3 will be:
This means that the formula in C3 will add the values in cells A3 and B3 together.
Similar Questions
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 6You are creating a formula off of the following spreadsheet, the formula is as follows:= C3+E4How will this look as a mathematic equation?
This is a way to point to a cell location on the spreadsheet*3 pointsCell referenceFormat painterComplex formulaSimple formula
The cell range that starts in cell A1 and goes over J15 is written in formula as
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.