122k views
4 votes
How would you express the formula e3 e4 in the form of an absolute cell address?

1) $e$3 $e$4
2) e3$ e4$
3) e$3 e$4
4) $(e3 e4)
5) $3$e $4$e

User Gonz
by
8.1k points

1 Answer

5 votes

Final answer:

The correct expression in the form of an absolute cell address for e3 and e4 is Option 1: $e$3 $e$4.

Step-by-step explanation:

To express the cell references e3 and e4 as absolute cell addresses in spreadsheet software such as Microsoft Excel or G Sheets, you would add dollar signs in front of both the column letter and row number. The correct absolut cell reference format would be $e$3 and $e$4. Therefore, the correct expression of the formula would be Option 1: $e$3 $e$4.

An absolute cell reference is one that does not change when copied or filled to other cells. This is in contrast to a relative cell reference, where the references change relative to the position they are copied.

User Bao
by
8.5k points