Question

arguments passed to a macro from Calc are always--
1. Values
2. References
3. Objects​

Answer 1

Answer:

Arguments passed to a macro from Calc are always 1. Values.

Explanation:

• Arguments passed from Calc to macros are always values.
• It is not possible to know which cells are used.
• For example =PositiveSum(A3) returns the value of cell A3, but PositiveSum does not know that cell A3 was used.
• If you need to know which cell is referenced rather than the value in the cell, pass the range as a string and parse the string to get the value of the referenced cell.
• Parameters are either simple strings or quoted strings.
• This can be passed using the standard method of inserting variables into shared and profile pools (using VPUT in dialogs and VGET in initial macros).
• This method is ideal for parameters passed from one dialog to another, such as edit macros.

#SPJ3

Answer 2

Answer:

the correct option 1 values