EXCEL 2016:
- Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?
AYou want to preserve the integrity of any cells referenced by formulas in the macro.
BYou want the values of any cells copied to the macro to be accurate.
CYou want the results of any formulas produced by the macro to be accurate.
DYou want the macro to reproduce its results in the same place each time.
AYou want to preserve the integrity of any cells referenced by formulas in the macro.
BYou want the values of any cells copied to the macro to be accurate.
CYou want the results of any formulas produced by the macro to be accurate.
DYou want the macro to reproduce its results in the same place each time.