Question: 1. Answer questions about the following array: Dim ar (55) Double as Assume default settings. The array name is All array members are of type
1. Answer questions about the following array: Dim ar (55) Double as Assume default settings. The array name is All array members are of type The number of array members (elements) in the array is 2. The default lower bound index for an array is when specifying Option Base 1 Otherwise, the default lower bound is 3. Fill in the blanks so the array is declared as type Double, with two dimensions; and the number of rows and columns is in worksheet cell D4. Assume default settings. Dim table) As Dim nRC As Long nRC ReDim table( 1 to nRC,_ to 4. Determine the number of elements (members) in each array. Assume default settings a. Dim ar (-4 to 15) As Boolean b. Dim ar (8, 1 to 11) As Integer 5. Calculate the number of rows in the 2-D array named table without knowing how the 2-D array was declared: nRows 6. Declare a type Double (1-D) array named myAr. Cell B2 contains the number of data values in a column starting in C3. Read all the data values from the table starting with cell C3 into the array. Dim nvals As Integer, idx As Integer nvals Range
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
