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]

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

A	=$B$1+25
B	=B1+25
C	=1$B$+25
D	=B1:B3

Explanation:

Detailed explanation-1: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.

Detailed explanation-2: -By default when you copy (or cut) and paste in Excel, everything in the source cell or range-data, formatting, formulas, validation, comments-is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste.

Detailed explanation-3: -To paste the formula only, iIn the Clipboard group of the Home tab, click Paste, click Paste Special, and then click Formulas. Note: You can paste only the formula results. In the Clipboard group of the Home tab, click Paste, click Paste Special, and then click Values.

Detailed explanation-4: -A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 adjust downward by one row and become =A3+B3.

There is 1 question to complete.