|
( ) | 1.程式碼如下 For i= 1 to 10 cells(1,i).value=1 Next i 此程式的執行結果?
(第三天測驗-07) |
|
| (1) | I don't know |
|
| (2) | 在儲存格A1:A10填入1到10 |
|
| (3) | 在儲存格A1:A10都顯示1 |
|
| (4) | 在儲存格A1:J1填入1到10 |
|
| (5) | 在儲存格A1:J1填入1到1 |
|
( ) | 2.底下程式碼執行結果會在即時視窗出現 Sub test5() Dim i, n As Integer n = 0 For i = 1 To 10 If i Mod 3 = 1 Then n = n + 1 End If Next i Debug.Print n & "," & i End Sub
(第三天測驗-14) |
|
| (1) | 4,10 |
|
| (2) | 5,10 |
|
| (3) | I don't know |
|
| (4) | 4,11 |
|
| (5) | 3,10 |
|
( ) | 3.程式碼如下 LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200),請問LRandomNumber的範圍為
(第三天測驗-03) |
|
| (1) | 200<=LRandomNumber<=300 |
|
| (2) | 201 |
|
| (3) | 201<=LRandomNumber<=301 |
|
| (4) | I don't know |
|
| (5) | 200 |
|
( ) | 4.為了使亂數每次產生的都不一樣,可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | int |
|
| (2) | dim |
|
| (3) | I don't know |
|
| (4) | rand |
|
| (5) | randomize |
|
( ) | 5.請問此圖 那一個的真值表
(第二天測驗-03) |
|
| (1) | or |
|
| (2) | and |
|
| (3) | not |
|
| (4) | xor |
|
| (5) | I don't know |
|
( ) | 6.底下程式碼執行結果會在即時視窗出現 Sub test6() Dim i, n As Integer n = 0 For i = 1 To 10 If i Mod 3 = 1 Then n = n + 1 End If If n = 3 Then Exit For End If Next i Debug.Print n & "," & i End Sub
(第三天測驗-15) |
|
| (1) | 3,8 |
|
| (2) | 4,10 |
|
| (3) | I don't know |
|
| (4) | 3,7 |
|
| (5) | 4,11 |
|
( ) | 7.在Excel VBA中物件屬性的圖示為
(第一天測驗-12) |
|
| (1) |  |
|
| (2) |  |
|
| (3) | I don't know |
|
| (4) |  |
|
| (5) |  |
|
( ) | 8.在Excel中工作表的英文名稱為
(第一天測驗-02) |
|
| (1) | excel |
|
| (2) | Application |
|
| (3) | I don't know |
|
| (4) | workbook |
|
| (5) | worksheet |
|
( ) | 9.工作表如圖 ,若執行底下程式會顯示什麼? Sub test10() Dim i As Integer i = 1 Do While Cells(6, i).Value <> "" i = i + 1 Loop MsgBox i
End Sub
(第三天測驗-25) |
|
| (1) | I don't know |
|
| (2) | 1 |
|
| (3) | 2 |
|
| (4) | 3 |
|
| (5) | 4 |
|
( ) | 10.程式碼如下 For i= 1 to 10 cells(1,i).value=i Next i 此程式的執行結果?
(第三天測驗-06) |
|
| (1) | 在儲存格A1:A10都顯示1 |
|
| (2) | 在儲存格A1:J1填入1到10 |
|
| (3) | 在儲存格A1:J1填入1到1 |
|
| (4) | I don't know |
|
| (5) | 在儲存格A1:A10填入1到10 |
|
( ) | 11.插入按鈕是那個圖示
(第一天測驗-18) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) | I don't know |
|
( ) | 12.切換設計模式及執行模式圖示是
(第一天測驗-17) |
|
| (1) |  |
|
| (2) |  |
|
| (3) | I don't know |
|
| (4) |  |
|
| (5) |  |
|
( ) | 13.在Excel VBA的即時視窗輸入 print 2^3請問會顯示
(第二天測驗-09) |
|
| (1) | 1 |
|
| (2) | I don't know |
|
| (3) | 8 |
|
| (4) | 6 |
|
| (5) | 23 |
|
( ) | 14.在Excel VBA中要顯示一段文字hello那一段語法是對的
(第一天測驗-11) |
|
| (1) | say "hello" |
|
| (2) | say hello |
|
| (3) | I don't know |
|
| (4) | msgbox hello |
|
| (5) | msgbox "hello" |
|
( ) | 15.在Excel物件的使用方式中是用什麼來表示階層
(第一天測驗-10) |
|
| (1) | I don't know |
|
| (2) | 句號 |
|
| (3) | 等號 |
|
| (4) | 冒號 |
|
| (5) | 減號 |
|
( ) | 16.變數的命名規則
(第一天測驗-19) |
|
| (1) | 變數名稱不可為關鍵字,例如for、next、while、public等 |
|
| (2) | 以上皆是 |
|
| (3) | I don't know |
|
| (4) | 第一個字元需英文字母 |
|
| (5) | 變數名稱不可包含空白、點、,逗號或其他特殊字元 |
|
( ) | 17.在Excel VBA的即時視窗輸入 print 1 & 2 + 3 請問會顯示
(第二天測驗-30) |
|
| (1) | 15 |
|
| (2) | I don't know |
|
| (3) | 123 |
|
| (4) | 6 |
|
| (5) | 0 |
|
( ) | 18.工作表如圖 ,若執行底下程式會顯示什麼? Sub test7() Dim i As Integer i = 1 Do While Cells(i + 1, 3).Value <> "" And Cells(i + 2, 3).Value <> "" i = i + 1 Loop MsgBox Cells(i, 3).Value
End Sub
(第三天測驗-22) |
|
| (1) | 86 |
|
| (2) | 62 |
|
| (3) | 38 |
|
| (4) | 41 |
|
| (5) | I don't know |
|
( ) | 19.在Excel VBA中物件方法的圖示為
(第一天測驗-21) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) | I don't know |
|
( ) | 20.工作表如圖 ,若執行底下程式會顯示什麼? Sub test3() Dim i As Integer i = 1 Do While Cells(i, 2).Value <> "" i = i + 1 Loop MsgBox i
End Sub
(第三天測驗-18) |
|
| (1) | I don't know |
|
| (2) | 5 |
|
| (3) | 6 |
|
| (4) | 7 |
|
| (5) | 8 |
|
( ) | 21.底下程式執行時會在即時視窗顯示什麼 Sub test5() Dim std_no As Variant no = Split(",國文,英文,數學,理化", ",") Debug.Print no(3) '顯示陣列索引為3的資料 End Sub
(第四天測驗-07) |
|
| (1) | I don't know |
|
| (2) | 國文 |
|
| (3) | 英文 |
|
| (4) | 數學 |
|
| (5) | 理化 |
|
( ) | 22.在ExcelVBA中要使用餘數要用那一個?
(第二天測驗-05) |
|
| (1) | mod |
|
| (2) | I don't know |
|
| (3) | \ |
|
| (4) | / |
|
| (5) | * |
|
( ) | 23.使用array函數建立陣列,型別必須為
(第四天測驗-01) |
|
| (1) | int |
|
| (2) | string |
|
| (3) | date |
|
| (4) | I don't know |
|
| (5) | variant |
|
( ) | 24.工作表如圖 ,若執行底下程式會顯示什麼? Sub test6() Dim i As Integer i = 1 Do While Cells(i + 1, 3).Value <> "" Or Cells(i + 2, 3).Value <> "" i = i + 1 Loop MsgBox Cells(i, 3).Value
End Sub
(第三天測驗-21) |
|
| (1) | 62 |
|
| (2) | 41 |
|
| (3) | 50 |
|
| (4) | 59 |
|
| (5) | I don't know |
|
( ) | 25.在Excel VBA中要宣告變數I為整數語法為
(第一天測驗-05) |
|
| (1) | dim I as date |
|
| (2) | I don't know |
|
| (3) | dim I as integer |
|
| (4) | dim I as single |
|
| (5) | dim I as string |