Question

Which Syntax should be followed while specifying absolute cell referencing?
a. $H$2
b. =H=2
c. *H*2
d. ###
​

Answer 1

Answer: $H$2

Explanation: You will usually use the $H$2 format when creating formulas that contain absolute references. The other formats (=H=2) (*H*2) are used much less frequently.

Answer 2

Option a is the correct answer for the above question.

Explanation:

• The absolute cell referencing is used in the excel sheet formula to remain the same when the cell changed.
• For example, if a C2*2 is held by the formula for D2 cell, then when the person uses the D3 cell, then the formula will be changed and make the C3*2.
• But when the person uses the absolute cell-like $c$3, then it will remain the same for every cell.
• The dollar sign is placed with the column and row name to make the formula as an absolute formula.
• Option a holds this type of reference while the other is not holds the dollar sign, Hence option a is the correct answer.

Learn More :

• Excel sheet : https://brainly.in/question/1267251