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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!