USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A5
|
|
|
$A$5
|
|
|
A$5
|
|
|
A named cell
|
Detailed explanation-1: -A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1.
Detailed explanation-2: -A mixed reference in Excel is a type of cell reference different from the other two absolute and relative. We only refer to the cell’s column or row in the mixed cell reference. So, for example, in cell A1 if we want to refer to only the A column, the mixed reference would be $A1.
Detailed explanation-3: -You notice that the $A$5 cell reference will not change because it is called an absolute reference. Essentially, that means that it will freeze it to stay exactly as it is no matter where you copy it.
Detailed explanation-4: -Answer. Answer: The answer is False.
Detailed explanation-5: -$A1$B2 is an example of mixed referencing in spreadsheet software. Numbers entered into a cell are automatically right aligned. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5; 60) will display 20.