Q&A Hero

Q: The number of rows in a two-dimensional array is always one number less than the highest row subscript.

Q: You refer to each element in a two-dimensional array by the array's name and the element's row and column subscripts.

Q: Elements located in the first column in a two-dimensional array are assigned a column subscript of 1.

Q: Elements in the second row of a two-dimensional array are assigned a row subscript of 2.

Q: Each element in a two-dimensional array is identified by a unique combination of two subscripts that the computer assigns to the element when the array is created.

Q: You can determine the number of elements in a two-dimensional array by multiplying the number of its rows by the number of its columns.

Q: You can visualize a one-dimensional array as a table of variables.

Q: The most commonly used arrays in business applications are one-dimensional and two-dimensional.

Q: An empty array is declared using an empty set of ____. a. slashes b. brackets c. braces d. curly braces

Q: An empty array is an array that contains no ____. a. data b. indexes c. memory d. elements

Q: An array whose number of elements changes while an application is running is referred to as a(n) ____ array. a. dynamic b. updating c. active d. renewing

Q: The optional ____ keyword in the syntax of the ReDim statement tells the computer to keep the current array values when the size of the array changes. a. Keep b. Protect c. Save d. Preserve

Q: You can change the number of elements in an array while the application is running using the ____ statement. a. ReDo b. DoDim c. ReDim d. ReFit

Q: The ____ statement is used when you know the exact number of times the loop instructions should be processed. a. Do"¦While b. For"¦Next c. For"¦Until d. Do"¦Until

Q: Variables declared in a form's Declarations section are referred to as ____ variables. a. global b. local-level c. class-level d. program-level

Q: Variables and arrays declared in a form's Declarations section have ____ scope. a. class b. program c. global d. location

Q: ____ variables are recognized by every procedure contained in the form's Code Editor window. a. Dim b. Local-level c. Program-level d. Class-level

Q: Class-level variables are declared using the ____ keyword. a. Dim b. Public c. Private d. Class

Q: When two or more procedures in an application may need to use the same variable or array, you can declare the memory locations in the form's ____ section. a. Memory b. Storage c. Declarations d. Statements

Q: The elements in a parallel array are related by their ____. a. classes b. data types c. superscripts d. subscripts

Q: ____ arrays are two or more arrays whose elements are related by their position in the arrays. a. Parallel b. Connected c. Equivalent d. Comparable

Q: If you use the ReDim statement to reduce the size of an array, the values in the truncated elements are saved.

Q: Although the ReDim statement allows you to make an array either larger or smaller, in most cases you will use it to decrease the size of the array.

Q: At times, you may not know the precise number of array elements needed to store an application's data.

Q: For the array to be accessible by each button's Click event procedure, it will need to be declared as a class-level array.

Q: You should have each button's Click event procedure determine the number of elements in an array.

Q: You can determine the highest subscript in a one-dimensional array by subtracting 2 from the number of array elements.

Q: Class-level variables retain their values and remain in the computer's internal memory until the application ends.

Q: You declare a class-level memory location using the Dim keyword.

Q: You declare class-level variables in the form's Declarations section.

Q: Two or more procedures in an application may need to use the same variable or array.

Q: Variables and arrays are declared in procedures when the memory locations are needed only by the procedure that declared them.

Q: All the data in an array do not have to be the same data type.

Q: In some applications, you may want to use an array to store items that are related but have different data types, such as employee IDs and salary amounts.

Q: Attempting to access an element with an invalid subscript results in a(n) ____. a. warning b. run time error c. increase in array size d. code correction

Q: If a subscript is valid, it is said to be in ____. a. order b. value c. index d. range

Q: In an array, another term for subscript is ____. a. catalog b. guide c. index d. key

Q: A form's ____ event occurs when an application is started and the form is displayed the first time. a. Start b. Click c. Load d. Begin

Q: Memory locations declared in the form's Declarations section have ____, which means they can be used by any of the procedures in the form's Code Editor window. a. local scope b. class scope c. priority d. procedure scope

Q: To sort a one-dimensional array in descending order, you first sort the values in ascending order, and then use the ____ method to reverse the array elements. a. Array.Reverse b. Array.Change c. Array.Descending d. Array.Flip

