FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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]

If you want to subtract the values in a range from another range what do you have to use?

A	SHift+Enter
B	Paste Special
C	Entering numbering with fraction
D	F2

Explanation:

Detailed explanation-1: -Press Ctrl+Shift+Down Arrow to select to the bottom of the data. Click the bottom half of the Paste icon and choose Paste Values to open the dialog. In the Paste Values dialog, select Values in the Paste section and Subtract in the Operation section. Click OK.

Detailed explanation-2: -Subtract numbers in a range Use the SUM function to add negative numbers in a range. Note: There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100, -32, 15, -6) returns 77.

Detailed explanation-3: -To use options from the Paste Special box, select Home, select the clipboard icon (Paste), and select Paste Special. Keyboard Shortcut: Press Ctrl+Alt+V.

Detailed explanation-4: -When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.

There is 1 question to complete.