1 Answer questions about the following array: Dim ar (55) as Double 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 Option Base 1 Otherwise, the default lower bound is when specifying 3. Fill in the blanks so the array is declared as type Double, with two dimensions; and the number ofrows and columns is in worksheet cell D4. Assume default settings Dim table) As Dim nRC As Long 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 nvalsRange . Answer questions about the following array.Assume default settings. Dim myAr (5, -8 to 8) As The array name is All array members are of type The Long number of dimensions for this array is The total number of array members (elements) in the array is 8. Calculate the number of columns in the 2-D array named data without knowing how the 2-D array was declared: Use ReDim to declare myTable as a 2-D array with nRows and nCols. The rows and columns should both start with index-1 9. Dim myTable As Double nRowsRange (ce11A) Value nCols Range (ce11B).Value 10 Assume the array named data is declared (1-D, first index- 1) and each member in the array has a number (type Double). Write a loop to place all the array members (elements) into a single column of cells starting at B2 down the page). Dim arLength As Integer, idx As Integer arLength