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.


Answer: A

Computer Science & Information Technology

You might also like to view...

Answer the following statements true (T) or false (F)

1. When you create a linked list, you must know in advance how many nodes the list will contain. 2. The values stored in the value portion of a node of a linked list can be simple data types, structures, objects of classes, or any other data type. 3. A linked list can grow and shrink as a program runs. 4. Linked lists are less complex to code and manage than arrays. 5. Nodes in a linked list are stored in contiguous memory.

Computer Science & Information Technology

Which of the following statements is false?

a. Dictionary methods keys and values can be used to iterate through only a dictionary’s keys or values, respectively. b. Dictionary methods items, keys and values each return a view of a dictionary’s data. c. When you iterate over a view, it “sees” a copy of the dictionary’s current contents. d. You should not modify a dictionary while iterating through a view. According to the Python Standard Library documentation, either you’ll get a RuntimeError or the loop might not process all of the view’s values.

Computer Science & Information Technology

_______ is any indication that the computer is still processing a task or has already completed it.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Using good grammar, describe what to do when sound does not emit from the speakers

What will be an ideal response?

Computer Science & Information Technology