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 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
The formula in cell C3 will automatically adjust to the new row. So, the formula in C3 will be A3+B3. This is because Excel adjusts the cell references when you copy and paste a formula into a new cell.
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?
In the expression, the ______followed by the values, cell address and functions are called as formula.
In Calc, when you copy or move the formula to the other cells, the reference cellautomatically gets changed is called ____
The cell range that starts in cell A1 and goes over J15 is written in formula as
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.