|
( ) | 1.在Excel VBA的即時視窗輸入 print instr("1+2=3","=") 請問會顯示
(第二天測驗-19) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | 3 |
|
| (4) | 4 |
|
| (5) | I don't know |
|
( ) | 2.在Excel VBA中要宣告變數I為日期語法為
(第一天測驗-08) |
|
| (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 |
|
( ) | 3.在Excel VBA中物件方法的圖示為
(第一天測驗-21) |
|
| (1) |  |
|
| (2) |  |
|
| (3) | I don't know |
|
| (4) |  |
|
| (5) |  |
|
( ) | 4.在Excel VBA中下列那一個敍述是錯的
(第一天測驗-03) |
|
| (1) | i=-i |
|
| (2) | I don't know |
|
| (3) | i+1=i |
|
| (4) | let i=i+1 |
|
| (5) | i=i |
|
( ) | 5.請問 此圖程式執行結果
(第二天測驗-17) |
|
| (1) | 在變數i不等於5時會中斷程式 |
|
| (2) | 在變數i=5時會中斷程式 |
|
| (3) | 在變數i<5時會中斷程式 |
|
| (4) | 在變數i>5時會中斷程式 |
|
| (5) | I don't know |
|
( ) | 6.請問此圖 那一個的真值表
(第二天測驗-03) |
|
| (1) | not |
|
| (2) | xor |
|
| (3) | I don't know |
|
| (4) | or |
|
| (5) | and |
|
( ) | 7.在ExcelVBA中要將3顯示在即時視窗要如何使用
(第二天測驗-13) |
|
| (1) | I don't know |
|
| (2) | print 3 |
|
| (3) | debug.print 3 |
|
| (4) | echo 3 |
|
| (5) | debug.echo 3 |
|
( ) | 8.程式碼如下 For i= 1 to 10 cells(1,i).value=1 Next i 此程式的執行結果?
(第三天測驗-07) |
|
| (1) | 在儲存格A1:A10填入1到10 |
|
| (2) | 在儲存格A1:A10都顯示1 |
|
| (3) | 在儲存格A1:J1填入1到10 |
|
| (4) | 在儲存格A1:J1填入1到1 |
|
| (5) | I don't know |
|
( ) | 9.底下程式執行時會在即時視窗顯示什麼 Sub test4() Dim std_no As Variant no = Split("國文,英文,數學,理化", ",") Debug.Print no(3) '顯示陣列索引為3的資料 End Sub
(第四天測驗-06) |
|
| (1) | 數學 |
|
| (2) | 理化 |
|
| (3) | I don't know |
|
| (4) | 國文 |
|
| (5) | 英文 |
|
( ) | 10.在Excel VBA的即時視窗輸入 print 5/2 請問會顯示
(第二天測驗-07) |
|
| (1) | 2.5 |
|
| (2) | 2 |
|
| (3) | 1 |
|
| (4) | 0 |
|
| (5) | I don't know |
|
( ) | 11.底下程式執行時會在即時視窗顯示什麼 Sub test6() Dim i As Integer Dim std_no(5) As Integer For i = 1 To 5 std_no(i) = i Next Debug.Print std_no(3) '顯示陣列索引為3的資料 End Sub
(第四天測驗-08) |
|
| (1) | 4 |
|
| (2) | I don't know |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
|
( ) | 12.在Excel VBA中變數的宣告要使用那一個指令
(第一天測驗-15) |
|
| (1) | I don't know |
|
| (2) | dim |
|
| (3) | let |
|
| (4) | print |
|
| (5) | set |
|
( ) | 13.底下程式碼執行結果會在即時視窗出現 Sub test4() Dim i, n As Integer n = 0 For i = 5 To 1 Step -1 n = n + 1 i = i - 1 Next i Debug.Print n & "," & i End Sub
(第三天測驗-13) |
|
| (1) | 5,0 |
|
| (2) | 5,-2 |
|
| (3) | 3,0 |
|
| (4) | I don't know |
|
| (5) | 3,-1 |
|
( ) | 14.工作表如圖 ,若執行底下程式會顯示什麼? 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) | 18 |
|
| (2) | I don't know |
|
| (3) | 15 |
|
| (4) | 16 |
|
| (5) | 17 |
|
( ) | 15.在Excel中活頁簿的英文名稱為
(第一天測驗-01) |
|
| (1) | Application |
|
| (2) | I don't know |
|
| (3) | workbook |
|
| (4) | worksheet |
|
| (5) | excel |
|
( ) | 16.在Excel VBA的即時視窗輸入 print 1 & 2 + 3 請問會顯示
(第二天測驗-30) |
|
| (1) | 15 |
|
| (2) | I don't know |
|
| (3) | 123 |
|
| (4) | 6 |
|
| (5) | 0 |
|
( ) | 17.在 圖中的數字5代表
(第一天測驗-27) |
|
| (1) | range |
|
| (2) | cell |
|
| (3) | I don't know |
|
| (4) | row |
|
| (5) | column |
|
( ) | 18.切換設計模式及執行模式圖示是
(第一天測驗-17) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) | I don't know |
|
| (5) |  |
|
( ) | 19.在Excel VBA的即時視窗輸入 print 2^3請問會顯示
(第二天測驗-09) |
|
| (1) | 6 |
|
| (2) | 23 |
|
| (3) | 1 |
|
| (4) | I don't know |
|
| (5) | 8 |
|
( ) | 20.使用debug.print rnd(1)不可能產生那一個數字
(第三天測驗-01) |
|
| (1) | 0.99 |
|
| (2) | 0.5 |
|
| (3) | I don't know |
|
| (4) | 1 |
|
| (5) | 0 |
|
( ) | 21.Dim StdNo(10) as String這樣的宣告跟底下那一個相同
(第四天測驗-05) |
|
| (1) | I don't know |
|
| (2) | Dim StdNo(1 to 10) as String |
|
| (3) | Dim StdNo(0 to 10) as String |
|
| (4) | Dim StdNo(0 to 10) as date |
|
| (5) | Dim StdNo(10) as Integer |
|
( ) | 22.在Excel VBA的即時視窗輸入 print 5\2 請問會顯示
(第二天測驗-08) |
|
| (1) | 1 |
|
| (2) | 0 |
|
| (3) | I don't know |
|
| (4) | 2.5 |
|
| (5) | 2 |
|
( ) | 23.請問 此圖i若變成95,執行時會在即時視窗顯示
(第二天測驗-21) |
|
| (1) | I don't know |
|
| (2) | 甲 |
|
| (3) | 乙 |
|
| (4) | 丙 |
|
| (5) | 丁 |
|
( ) | 24.工作表如圖 ,若執行底下程式會顯示什麼? Sub test3() Dim i As Integer i = 1 Do While Cells(i, 2).Value <> "" i = i + 1 Loop MsgBox i
End Sub
(第三天測驗-18) |
|
| (1) | 6 |
|
| (2) | 7 |
|
| (3) | 8 |
|
| (4) | I don't know |
|
| (5) | 5 |
|
( ) | 25.在Excel VBA中大於等於的符號是
(第二天測驗-10) |
|
| (1) | => |
|
| (2) | <= |
|
| (3) | <> |
|
| (4) | I don't know |
|
| (5) | >= |