asked 141k views
5 votes
EXCEL 2016:

9. Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?

a. You want to preserve the integrity of any cells referenced by formulas in the macro.
b. You want the values of any cells copied to the macro to be accurate.
c. You want the results of any formulas produced by the macro to be accurate.
d. You want the macro to reproduce its results in the same place each time.

asked
User Nevercom
by
8.3k points

2 Answers

4 votes
. You want to preserve the integrity of any cells referenced by formulas in the macro.
answered
User Mergesort
by
8.4k points
5 votes
a. You want to preserve the integrity of any cells referenced by formulas in the macro.

Hope this helps!
answered
User Aossey
by
8.5k points