Paste Special → Values pastes:

  1. only the formulas
  2. only the results, not the formulas
  3. only formatting
  4. column widths only
Answer

B) only the results, not the formulas

Useful to freeze calculated values.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise