DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To paste data so that the formula is removed leaving the result only, which Paste option would you use?
|
|
Transpose
|
|
|
Formulas
|
|
|
Values
|
|
|
Formatting only
|
Explanation:
Detailed explanation-1: -Press Now press ALT + E + S + V + Enter to select Paste as Values option. The formula has now been replaced with value.
Detailed explanation-2: -To Paste Values only – Alt+E+S+V + Enter. To Paste Formatting only – Alt+E+S+T + Enter. To Paste Comments only – Alt+E+S+C + Enter. To set column width the same as that of the copied cells – Alt+E+S+W + Enter.
Detailed explanation-3: -To paste as only values, they can click Home > Paste > Paste Special > Values. This eliminates all formulas and connections, and therefore would also remove any #VALUE!
There is 1 question to complete.