FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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?

A	Transpose
B	Formulas
C	Values
D	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: -Select the cells that contain the data or other attributes that you want to copy. Click the first cell in the area where you want to paste what you copied. On the Home tab, click the arrow next to Paste, and then select Paste Special. Select the options you want.

Detailed explanation-4: -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.