Download VBA Coding Questions and Answers and more Quizzes Accounting in PDF only on Docsity! Question 1 0.5 out of 0.5 points In order to keep users from changing VBA code, the developer may ____. Selected Answer: hide the VBA modules and require a password to open them Questi on 2 0.5 out of 0.5 points To be able to assign various worksheet cell references to a variable, declare the variable as a ____ variable type. Selected Answer: Range Questi on 3 0.5 out of 0.5 points When an element of an array is accessed using VBA code, the number that appears inside a set of parentheses after the array name represents ____. Selected Answer: the index or position of the item in the array Questi on 4 0.5 out of 0.5 points An example of a collection in VBA is a ____. Selected Answer: set of worksheets Questi on 5 0.5 out of 0.5 points When adding items to an array using VBA code, the number that appears in a set of parentheses after the array name represents ____. Selected Answer: the logical position in the array to which the value is assigned Questi on 6 0.5 out of 0.5 points When using VBA to process every cell in a two-dimensional worksheet range, ____ would be useful. Selected Answer: nested loops Questi on 7 0.5 out of 0.5 points In an array declaration in VBA, the number that appears inside a set of parentheses after the array name represents the array’s ____. Selected Answer: size Questi on 8 0.5 out of 0.5 points In the following VBA instruction: ActiveCell.FormulaR1C1 = “=Average(RC[- 1]:RC[-4])”, the cell reference is ____. Selected Answer: relative Questi on 9 0.5 out of 0.5 points The object “Cells” is a ____ object. Selected Answer: Collection Questio n 10 0.5 out of 0.5 points To prevent specific error-handling routines from executing when the specific error is not encountered, locate the error-handling routine at the end of the procedure and ____. Selected Answer: precede it with the instruction Exit Sub Questio n 11 0.5 out of 0.5 points
