Deck 22: Programming in Excel With VBA

Question 1

Which of the following does a VBA macro manipulate?

A)A constant
B)A variable
C)An object
D)A sub macro

Answer 1

C
Explanation: VBA manipulates objects.An object in VBA is an item available for you to control in your code.

Question 2

Which of the following tools enables users to view and edit a VBA macro?

A)Web authoring software
B)Visual Basic Editor
C)Query-by-example tool
D)Visual Basic Analyzer

Answer 2

B
Explanation: You perform actions in VBA by writing (or recording)code in a VBA macro.You view and edit VBA macros using the Visual Basic Editor (VBE).

Question 3

Which of the following is a component of a macro that performs some action on or with objects?

A)A Function procedure
B)A Sub procedure
C)A visual procedure
D)A Sub macro

Answer 3

B
Explanation: A VBA macro consists of Sub procedures.A Sub procedure is computer code that performs some action on or with objects.

Question 4

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.

Question 5

Which of the following Excel tools allows you to record a sequence of commands in Excel and save them?

A)The key logger tool
B)The query-by-example tool
C)A Sub procedure
D)The macro recorder

Question 6

VBA is:

A)a programming language developed by Microsoft to extend and customize Excel.
B)a graphical user interface that allows a novice Excel user to build complex worksheets.
C)a programming environment built by a non-profit group of programmers that can be used with Excel.
D)a programming environment developed by Microsoft that can be used instead of Excel and Access for complex applications.

Question 7

Which of the following is a built-in function in Excel and does not require a macro?

A)Inserting a company name on all spreadsheets
B)Creating a custom toolbar button
C)Performing a specific calculation on multiple workbooks
D)Computing Sum and Average

Question 8

Which of the following Excel tools allows you to automate the building and running of complex calculations that are not included in the standard set of Excel functions?

A)Function builder
B)Query-by-example tool
C)Wizard
D)VBA

Question 9

Which of the following is a set of Excel actions recorded or written by a user?

A)A macro
B)A hyperlink
C)A botnet
D)A rootkit

Question 10

Which of the following VBA macros can be used in a worksheet formula?

A)An integrity constraint
B)An Object procedure
C)A primary key
D)A Function procedure

Question 11

Which of the following refers to a place used to store a piece of information in Excel?

A)A cell
B)A variable
C)A macro
D)A field

Question 12

Units of VBA code are often referred to as ____.

A)subroutines
B)routines
C)macros
D)programs

Question 13

Mr.Joseph is the CEO of a leading manufacturing concern.He wanted his name and designation to appear in italics on all the spreadsheets of the company's annual report.Which of the following Excel action should he use to achieve this?

A)A wizard
B)A rootkit
C)A macro
D)A botnet

Question 14

Which of the following is a programming language that includes build-in commands that mimic the functionality available from menus and dialog boxes within an application?

A)Binary code
B)Object-oriented programming language
C)Macro language
D)HyperText Markup Language

Question 15

Dan was making a science project.He wanted to automate the two steps of adding a background theme to the cells and then printing the worksheet.Which of the following Excel actions can help Dan achieve this?

A)A system program
B)A macro
C)A hyperlink
D)An auto function

Question 16

A(n)_____ in VBA is an item available for you to control in your code.

A)constant
B)object
C)sub macro
D)variable

Question 17

Which of the following is true about Function procedures?

A)Function procedures return a single value.
B)The end of a Function procedure is marked by the keyword End Sub.
C)The macro recorder can produce Function procedures.
D)Function procedures refer to one or more information statements that you provide to VBA.

Question 18

When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE).After a while he wanted to go back to the Excel application interface.Which of the following key(s)should Ben use to toggle between the Excel application interface and the VBE?

A)Ctrl+F9
B)Ctrl+V
C)Alt+F11
D)Alt+V

Question 19

Which of the following is a VBA macro that returns a single value?

A)A Sub procedure
B)A Function procedure
C)An Object procedure
D)A Sub Macro

Question 20

Which of the following keys will you press to activate the VBE when Excel is active?

A)Ctrl+F9
B)Ctrl+V
C)Alt+F11
D)Alt+V

Question 21

Which of the following key(s)will display the Project Explorer window if it is not visible on the VBE Program Window?

