how would you use a relative cell reference in a macro? a) click use relative references before you perform the commands. b) press f4 when selecting the range. c) you must edit the macro in the vba editor to change the reference type. d) hold the shift key down while recording the macro.