Topic 8-Lesson 1: Reading data from an Excel sheet using Visual

1- The return value from the function : “GetDatafromExcelSheet (FilePath As String,

sql As String) As DataTable” is of type String(................).

• True

• False

2- The announcement of a Function is done by using the word "Sub“.(................).

• True

• False

3- You can create a variable of type (DataTable) in-memory ; in which we store data

that were brought from the data file.(................).

• True

• False

4- The function "GetDataFromExcelSheet" has three operands (................).

• True

• False

5- Variable of type ( OleDbConnection) is used in closing the communication channel

that has been opened (................).

• True

• False

6- You can use a variable of type (OleDbCommand) for the purpose of opening a

channel of communication with the data file (................).

• True

• False

7- We declare variables using the word (dim) (................).

• True

• False

8- To open a code window we press the…………key

• a- F5

• b- F7

• c- F2