| (2) | 1.在Excel中工作表的英文名稱為 (第一天測驗-02) |
| (1) | workbook |
| (2) | worksheet |
| (3) | excel |
| (4) | Application |
| | |
| (1) | 2.在Excel 2007要儲存含有巨集的格式,檔案副檔名為 (第一天測驗-09) |
| (1) | xlsm |
| (2) | xlsx |
| (3) | csv |
| (4) | txt |
| | |
| (1) | 3.在Excel物件的使用方式中是用什麼來表示階層 (第一天測驗-10) |
| (1) | 句號 |
| (2) | 等號 |
| (3) | 冒號 |
| (4) | 減號 |
| | |
| (1) | 4.在Excel VBA中物件屬性的圖示為 (第一天測驗-12) |
| (1) |  |
| (2) |  |
| (3) |  |
| (4) |  |
| | |
| (1) | 5.MsgBox的回傳值型別是 (第一天測驗-20) |
| (1) | integer |
| (2) | string |
| (3) | single |
| (4) | date |
| | |
| (1) | 6.在ExcelVBA中要使用除(只取整數的商)要用那一個? (第二天測驗-04) |
| (1) | \ |
| (2) | / |
| (3) | * |
| (4) | mod |
| | |
| (2) | 7.在Excel VBA的即時視窗輸入 print 5\2 請問會顯示 (第二天測驗-08) |
| (1) | 2.5 |
| (2) | 2 |
| (3) | 1 |
| (4) | 0 |
| | |
| (1) | 8.在Excel VBA的即時視窗輸入 print 2^3請問會顯示 (第二天測驗-09) |
| (1) | 8 |
| (2) | 6 |
| (3) | 23 |
| (4) | 1 |
| | |
| (2) | 9.在Excel VBA中不等於的符號是 (第二天測驗-12) |
| (1) | != |
| (2) | <> |
| (3) | >=< |
| (4) | == |
| | |
| (2) | 10.在ExcelVBA中要將3顯示在即時視窗要如何使用 (第二天測驗-13) |
| (1) | print 3 |
| (2) | debug.print 3 |
| (3) | echo 3 |
| (4) | debug.echo 3 |
| | |
| (2) | 11.在Excel VBA的即時視窗輸入 print mid("N1234",2,1) 請問會顯示 (第二天測驗-18) |
| (1) | N |
| (2) | 1 |
| (3) | 2 |
| (4) | 3 |
| | |
| (4) | 12.在Excel VBA的即時視窗輸入 print instr("1+2=3","=") 請問會顯示 (第二天測驗-19) |
| (1) | 1 |
| (2) | 2 |
| (3) | 3 |
| (4) | 4 |
| | |
| (3) | 13.在Excel VBA的即時視窗輸入 print lcase("How are you")請問會顯示 (第二天測驗-24) |
| (1) | HOW ARE YOU |
| (2) | How are you |
| (3) | how are you |
| (4) | How Are You |
| | |
| (1) | 14.在Excel VBA的中斷模式時，按那一個按鈕可以逐一行執行 (第二天測驗-25) |
| (1) | F8 |
| (2) | F5 |
| (3) | shift+F8 |
| (4) | Ctrl+Shift+F9 |
| | |
| (2) | 15.在Excel VBA的即時視窗輸入 print right("N1234",1) 請問會顯示 (第二天測驗-27) |
| (1) | N |
| (2) | 4 |
| (3) | 1 |
| (4) | 2 |
| | |
| (2) | 16.程式碼如下
For i= 1 to 10
cells(i,1).value=1
Next i
此程式的執行結果? (第三天測驗-05) |
| (1) | 在儲存格A1:A10填入1到10 |
| (2) | 在儲存格A1:A10都顯示1 |
| (3) | 在儲存格A1:J1填入1到10 |
| (4) | 在儲存格A1:J1填入1到1 |
| | |
| (2) | 17.程式碼如下
For i= 1 to 9
For j=1 to 9
cells(i,j).value=i*j
Next j
Next i當i=5,j=3時,執行結果 (第三天測驗-09) |
| (1) | 在儲存格E3顯示15 |
| (2) | 在儲存格C5顯示15 |
| (3) | 在儲存格E3顯示3 |
| (4) | 在儲存格C5顯示5 |
| | |
| (1) | 18.底下程式碼執行結果會在執行視窗出現
Sub test1()
Dim i, n As Integer
n = 0
For i = 1 To 9 Step 4
n = n + 1
Next i
Debug.Print n & "," & i
End Sub (第三天測驗-10) |
| (1) | 3,13 |
| (2) | 4,10 |
| (3) | 3,10 |
| (4) | 10,10 |
| | |
| (3) | 19.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test1()
Dim i As Integer
i = 1
Do While Cells(i, 1).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub (第三天測驗-16) |
| (1) | 15 |
| (2) | 16 |
| (3) | 17 |
| (4) | 18 |
| | |
| (3) | 20.工作表如圖，若執行底下程式會顯示什麼?
Sub test9()
Dim i As Integer
i = 1
Do While Cells(1, i).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub (第三天測驗-24) |
| (1) | 4 |
| (2) | 3 |
| (3) | 5 |
| (4) | 6 |
| | |
| (1) | 21.使用array函數建立陣列,型別必須為 (第四天測驗-01) |
| (1) | variant |
| (2) | int |
| (3) | string |
| (4) | date |
| | |
| (2) | 22.底下程式執行時會在即時視窗顯示什麼
Sub test1()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(1) '顯示陣列索引為1的資料
End Sub (第四天測驗-02) |
| (1) | 1 |
| (2) | 2 |
| (3) | 3 |
| (4) | 4 |
| | |
| (1) | 23.底下程式執行時會在即時視窗顯示什麼
Sub test2()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(5) '顯示陣列索引為5的資料
End Sub (第四天測驗-03) |
| (1) | 出現陣列索引超出範圍 |
| (2) | 3 |
| (3) | 4 |
| (4) | 1 |
| | |
| (2) | 24.Dim StdNo(10) as String這樣的宣告跟底下那一個相同 (第四天測驗-05) |
| (1) | Dim StdNo(1 to 10) as String |
| (2) | Dim StdNo(0 to 10) as String |
| (3) | Dim StdNo(0 to 10) as date |
| (4) | Dim StdNo(10) as Integer |
| | |
| (3) | 25.底下程式執行時會在即時視窗顯示什麼
Sub test5()
Dim std_no As Variant
no = Split(",國文,英文,數學,理化", ",")
Debug.Print no(3) '顯示陣列索引為3的資料
End Sub (第四天測驗-07) |
| (1) | 國文 |
| (2) | 英文 |
| (3) | 數學 |
| (4) | 理化 |
| | |
