Question

Which of formula contains an absolute cell reference?
=A1!+(A4*2%)
=SUM($B$7:$B$9)
=4000+2/(3*24)
=COUNT(A3:A7, B3:B12)

Answer 1

Answer:

I thik the answer is option no.2

Answer 2

Option 2) =SUM($B$7:$B$9)

• The cell reference is automatically made absolute by Excel! Excel will cycle through each possible absolute reference by pressing F4 repeatedly. For instance, instead of typing =B7*$B$9, I could have used the F4 key to change B7 to $B$9 in the first absolute cell reference formula in this article, =B7*$B$9.
• In a spreadsheet application, an absolute cell reference is a cell reference that doesn't change even if the spreadsheet's size or shape changes, or if the reference is copied or relocated to a different cell or page. When making references to constant values in a spreadsheet, absolute cell references are crucial.
• The F4 key can also be used to make any cell's reference constant. Examples of absolute cell references are $A$1, $B$3. For instance, we want the percentage entered in cell C2 and the sum of the marks from the two topics entered in columns A and B to be multiplied, with the result being displayed in column D.

#SPJ2