๐Ÿ“ข Too many exams? Donโ€™t know which one suits you best? Book Your Free Expert ๐Ÿ‘‰ call Now!

  • google app store apple app store
  • โœ–

      Question

      Which of the following characters is used to create an

      absolute address in MS-Excel?
      A Dollar ($) Correct Answer Incorrect Answer
      B Ampersand (&) Correct Answer Incorrect Answer
      C Percent (%) Correct Answer Incorrect Answer
      D Hash (#) Correct Answer Incorrect Answer

      Solution

      Absolute reference in excel is used when we want to fix the position of the selected cell in any formula so that its value will not change whenever we are changing the cell or copying the formula to other cells or sheets. This is done by putting the dollar ("$") sign before and after the column name of the selected cell. Or else, we can type the F4 function key, which will automatically cover the column alphabet with the dollar.

      Practice Next

      Relevant for Exams:

      ask-question