India Exam Junction

[PSSSB Restorer 2023]

18. Which of the following is not a valid option of pasting copied data in MS Excel?

  1. Transpose

  2. Formula

  3. Hyperlink

  4. Absolute

Correct Answer :

Absolute

Solution

When pasting copied data in MS Excel, you have several options for controlling how the data is pasted:

  • Transpose: Allows you to change the orientation of the copied data from rows to columns or columns to rows.
  • Formula: Pastes only the formulas from the copied cells without any formatting.
  • Hyperlink: Pastes any hyperlinks associated with the copied data.

Absolute is not a valid option for pasting data. While you can have absolute references in Excel formulas (using $), it is not an option available when pasting data.

Therefore, Absolute is not a valid pasting option in MS Excel.

Join The Discussion
Comments (0)