Question

8. Arguments passed to a macro from Calc are always:

O VALUES
O REFERENCES
O OBJECTS
OVARIABLES​

Answer 1

Answer:

Explanation

The right answer is (a) Values

Answer 2

Answer:

Arguments passed to a macro from Calc are always Values.

Explanation:

• Arguments passed to macros from computations are always values.
• It is not possible to know which cells are used. For example, =PositiveSum(A3) returns cell A3 and positive values.
• To define a macro that takes arguments, include the parameters between a pair of macro definition braces similar to a macro function.
• The parameters must be valid C identifiers separated by commas and optional spaces.

Passing Arguments to macro:

• Sum doesn't know that cell A3 was used.
• Parameters are either profile simple strings or quoted strings.
• This can be passed in the standard way of inserting variables into shared and profile pools (using VPUT in dialogs and VGET in initial macros).
• This method works best for parameters passed from one dialog to another, such as machining macros.

#SPJ3