Question

How would you express the formula E3+E4 in the form of an absolute cell address?

$E$3+$E$4
E3$+E4$
E$3+E$4
$(E3+E4)
$3$E+$4$E

Answer 1

Option A is correct.

Explanation:

An absolute cell Address is the address which has a dollar sign ($) in the row or column coordinate, or both. This fix the position of that cell in that formula.

Here The given Formula is E3 + E4

So, In Absolute Cell address form it is written as follow,

$E$3 + $E$4

Therefore, Option A is correct.

Answer 2

→E 3+E 4=The Operation consisting combination of Alphabets and Digits and Addition between them can be represented in the form of cell Address as

: Column Address * Row Address [Operation i.e addition ] Column Address * Row Address

= $E$3+$E$4