DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell D1 has a formula =A2+B2. This formula is copied to cell D4. What do you see in cell D4?
|
|
=A2+B2
|
|
|
Error Message
|
|
|
=A4+B4
|
|
|
=A5+B5
|
Explanation:
Detailed explanation-1: -Select the cell that contains the formula you want to move. Click Home > Cut (or press Ctrl + X). Select the cell you want the formula to be in, and then click Paste (or press Ctrl + V).
Detailed explanation-2: -Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.
Detailed explanation-3: -A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 adjust downward by one row and become =A3+B3.
There is 1 question to complete.