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]

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?

A	Absolute reference
B	Certain reference
C	Variable reference
D	Relative reference

Explanation:

Detailed explanation-1: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.

Detailed explanation-2: -Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Detailed explanation-3: -Relative references When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.

Detailed explanation-4: -When you copy and paste formulas in Excel, it automatically adjusts the cell references. For example, suppose I have the formula =A1+A2 in cell B1.

There is 1 question to complete.