Question 1

What happens if you write VBA code in all lowercase letters?

Accepted Answer

A)  The Visual Basic Editor converts the code to the correct case. 
B)  The Visual Basic Editor displays a syntax error. 
C)  The Visual Basic Editor will not run the code when you click the Run button. 
D)  The Visual Basic Editor will treat the code as a comment. 
A)  The Visual Basic Editor converts the code to the correct case. 
B)  The Visual Basic Editor displays a syntax error. 
C)  The Visual Basic Editor will not run the code when you click the Run button. 
D)  The Visual Basic Editor will treat the code as a comment.

Question 2

You must use the correct _____, or rules, when creating a VBA statement.

Accepted Answer

A)  syntax 
B)  executors 
C)  procedures 
D)  rubrics 
A)  syntax 
B)  executors 
C)  procedures 
D)  rubrics

Question 3

When building a conditional expression that refers to a value in a form control, use the syntax called _____. ​

Accepted Answer

A)  bang notation 
B)  Boolean syntax 
C)  procedural notation 
D)  event syntax 
A)  bang notation 
B)  Boolean syntax 
C)  procedural notation 
D)  event syntax

Question 4

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

Accepted Answer

A) True 
 B)False

Question 5

Class modules most commonly run in response to an event, such as a user clicking a command button.

Accepted Answer

A) True 
 B)False

Question 6

_____ a database means to identify the database file as safe to open.

Accepted Answer

A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting 
A)  Securing 
B)  Enabling 
C)  Trusting 
D)  Splitting

Question 7

Which of the following statements creates a function named Bonus with an argument named Salary?

Accepted Answer

A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary) 
A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary)

Question 8

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Accepted Answer

A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time 
A)  syntax 
B)  run-time 
C)  logic 
D)  compile-time

What happens if you write VBA code in all lowercase letters?

You must use the correct _____, or rules, when creating a VBA statement.

When building a conditional expression that refers to a value in a form control, use the syntax called _____.

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

Class modules most commonly run in response to an event, such as a user clicking a command button.

_____ a database means to identify the database file as safe to open.

Which of the following statements creates a function named Bonus with an argument named Salary?

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters

Exam 11: Exploring Pivottable Design

What happens if you write VBA code in all lowercase letters?

You must use the correct _____, or rules, when creating a VBA statement.

When building a conditional expression that refers to a value in a form control, use the syntax called _____. ​

To display the Visual Basic window, you click the Create tab on the ribbon, and then click Visual Basic.

Class modules most commonly run in response to an event, such as a user clicking a command button.

_____ a database means to identify the database file as safe to open.

Which of the following statements creates a function named Bonus with an argument named Salary?

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Developing an Excel Application

Filters

When building a conditional expression that refers to a value in a form control, use the syntax called _____.