Quiz 22: Module M: Programming in Excel With VBA
Business
Q 1Q 1
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.
Free
Multiple Choice
A Explanation: VBA,which stands for Visual Basic for Applications,is a programming language developed by Microsoft.Excel,along with the other members of Microsoft Office,includes the VBA language.VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.
Q 2Q 2
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
Free
Multiple Choice
D Explanation: VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.
Free
Multiple Choice
C Explanation: Units of VBA code are often referred to as macros.
Q 4Q 4
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
Free
Multiple Choice
Q 5Q 5
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
Free
Multiple Choice
Q 6Q 6
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
Free
Multiple Choice
Q 7Q 7
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
Free
Multiple Choice
Q 8Q 8
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
Free
Multiple Choice
Q 9Q 9
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.
Free
Multiple Choice
Q 10Q 10
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
Free
Multiple Choice
Q 11Q 11
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
Free
Multiple Choice
Q 12Q 12
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
Free
Multiple Choice
Q 13Q 13
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
Free
Multiple Choice
Q 14Q 14
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.
Free
Multiple Choice
Q 15Q 15
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
Free
Multiple Choice
Q 16Q 16
Which of the following does a VBA macro manipulate?
A)A constant
B)A variable
C)An object
D)A sub macro
Free
Multiple Choice
Q 17Q 17
A(n)_____ in VBA is an item available for you to control in your code.
A)constant
B)object
C)sub macro
D)variable
Free
Multiple Choice
Q 18Q 18
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
Free
Multiple Choice
Q 19Q 19
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
Free
Multiple Choice
Q 20Q 20
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
Free
Multiple Choice
Q 21Q 21
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
Free
Multiple Choice
Q 22Q 22
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
Free
Multiple Choice
Q 23Q 23
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.
Free
Multiple Choice
Q 24Q 24
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
Free
Multiple Choice
Q 25Q 25
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
Free
Multiple Choice
Q 26Q 26
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.
Free
Multiple Choice
Q 27Q 27
When you record a macro,Excel automatically inserts a VBA _____ to hold the recorded code.
A)constant
B)object
C)module
D)variable
Free
Multiple Choice
Q 28Q 28
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
Free
Multiple Choice
Q 29Q 29
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.
Free
Multiple Choice
Q 30Q 30
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.
Free
Multiple Choice
Q 31Q 31
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.
Free
Multiple Choice
Q 32Q 32
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
Free
Multiple Choice
Q 33Q 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
Free
Multiple Choice
Q 34Q 34
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
Free
Multiple Choice
Q 35Q 35
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
Free
Multiple Choice
Q 36Q 36
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)
Free
Multiple Choice
Q 37Q 37
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
Free
Multiple Choice
Q 38Q 38
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
Free
Multiple Choice
Q 39Q 39
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
Free
Multiple Choice
Q 40Q 40
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
Free
Multiple Choice
Q 41Q 41
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
Free
Multiple Choice
Q 42Q 42
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
Free
Multiple Choice
Q 43Q 43
In VBA,dates and times are placed between two:
A)~ symbols.
B)# symbols.
C)* symbols.
D)" symbols.
Free
Multiple Choice
Q 44Q 44
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
Free
Multiple Choice
Q 45Q 45
In VBA,which of the following symbols represents the exponentiation operator?
A)^
B)*
C)/
D)&
Free
Multiple Choice
Q 46Q 46
In VBA,which of the following logical operators performs the function of conjunction on two expressions?
A)And
B)Eqv
C)XoR
D)Imp
Free
Multiple Choice
Q 47Q 47
In VBA,which of the following logical operators performs the function of disjunction on two expressions?
A)Not
B)Or
C)And
D)XoR
Free
Multiple Choice
Q 48Q 48
In VBA,which of the following logical operators performs the function of exclusion on two expressions?
A)And
B)Eqv
C)XoR
D)Imp
Free
Multiple Choice
Q 49Q 49
In VBA,which of the following logical operators performs the function of negation on an expression?
A)XoR
B)Or
C)Imp
D)Not
Free
Multiple Choice
Q 50Q 50
Which of the following operators has the highest precedence in VBA?
A)Division
B)Addition
C)Multiplication
D)Exponentiation
Free
Multiple Choice
Q 51Q 51
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
Free
Multiple Choice
Q 52Q 52
Which of the following statements is VBA's most important control structure?
A)For-Next
B)If-Then
C)Do-Until
D)Do-While
Free
Multiple Choice
Q 53Q 53
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
Free
Multiple Choice
Q 54Q 54
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
Free
Multiple Choice
Q 55Q 55
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.
Free
Multiple Choice
Q 56Q 56
Which of the following terms refers to repeating a block of statements or code numerous times?
A)Redacting
B)Linking
C)Looping
D)Concatenating
Free
Multiple Choice
Q 57Q 57
Which of the following is the simplest type of looping statement?
A)Do-While
B)Do-Else
C)Do-Until
D)For-Next
Free
Multiple Choice
Q 58Q 58
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
Free
Multiple Choice
Q 59Q 59
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
Free
Multiple Choice
Q 60Q 60
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.
Free
Multiple Choice
Free
True False
Free
True False
Free
True False
Q 64Q 64
The macro recorder is a software tool that lets you record a sequence of commands in Excel and save them as a macro.
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 69Q 69
You can customize the Excel toolbars with your own buttons that execute the macros you write.
Free
True False
Q 70Q 70
The Visual Basic Editor is used to record a sequence of commands in Excel to save them in a macro.
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 78Q 78
A single VBA module can store any number of Sub procedures,Function procedures,and declarations.
Free
True False
Q 79Q 79
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.
Free
True False
Q 80Q 80
When saving an Excel workbook,any macro that has been created will automatically get saved within the workbook.
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Free
True False
Q 88Q 88
An assignment statement is a VBA statement that assigns the result of an expression to a variable or an object.
Free
True False
Free
True False
Q 90Q 90
A macro is a VBA procedure that starts executing the code at the beginning and progresses line by line until it reaches the end.
Free
True False
Free
True False
Free
True False
Free
True False
Q 94Q 94
_____ extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.
Free
Short Answer
Free
Short Answer
Q 96Q 96
The _____ is a software tool that lets you record a sequence of commands in Excel and save them as a macro.
Free
Short Answer
Free
Short Answer
Q 98Q 98
A(n)_____ is a set of programming instructions that performs some action on or with objects.
Free
Short Answer
Free
Short Answer
Q 100Q 100
Visual Basic for Applications (VBA)manipulates ____,such as a workbook,a worksheet,a cell range,a chart,or a shape.
Free
Short Answer
Q 101Q 101
A(n)_____ can be used in VBA macro to store such things as values,text,or property settings (such as a font color or alignment).
Free
Short Answer
Free
Short Answer
Q 103Q 103
The quickest way to activate the Visual Basic Editor (VBE)is to press _____ when Excel is active.
Free
Short Answer
Q 104Q 104
In the Visual Basic Editor (VBE),the _____ window displays a tree diagram that consists of every workbook currently open in Excel.
Free
Short Answer
Q 105Q 105
The _____ window is most useful for executing VBA statements directly and for debugging code.
Free
Short Answer
Q 106Q 106
When you're working in the Visual Basic Editor (VBE),each Excel workbook that's open is known as a(n)____.
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer
Q 113Q 113
When assigning variable names,you can use letters,numbers,and some punctuation characters,but the first character must be a(n)____.
Free
Short Answer
Q 114Q 114
In the context of the elements of VBA programming,a(n)_____ is a named element whose value doesn't change.
Free
Short Answer
Free
Short Answer
Q 116Q 116
Excel and Visual Basic for Applications (VBA)can work with both numbers and text.Text is often referred to as a(n)____.
Free
Short Answer
Free
Short Answer
Free
Short Answer
Q 119Q 119
A(n)_____ is a VBA statement that assigns the result of an expression to a variable or an object.
Free
Short Answer
Q 120Q 120
In the context of the precedence order for operators in VBA,_____ has the highest precedence.
Free
Short Answer
Q 121Q 121
Some Visual Basic for Applications (VBA)procedures,such as ____,always start at the code's beginning and progress line by line to the end,never deviating from this top-to-bottom flow.
Free
Short Answer
Q 122Q 122
In the context of the standard structured decision offered by VBA,the _____ structure is suggested for decisions involving three or more options.
Free
Short Answer
Free
Short Answer
Free
Short Answer
Free
Short Answer