|
( ) | 1.在ExcelVBA中要使用除(只取整數的商)要用那一個?
(第二天測驗-04) |
|
| (1) | / |
|
| (2) | * |
|
| (3) | mod |
|
| (4) | I don't know |
|
| (5) | \ |
|
( ) | 2.在Excel VBA中要顯示一段文字hello那一段語法是對的
(第一天測驗-11) |
|
| (1) | msgbox hello |
|
| (2) | msgbox "hello" |
|
| (3) | say "hello" |
|
| (4) | say hello |
|
| (5) | I don't know |
|
( ) | 3.請問 此圖那一個的真值表
(第二天測驗-02) |
|
| (1) | not |
|
| (2) | xor |
|
| (3) | I don't know |
|
| (4) | or |
|
| (5) | and |
|
( ) | 4.在Excel VBA中物件屬性的圖示為
(第一天測驗-12) |
|
| (1) |  |
|
| (2) |  |
|
| (3) | I don't know |
|
| (4) |  |
|
| (5) |  |
|
( ) | 5.在Excel VBA中變數的宣告要使用那一個指令
(第一天測驗-15) |
|
| (1) | let |
|
| (2) | print |
|
| (3) | set |
|
| (4) | I don't know |
|
| (5) | dim |
|
( ) | 6.在Excel中工作表的英文名稱為
(第一天測驗-02) |
|
| (1) | workbook |
|
| (2) | worksheet |
|
| (3) | excel |
|
| (4) | Application |
|
| (5) | I don't know |
|
( ) | 7.在Excel VBA中物件方法的圖示為
(第一天測驗-21) |
|
| (1) | |
|
| (2) | I don't know |
|
| (3) | |
|
| (4) | |
|
| (5) | |
|
( ) | 8.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test5()
Dim i As Integer
i = 1
Do While Cells(i + 2, 3).Value <> ""
i = i + 1
Loop
MsgBox Cells(i + 1, 3).Value
End Sub
(第三天測驗-20) |
|
| (1) | 38 |
|
| (2) | 41 |
|
| (3) | I don't know |
|
| (4) | 86 |
|
| (5) | 62 |
|
( ) | 9.請問 此圖程式執行結果
(第二天測驗-17) |
|
| (1) | I don't know |
|
| (2) | 在變數i不等於5時會中斷程式 |
|
| (3) | 在變數i=5時會中斷程式 |
|
| (4) | 在變數i<5時會中斷程式 |
|
| (5) | 在變數i>5時會中斷程式 |
|
( ) | 10.在Excel VBA的即時視窗輸入 print lcase("How are you")請問會顯示
(第二天測驗-24) |
|
| (1) | How are you |
|
| (2) | how are you |
|
| (3) | How Are You |
|
| (4) | I don't know |
|
| (5) | HOW ARE YOU |
|
( ) | 11.插入按鈕是那個圖示
(第一天測驗-18) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) | I don't know |
|
( ) | 12.在Excel VBA的即時視窗輸入 print instr("1+2=3","=") 請問會顯示
(第二天測驗-19) |
|
| (1) | 4 |
|
| (2) | I don't know |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
|
( ) | 13.在Excel VBA要強制宣告變數才可以使用，要在程式的最上方加上
(第二天測驗-15) |
|
| (1) | Option |
|
| (2) | Explicit |
|
| (3) | dim |
|
| (4) | I don't know |
|
| (5) | Option Explicit |
|
( ) | 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) | 17 |
|
| (2) | 18 |
|
| (3) | I don't know |
|
| (4) | 15 |
|
| (5) | 16 |
|
( ) | 15.在Excel VBA的即時視窗輸入 print 5/2 請問會顯示
(第二天測驗-07) |
|
| (1) | I don't know |
|
| (2) | 2.5 |
|
| (3) | 2 |
|
| (4) | 1 |
|
| (5) | 0 |
|
( ) | 16.在 圖中的數字2代表
(第一天測驗-24) |
|
| (1) | cell |
|
| (2) | I don't know |
|
| (3) | workbook |
|
| (4) | worksheet |
|
| (5) | range |
|
( ) | 17.在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 |
|
( ) | 18.在Excel VBA的即時視窗輸入 print len(trim(" 1+2=3 ")) 請問會顯示
(第二天測驗-20) |
|
| (1) | 5 |
|
| (2) | 6 |
|
| (3) | 0 |
|
| (4) | I don't know |
|
| (5) | 4 |
|
( ) | 19.在Excel VBA的即時視窗輸入 print ucase("How are you")請問會顯示
(第二天測驗-23) |
|
| (1) | How Are You |
|
| (2) | I don't know |
|
| (3) | HOW ARE YOU |
|
| (4) | How are you |
|
| (5) | how are you |
|
( ) | 20.底下程式碼執行結果會在即時視窗出現
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) | I don't know |
|
| (2) | 3,7 |
|
| (3) | 4,11 |
|
| (4) | 3,8 |
|
| (5) | 4,10 |
|
( ) | 21.在Excel VBA的即時視窗輸入 print 10 mod 3 請問會顯示
(第二天測驗-06) |
|
| (1) | I don't know |
|
| (2) | 3 |
|
| (3) | 1 |
|
| (4) | 1.33 |
|
| (5) | 0 |
|
( ) | 22.使用debug.print rnd(1)不可能產生那一個數字
(第三天測驗-01) |
|
| (1) | 0.99 |
|
| (2) | 0.5 |
|
| (3) | I don't know |
|
| (4) | 1 |
|
| (5) | 0 |
|
( ) | 23.工作表如圖，若執行底下程式會顯示什麼?
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) | 59 |
|
| (2) | I don't know |
|
| (3) | 62 |
|
| (4) | 41 |
|
| (5) | 50 |
|
( ) | 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) | 41 |
|
| (2) | I don't know |
|
| (3) | 86 |
|
| (4) | 62 |
|
| (5) | 38 |
|
( ) | 25.MsgBox的回傳值型別是
(第一天測驗-20) |
|
| (1) | single |
|
| (2) | date |
|
| (3) | I don't know |
|
| (4) | integer |
|
| (5) | string |