A)Ctrl+F11
B)Ctrl+W
C)Alt+W
D)Ctrl+R

Question 22

Which of the following VBA windows will you use to debug your VBA code?

A)The Project Explorer Window
B)The Code Window
C)The Properties Window
D)The Immediate Window

Question 23

Which of the following is true about the Immediate window?

A)It shows you the properties that can be changed for the currently active object in the Project Explorer window.
B)It displays a tree diagram that consists of every workbook currently open in Excel.
C)It can be displayed by pressing Ctrl + R.
D)It is most useful for executing VBA statements directly.

Question 24

Which of the following elements of VBA programming may change during the execution of a procedure?

A)A constant
B)A variable
C)A comment
D)A macro

Question 25

Excel and VBA can work with both numbers and text.Text is often referred to as ____.

A)a variable
B)an object
C)a string
D)a subroutine

Question 26

Which of the following data type uses 2 bytes and whose range of values is true or false?

A)Boolean
B)Integer
C)Double (negative)
D)Double (positive)

Question 27

Sub procedures start with the keyword Sub followed by the name of the procedure and opening and closing:

A)double quotes.
B)parentheses.
C)single quotes.
D)guillemets.

Question 28

Which of the following would be considered a named element whose value would not change during the execution of a procedure?

A)A variable
B)A constant
C)A comment
D)A macro

Question 29

When entering code directly into a module,which key should be used to indent some of the lines to make the code easier to read?

A)Tab
B)Shift
C)Ctrl
D)Alt

Question 30

Which of the following VBA windows shows every workbook that is currently open in Excel?

A)The Project Explorer Window
B)The Code Window
C)The Properties Window
D)The Immediate Window

Question 31

When you record a macro,Excel automatically inserts a VBA _____ to hold the recorded code.

A)constant
B)object
C)module
D)variable

Question 32

While entering a VBA code directly,to continue a single line of code from one line to the next,end the first line with:

A)a space followed by an equal sign.
B)a continue Sub statement.
C)a space followed by an underscore.
D)a space followed by a double quote.

Question 33

With which of the following would you begin a comment line?

A)A single quote
B)A double quote
C)An underscore
D)An equal sign

Question 34

Which of the following data type uses 1 byte per character and whose range of values varies?

A)Boolean
B)String
C)Integer
D)Currency

Question 35

Which of the following key(s)will display the Immediate Window if it is not visible on the VBE Program Window?

A)Ctrl+W
B)Ctrl+G
C)Alt+W
D)Ctrl+I

Question 36

What type of strings theoretically can hold as many as 2 billion characters?

A)Recurring-length strings
B)Definite-length strings
C)Fixed-length strings
D)Variable-length strings

Question 37

Which of the following is the simplest type of VBA statement?

A)A macro
B)A For-Next loop
C)An assignment
D)A comment

Question 38

Which of the following options would describe the process of creating variables simply by using them?

A)Definite variable declaration
B)Implicit variable declaration
C)Explicit variable declaration
D)Composite variable declaration

Question 39

Which of the following statements is true of a user defined function?

A)It can be written when the function needed is already in Excel.
B)It can increase the complexity of a worksheet.
C)It can increase productivity.
D)It can be recorded in a macro recorder.

Question 40

Which of the following is true about the Project Explorer window?

A)It is most useful for executing VBA statements directly.
B)It contains VBA code.
C)It displays a tree diagram that consists of every workbook currently open in Excel.
D)It shows you the properties that can be changed for the currently active object in the Project Explorer window.

Question 41

Which of the following is the simplest type of looping statement?

A)Do-While
B)Do-Else
C)Do-Until
D)For-Next

Question 42

In VBA,dates and times are placed between two:

A)~ symbols.
B)# symbols.
C)* symbols.
D)" symbols.

Question 43

Which of the following terms refers to repeating a block of statements or code numerous times?

A)Redacting
B)Linking
C)Looping
D)Concatenating

Question 44

Which of the following describes the process of defining the names of all the variables you are going to use,before you use them in your code?

A)Definite variable declaration
B)Precision variable declaration
C)Explicit variable declaration
D)Implicit variable declaration

Question 45

