Question

If the formula in cell B4 is copied and pasted to cell D2, what will be the formula and
the resultant value?

Answer 1

Answer:

The results can be added by the coding

Answer 2

$\Huge\bf\maltese{\underline{\green{Answer°᭄}}}\maltese$

$\implies$$\large\bf{\underline{\red{VERIFIED✔}}}$

$\bf\huge{\purple{╔════════♡︎═╗}}$

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

$\bf\huge{\pink{╚═♡︎════════╝}}$

$\boxed{I \:Hope\: it's \:Helpful}$

${\sf{\bf{\blue{@ℐᴛz ᴅɪɴᴜ࿐}}}}$