(2) | 1.在Excel中工作表的英文名稱為 (第一天測驗-02) |
| (1) | workbook |
| (2) | worksheet |
| (3) | excel |
| (4) | Application |
| | |
(1) | 2.在Excel VBA中要宣告變數I為整數語法為 (第一天測驗-05) |
| (1) | dim I as integer |
| (2) | dim I as single |
| (3) | dim I as string |
| (4) | dim I as date |
| | |
(3) | 3.在Excel VBA中要宣告變數I為字串語法為 (第一天測驗-07) |
| (1) | dim I as integer |
| (2) | dim I as single |
| (3) | dim I as string |
| (4) | dim I as date |
| | |
(1) | 4.在Excel VBA中列的英文為 (第一天測驗-13) |
| (1) | row |
| (2) | column |
| (3) | cell |
| (4) | x |
| | |
(1) | 5.插入按鈕是那個圖示 (第一天測驗-18) |
| (1) | |
| (2) | |
| (3) | |
| (4) | |
| | |
(4) | 6.在Excel VBA中物件方法的圖示為 (第一天測驗-21) |
| (1) | |
| (2) | |
| (3) | |
| (4) | |
| | |
(2) | 7.inputbox的回傳值型別是 (第一天測驗-22) |
| (1) | integer |
| (2) | string |
| (3) | single |
| (4) | date |
| | |
(4) | 8.在圖中的數字1代表 (第一天測驗-23) |
| (1) | row(列) |
| (2) | column(行) |
| (3) | worksheet |
| (4) | cell |
| | |
(1) | 9.在圖中的數字4代表 (第一天測驗-26) |
| (1) | range |
| (2) | cell |
| (3) | workbook |
| (4) | worksheet |
| | |
(1) | 10.在Excel VBA參數與參數中間是用什麼符號區隔 (第一天測驗-30) |
| (1) | 逗點 |
| (2) | 等號 |
| (3) | 冒號 |
| (4) | 減號 |
| | |
(1) | 11.請問此圖那一個的真值表 (第二天測驗-02) |
| (1) | or |
| (2) | and |
| (3) | not |
| (4) | xor |
| | |
(2) | 12.在Excel VBA的即時視窗輸入 print 10 mod 3 請問會顯示 (第二天測驗-06) |
| (1) | 3 |
| (2) | 1 |
| (3) | 1.33 |
| (4) | 0 |
| | |
(3) | 13.在Excel VBA中小於等於的符號是 (第二天測驗-11) |
| (1) | >= |
| (2) | => |
| (3) | <= |
| (4) | =< |
| | |
(2) | 14.在Excel VBA中不等於的符號是 (第二天測驗-12) |
| (1) | != |
| (2) | <> |
| (3) | >=< |
| (4) | == |
| | |
(1) | 15.請問此圖i若變成95,執行時會在即時視窗顯示 (第二天測驗-21) |
| (1) | 甲 |
| (2) | 乙 |
| (3) | 丙 |
| (4) | 丁 |
| | |
(4) | 16.請問此圖i若變成95,執行時會在即時視窗顯示 (第二天測驗-22) |
| (1) | 甲 |
| (2) | 乙 |
| (3) | 丙 |
| (4) | 丁 |
| | |
(3) | 17.在Excel VBA的即時視窗輸入 print 1 & 2 & 3 請問會顯示 (第二天測驗-29) |
| (1) | 1+2+3 |
| (2) | 6 |
| (3) | 123 |
| (4) | 0 |
| | |
(2) | 18.程式碼如下 LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200),請問LRandomNumber的範圍為 (第三天測驗-03) |
| (1) | 200 |
| (2) | 200<=LRandomNumber<=300 |
| (3) | 201 |
| (4) | 201<=LRandomNumber<=301 |
| | |
(2) | 19.程式碼如下 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 |
| | |
(3) | 20.程式碼如下 For i= 1 to 10 cells(1,i).value=i Next i 此程式的執行結果? (第三天測驗-06) |
| (1) | 在儲存格A1:A10填入1到10 |
| (2) | 在儲存格A1:A10都顯示1 |
| (3) | 在儲存格A1:J1填入1到10 |
| (4) | 在儲存格A1:J1填入1到1 |
| | |
(1) | 21.底下程式碼執行結果會在即時視窗出現 Sub test2() Dim i, n As Integer n = 0 For i = 5 To 1 n = n + 1 Next i Debug.Print n & "," & i End Sub (第三天測驗-11) |
| (1) | 0,5 |
| (2) | 0,6 |
| (3) | 5,6 |
| (4) | 5,0 |
| | |
(3) | 22.工作表如圖,若執行底下程式會顯示什麼? 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 |
| | |
(2) | 23.工作表如圖,若執行底下程式會顯示什麼? Sub test2() Dim i As Integer i = 1 Do While Cells(i + 1, 1).Value <> "" i = i + 1 Loop MsgBox i
End Sub (第三天測驗-17) |
| (1) | 15 |
| (2) | 16 |
| (3) | 17 |
| (4) | 18 |
| | |
(1) | 24.工作表如圖,若執行底下程式會顯示什麼? 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 |
| | |
(3) | 25.工作表如圖,若執行底下程式會顯示什麼? 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 |
| | |