In VBA,which of the following logical operators performs the function of exclusion on two expressions?

A)And
B)Eqv
C)XoR
D)Imp

Question 46

Which of the following statements is VBA's most important control structure?

A)For-Next
B)If-Then
C)Do-Until
D)Do-While

Question 47

In which of the following VBA structures,a macro continues to execute the loop until a specified condition is met?

A)For-Next loop
B)If-Then loop
C)Do-While loop
D)Do-Next loop

Question 48

Which of the following VBA structures is recommended in a decision involving three or more options?

A)If-Then
B)Select-Case
C)Looping
D)Do-While

Question 49

Which of the following operators has the highest precedence in VBA?

A)Division
B)Addition
C)Multiplication
D)Exponentiation

Question 50

When you want to execute one or more statements conditionally,what VBA structure would you use?

A)If-Then
B)Do-While
C)For-Next
D)Do-Until

Question 51

In VBA,which of the following logical operators performs the function of conjunction on two expressions?

A)And
B)Eqv
C)XoR
D)Imp

Question 52

Which of the following is a VBA statement that allocates the result of an expression to a variable or an object?

A)A Dim statement
B)A function statement
C)An assignment statement
D)A detail statement

Question 53

Which of the following is used to declare an explicit variable with VBA code?

A)A Dim statement
B)A comment
C)An assignment statement
D)A string

Question 54

Which of the following is true about the way a macro works?

A)It skips over some statements as it executes the code
B)It executes some statements multiple times
C)It tests conditions to determine what the procedure does next
D)It starts at the code's beginning and progresses line by line to the end

Question 55

Which VBA loop structure is controlled by a counter variable,which starts at one value and stops at another value?

A)For-Next
B)Do-Until
C)Do-While
D)Else

Question 56

In VBA,which of the following logical operators performs the function of disjunction on two expressions?

A)Not
B)Or
C)And
D)XoR

Question 57

In VBA,which of the following logical operators performs the function of negation on an expression?

A)XoR
B)Or
C)Imp
D)Not

Question 58

Which of the following is true about the Do-Until loop structure?

A)In a Do-Until loop,the macro executes the loop until the condition is false.
B)A Do-Until loop continues until a specified condition is met.
C)A Do-Until loop is the simplest type of loop.
D)A Do-Until loop is similar to the Do-While structure.

Question 59

In VBA,which of the following symbols represents the exponentiation operator?

A)^
B)*
C)/
D)&

Question 60

When VBA executes a Select Case structure,the structure is exited:

A)as soon as VBA finds a true case.
B)after VBA executes the statements for a true condition.
C)after VBA executes the statements for a false condition.
D)as soon as VBA finds a false case.

Question 61

You can use VBA to create your own worksheet functions.

Question 62

The quickest way to activate the VBE is to press Ctrl + F11 when Excel is active.

Question 63

VBA stands for Virtual Basic for Applications.

Question 64

Units of VBA code are called subroutines.

Question 65

If the Project Window is not visible in VBE,press the Ctrl + W to open it.

Question 66

When saving an Excel workbook,any macro that has been created will automatically get saved within the workbook.

Question 67

When typing code directly into a VBA macro,the Ctrl key is used to indent some of the lines to make the code easier to read.

Question 68

You view and edit VBA macros using the Function procedure.

Question 69

The Visual Basic Editor is used to record a sequence of commands in Excel to save them in a macro.

Question 70

A macro is a set of actions recorded or written by a user.

Question 71

You can customize the Excel toolbars with your own buttons that execute the macros you write.

Question 72

The macro recorder is a software tool that lets you record a sequence of commands in Excel and save them as a macro.

Question 73

Excel must be running before a VBA macro can be edited using the VB editor.

Question 74

A single VBA module can store any number of Sub procedures,Function procedures,and declarations.

Question 75

To use VBA in an Excel worksheet,you must purchase a separate plug-in module.

Question 76

A VBA macro can be used to print your company name and logo at the top of all worksheets.

Question 77

When working in VBE,an object is considered as a collection of projects.

Question 78

A variable in VBA is an item available for you to control in your code.

Question 79

VBA is only a programming language and not a macro language.

Question 80

A Sub procedure is a VBA macro that returns a single value.