In MS-Excel, which character is used to make full cell reference?

In MS-Excel, which character is used to make full cell reference?

  • (A) %
  • (B) $
  • (C) &
  • (D) #
The symbol "$" in MS Excel is used to produce absolute references which means the referenced row and column will remain unchanged even if the formula is moved or copied. By way of illustration, $A$1 is a cell reference that indicates cell A1 no matter where the formula containing it is placed or copied to.
Facebook
WhatsApp
Related MCQs:

 ‘NATO’ is an abbreviation of:

  • (A) North Atlantic Treaty Organization
  • (B) Non-Aligned Treaty Organization
  • (C) Non-Aligned Trading Organization
  • (D) North American Transport Organization

You May Like

Comment

You cannot copy content of this page

Scroll to Top