Multiple Choice
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.
Correct Answer:
Verified
Correct Answer:
Verified
Q8: A(n)_ is a set of instructions that
Q9: All cells are unlocked, by default.
Q10: Where would you store macros that you'd
Q11: How do you insert a button to
Q12: Match each of the following terms with
Q14: Form Controls are on the Developer tab.
Q15: Excel templates are downloadable from the Template
Q16: On which tab is the Themes Gallery?<br>A)File<br>B)Insert<br>C)Page
Q17: The Macro Recorder uses absolute references by
Q18: Which of the following is not a