Exam 9: Excell: Using Macros and Visual Basic for Applications

Properties for ActiveX controls are organized in alphabetical order on the Alphabetic tab or organized by logical groups on the ________ tab.

(Short Answer)

4.8/5

(30)

Question 21

When naming a macro,the first character of the macro name must be ________.

(Multiple Choice)

4.9/5

(40)

Question 22

If you want to change the same property for a group of objects,you can select all objects and change the property.

(True/False)

4.9/5

(43)

Question 23

The window in which you can view and edit Visual Basic code is the ________.

(Short Answer)

4.8/5

(37)

Question 24

Comments do NOT affect the function of a macro.

(True/False)

4.8/5

(33)

Question 25

A check box is a type of ActiveX control that the person filling in a form can select to indicate a choice.

(True/False)

4.9/5

(34)

Question 26

In writing VBA procedures,comments are displayed in green and are preceded by an ________.

(Short Answer)

4.8/5

(37)

Question 27

There are many properties associated with ActiveX controls,and the properties vary for the type of ________.

(Short Answer)

4.8/5

(33)

Question 28

A macro is an action or set of actions can ________ tasks within Excel.

(Short Answer)

4.8/5

(42)

Question 29

The action that causes a macro to run,which may include a combination of keystrokes and the click of a button on the Quick Access Toolbar,is called ________.

(Multiple Choice)

4.7/5

(27)

Question 30

Common uses of ActiveX controls are ________.

(Multiple Choice)

4.9/5

(39)

Question 31

A ________can include an ActiveX control such as a button or check mark that can be placed on a worksheet to display or enter data.

(Short Answer)

4.7/5

(34)

Question 32

Match the following macro security settings with their descriptions: i.Disable all macros without notification II.Disable all macros with notification III.Disable all macros except digitally signed macros IV.Enable all macros

(Multiple Choice)

4.8/5

(32)

Question 33

The place where VBA programming code is stored when you record a macro is called a ________.

(Short Answer)

4.8/5

(44)

Question 34

The word With denotes the beginning of a ________,an instruction that enables the macro to perform multiple operations on a single object.

(Multiple Choice)

4.8/5

(41)

Question 35

An ActiveX control is ________,such as a check box or button that is placed on a form to display or enter data,perform an action,or make a form easier to read.

(Multiple Choice)

4.7/5

(42)

Question 36

You would choose which of the following workbooks to save a macro that is used in other workbooks?

(Multiple Choice)

4.8/5

(39)

Question 37

A function key or key combination,such as F5 or Ctrl + R,that carries out a menu command is called a ________.

(Multiple Choice)

4.7/5

(41)

Question 38

A macro will record the actions to automate a task.

(True/False)

4.9/5

(43)

Question 39

A location where you can store macros that you want to be able to use in other workbooks is the ________.

(Multiple Choice)

4.7/5

(31)

Question 40

Showing 21 - 40 of 97

Properties for ActiveX controls are organized in alphabetical order on the Alphabetic tab or organized by logical groups on the ________ tab.

When naming a macro,the first character of the macro name must be ________.

If you want to change the same property for a group of objects,you can select all objects and change the property.

The window in which you can view and edit Visual Basic code is the ________.

Comments do NOT affect the function of a macro.

A check box is a type of ActiveX control that the person filling in a form can select to indicate a choice.

In writing VBA procedures,comments are displayed in green and are preceded by an ________.

There are many properties associated with ActiveX controls,and the properties vary for the type of ________.

A macro is an action or set of actions can ________ tasks within Excel.

The action that causes a macro to run,which may include a combination of keystrokes and the click of a button on the Quick Access Toolbar,is called ________.

Common uses of ActiveX controls are ________.

A ________can include an ActiveX control such as a button or check mark that can be placed on a worksheet to display or enter data.

Match the following macro security settings with their descriptions: i.Disable all macros without notification II.Disable all macros with notification III.Disable all macros except digitally signed macros IV.Enable all macros

The place where VBA programming code is stored when you record a macro is called a ________.

The word With denotes the beginning of a ________,an instruction that enables the macro to perform multiple operations on a single object.

An ActiveX control is ________,such as a check box or button that is placed on a form to display or enter data,perform an action,or make a form easier to read.

You would choose which of the following workbooks to save a macro that is used in other workbooks?

A function key or key combination,such as F5 or Ctrl + R,that carries out a menu command is called a ________.

A macro will record the actions to automate a task.

A location where you can store macros that you want to be able to use in other workbooks is the ________.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters