Discussion
In MS Excel, what does Paste Special with the Values option do?
Answer: B
Correct answer: Pastes the results of formulas rather than the formulas themselves
Paste Special → Values pastes the calculated results, discarding the formulas that produced them. The cells become static numbers or text. It is used constantly for two reasons. It breaks a dependency, so a result survives when its source data is deleted or the sheet it referred to is removed. And it fixes a value in place, so a calculation whose inputs will change is frozen at a moment in time. Copying a cell onto itself and pasting values is the standard way to convert a whole column of formulas into constants. The dialogue, Ctrl + Alt + V, offers a good deal more: Formats pastes formatting alone, Transpose swaps rows and columns, Values and Number Formats keeps the appearance as well as the result, and the arithmetic options add, subtract, multiply or divide the destination by what was copied - a quick way to scale a whole range by a factor.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development