USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is an example of a relative cell reference?
|
|
A9
|
|
|
A$9
|
|
|
$A$9
|
|
|
A9:E9
|
Explanation:
Detailed explanation-1: -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-2: -Expert-Verified Answer. Answer: A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1.
Detailed explanation-3: -Answer. Answer: The row and column portions of a relative reference are not preceded by a “$” – for example, A1 is a relative reference to cell A1. If moved or copied, the reference changes by the same number of rows and coulmns as it was moved.
Detailed explanation-4: -$A7 – absolute column, relative row.
There is 1 question to complete.