The names shown in the spreadsheet below are to be read into a VBA array called "names". How should "names" be declared in the VBA subroutine? 1 234567892: 10 11. 8 Adam Brian Charlie David Elliot Frank George Dim names as Array Dim names as String Dim names(1 To 7) as Double Dim names(1 To 7) as String