Multiple Choice
Which of the following statements is true about a macro in Excel?
A) It is used to access the functions available in Excel.
B) It is used to convert an Excel worksheet into a PDF document.
C) It is used to scramble the contents of an Excel worksheet so that it can't be read without the right key.
D) It is used to automate a series of Excel steps and to set up buttons and dialog boxes.
Correct Answer:
Verified
Correct Answer:
Verified
Q29: You can use VBA to create your
Q30: When typing code directly into a VBA
Q31: The Visual Basic Editor is used to
Q32: A(n)_ is a set of actions recorded
Q33: When you're working in the Visual Basic
Q35: In VBA,dates and times are placed between
Q36: In VBA,which of the following symbols represents
Q37: Which of the following is a VBA
Q38: _ extends and customizes Excel,allowing you to
Q39: To use VBA in an Excel worksheet,you