πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      In Microsoft Excel, what is the purpose of the '$' sign

      in a cell reference (e.g., `$A$1`)?
      A It indicates a named range. Correct Answer Incorrect Answer
      B It makes the row and column absolute, preventing them from changing when copied. Correct Answer Incorrect Answer
      C It signifies a formula error. Correct Answer Incorrect Answer
      D It denotes a currency format. Correct Answer Incorrect Answer
      E None of the above Correct Answer Incorrect Answer

      Solution

      It makes the row and column absolute, preventing them from changing when copied.

      Practice Next
      ask-question