COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
+
|
|
|
%
|
|
|
&
|
|
|
$
|
Detailed explanation-1: -An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it’s known as a mixed reference.
Detailed explanation-2: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. 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: -If the reference operator is used you will get the “address of” a variable. In the example above we said: ptr p = &x; . In words: store the address of the variable x in the pointer ptr p. We also used the asterisk sign (*) in the cout statement.