Q: Arranging data in a specific order is called ____. a. arranging b. ordering c. organizing d. sorting

Q: To sort the values in a one-dimensional array in ascending order, you use the ____ method. a. Array.Order b. Array.Arrange c. Array.Sort d. Array.Organize

Q: The number of elements in a one-dimensional array is stored in the array's ____. a. Load event b. scope c. highest subscript d. Length property

Q: Assigning initial values to an array is often referred to as ____ the array. a. populating b. initialing c. inserting d. filling

Q: The first variable in a one-dimensional array is assigned a subscript of ____. a. 0 b. 1 c. 2 d. 3

Q: The ____ indicates the variable's position in the array. a. superscript b. subscript c. array identifier d. identifier

Q: You distinguish one variable in a one-dimensional array from another variable in the array using a unique number, called a(n) ____. a. superscript b. identifier c. array identifier d. subscript

Q: When you group together related variables, the group is referred to as a(n) ____ of variables. a. array b. group c. set d. collection

Q: A simple variable, also called a ____ variable, is one that is unrelated to any other variable in memory. a. scale b. scaling c. scalar d. plain

Q: The For"¦Next statement is not appropriate when you do not know the exact number of times the loop instructions should be repeated.

Q: If the subscript of an array is not in the acceptable range, the procedure should try to access the array element to verify the correct range.

Q: When an array is sorted in descending order, the first element in the array contains the largest value and the last element contains the smallest value.

Q: In most applications, the values stored in an array come from a file on the computer's disk and are assigned to the array after it is declared.

Q: The contents of the variables (elements) in an array cannot be displayed.

Q: The elements in a numeric array are initialized to the number 1.

Q: The number of elements is always one number more than the array's highest subscript.

Q: You use the Private keyword to create a class-level array.

Q: A procedure-level memory location has class scope, which means it can be used only within the procedure in which it is declared.

Q: To refer to the first variable in a one-dimensional String array named strFriends, you use strFriends(0)read "strFriends sub zero."

Q: Superscripts are assigned by the computer when an array is created in internal memory.

Q: Each variable in an array has the same name and data type.

Q: The most commonly used arrays in business applications are three-dimensional.

Q: In the cases when you encounter situations where some variables are related, it is easier and more efficient to treat the related variables separately.

Q: At times, you will encounter situations where some of the variables in an application are related to each other.

Q: A Sub procedure's header includes the As dataType section.

Q: The header and footer in a function are identical to the header and footer in a sub procedure.

Q: Function procedures are referred to more simply as structures.

Q: A ____ under a variable in the Code Editor window indicates that it has not been declared. a. bold color b. jagged line c. green color d. dashed line

Q: You know that a variable is passed by value when the keyword ____ appears before the parameter in the function's header. a. ByRef b. ByValue c. ByVal d. ByReference

Q: When invoking a function, the number of arguments should agree with the number of parameters listed in the function's ____. a. data type b. parameterList c. return type d. return list

Q: Like Sub procedure names, function names typically begin with a(n) ____. a. noun b. verb c. adjective d. adverb

Q: In a function, the data type of the expression in the Return statement must agree with the data type specified in the ____ section of the header. a. Type As dataType b. Return As dataType c. As dataType (Return) d. As dataType

Q: The information a function receives is listed in the ____ in the header. a. parameterList b. data type c. return type d. function name

Q: If the function returns a Double number, you enter ____ at the end of the header. a. Number Double b. As Double c. (Double) d. Type as DoubleType(Double)

Q: If the function returns a string, you enter ____ at the end of the header. a. String As b. (String) c. As String d. Type As StringType

Q: You use the ____ section of the function's header to specify the data type of the value returned by the function. a. Like b. Dim c. Type d. As dataType

Q: A ____'s header includes the As dataType section. a. procedure b. function c. caller d. program

Q: The sub procedure's header and footer contain the ____ keyword. a. Sub b. Function c. SubProcedure d. Subroutine

Q: The function's header and footer contain the ____ keyword. a. Sub b. FunctionProcedure c. SubFunction d. Function

Q: A(n) ____ procedure does not return a value. a. Sub b. Function c. Assignment d. Static