Exam 9: Excell: Using Macros and Visual Basic for Applications
Exam 1: Introduction to Microsoft Office 2016 Features90 Questions
Exam 1: Excell: Creating a Worksheet and Charting Data97 Questions
Exam 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks90 Questions
Exam 3: Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools79 Questions
Exam 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets99 Questions
Exam 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering98 Questions
Exam 6: Excell: Creating Charts, Diagrams, and Templates100 Questions
Exam 7: Excell: Creating Pivottables and Pivotcharts91 Questions
Exam 8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas96 Questions
Exam 9: Excell: Using Macros and Visual Basic for Applications97 Questions
Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables96 Questions
Exam 11: Excell: Collaborating With Others and Preparing a Workbook for Distribution95 Questions
Select questions type
The programming language to write computer programs within the Microsoft Windows environment is called ________.
(Short Answer)
4.9/5
(41)
Match the following terms with their meanings:
i.macro virus
II.digital signature
III.Record Macro
IV.form
v.macro
(Multiple Choice)
4.8/5
(38)
When you use someone else's computer,it is proper computer ________ to return it to the condition that you found it.
(Short Answer)
4.9/5
(37)
After you add a button to the Quick Access Toolbar,only someone with administrator access can remove it.
(True/False)
4.8/5
(35)
Within VBA,you can write a procedure into your form that will insert ________.
(Multiple Choice)
4.9/5
(30)
ActiveX controls are NOT attached to cells,instead,they are similar to inserted shapes or SmartArt.
(True/False)
4.8/5
(35)
An unauthorized programming code in a macro that erases or damages files is called a macro ________.
(Short Answer)
4.8/5
(40)
Match the following terms with their meanings:
i.module
II.procedures
III.subs
IV.Visual Basic Editor
v.event
(Multiple Choice)
5.0/5
(22)
A set of instructions that accomplish a specific task is called ________.
(Multiple Choice)
4.8/5
(44)
An ActiveX Control can be added that inserts a ________ button to control when code can be attached and initiates an action when clicked.
(Short Answer)
4.8/5
(42)
A macro is an action or a set of actions with which you can automate tasks by grouping a series of commands into a single command.
(True/False)
4.8/5
(31)
On the Categorized tab,the same properties are listed,but they are organized by ________ groups.
(Multiple Choice)
4.8/5
(42)
If you share macros with others,you can certify them with a ________.
(Multiple Choice)
4.8/5
(37)
After you create a VBA procedure,you should test it to ________that it works as you intended.
(Short Answer)
4.8/5
(35)
A worksheet or Excel object containing fields and controls that enable you to easily enter or edit data is ________.
(Multiple Choice)
4.7/5
(44)
A combination of keys to execute a macro or program is known as a shortcut key.
(True/False)
4.8/5
(37)
Macros are recorded in the ________ programming language,which you can use to write computer programs within the Microsoft Windows environment.
(Multiple Choice)
4.9/5
(35)
Click the Insert Tab to add a button to the Quick Access Toolbar.
(True/False)
4.7/5
(42)
Showing 41 - 60 of 97
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)