FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Select the BEST possible answer. When a formula is copied from one cell to another and the formula remains the same but the cell addresses in the formula change in relation to the position of the new cell this is called:
A
Relational addressing
B
Absolute addressing
C
Relative cell addressing
D
Mixed addressing
Explanation: 

Detailed explanation-1: -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-2: -Relative Cell References This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.

Detailed explanation-3: -An absolute reference in Excel refers to a reference that is “locked” so that rows and columns won’t change when copied. Unlike a relative reference, an absolute reference refers to an actual fixed location on a worksheet. Absolute references are used when you want to fix a cell location.

Detailed explanation-4: -For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.

There is 1 question to complete.
Previous
Next