|
( ) | 1.在Excel VBA中列的英文為
(第一天測驗-13) |
|
| (1) | column |
|
| (2) | cell |
|
| (3) | x |
|
| (4) | I don't know |
|
| (5) | row |
|
( ) | 2.使用debug.print rnd(1)不可能產生那一個數字
(第三天測驗-01) |
|
| (1) | 0 |
|
| (2) | 0.99 |
|
| (3) | 0.5 |
|
| (4) | I don't know |
|
| (5) | 1 |
|
( ) | 3.插入按鈕是那個圖示
(第一天測驗-18) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) | I don't know |
|
( ) | 4.底下程式碼執行結果會在即時視窗出現
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) | 5,10 |
|
| (2) | I don't know |
|
| (3) | 4,11 |
|
| (4) | 3,10 |
|
| (5) | 4,10 |
|
( ) | 5.使用array函數建立陣列,型別必須為
(第四天測驗-01) |
|
| (1) | I don't know |
|
| (2) | variant |
|
| (3) | int |
|
| (4) | string |
|
| (5) | date |
|
( ) | 6.在Excel中活頁簿的英文名稱為
(第一天測驗-01) |
|
| (1) | excel |
|
| (2) | Application |
|
| (3) | I don't know |
|
| (4) | workbook |
|
| (5) | worksheet |
|
( ) | 7.底下程式執行時會在即時視窗顯示什麼
Sub test3()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print UBound(no) '顯示陣列最大索引值
End Sub
(第四天測驗-04) |
|
| (1) | I don't know |
|
| (2) | 3 |
|
| (3) | 4 |
|
| (4) | 5 |
|
| (5) | 0 |
|
( ) | 8.在Excel VBA中物件方法的圖示為
(第一天測驗-21) |
|
| (1) | I don't know |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) |  |
|
( ) | 9.在Excel VBA中小於等於的符號是
(第二天測驗-11) |
|
| (1) | I don't know |
|
| (2) | >= |
|
| (3) | => |
|
| (4) | <= |
|
| (5) | =< |
|
( ) | 10.在Excel VBA的即時視窗輸入 print len("中文字abc")請問會顯示
(第二天測驗-16) |
|
| (1) | 6 |
|
| (2) | 9 |
|
| (3) | 3 |
|
| (4) | 0 |
|
| (5) | I don't know |
|
( ) | 11.在Excel VBA中要宣告變數I為字串語法為
(第一天測驗-07) |
|
| (1) | dim I as string |
|
| (2) | dim I as date |
|
| (3) | I don't know |
|
| (4) | dim I as integer |
|
| (5) | dim I as single |
|
( ) | 12.在ExcelVBA中要將3顯示在即時視窗要如何使用
(第二天測驗-13) |
|
| (1) | debug.echo 3 |
|
| (2) | I don't know |
|
| (3) | print 3 |
|
| (4) | debug.print 3 |
|
| (5) | echo 3 |
|
( ) | 13.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test10()
Dim i As Integer
i = 1
Do While Cells(6, i).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-25) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | 3 |
|
| (4) | 4 |
|
| (5) | I don't know |
|
( ) | 14.底下程式碼執行結果會在即時視窗出現
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) | I don't know |
|
| (2) | 3,-1 |
|
| (3) | 5,0 |
|
| (4) | 5,-2 |
|
| (5) | 3,0 |
|
( ) | 15.在Excel VBA中下列那一個敍述是錯的
(第一天測驗-03) |
|
| (1) | i=i |
|
| (2) | i=-i |
|
| (3) | I don't know |
|
| (4) | i+1=i |
|
| (5) | let i=i+1 |
|
( ) | 16.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 |
|
( ) | 17.在Excel VBA要強制宣告變數才可以使用，要在程式的最上方加上
(第二天測驗-15) |
|
| (1) | Option |
|
| (2) | Explicit |
|
| (3) | dim |
|
| (4) | I don't know |
|
| (5) | Option Explicit |
|
( ) | 18.在 圖中的數字5代表
(第一天測驗-27) |
|
| (1) | I don't know |
|
| (2) | row |
|
| (3) | column |
|
| (4) | range |
|
| (5) | cell |
|
( ) | 19.請問此圖 那一個的真值表
(第二天測驗-03) |
|
| (1) | and |
|
| (2) | not |
|
| (3) | xor |
|
| (4) | I don't know |
|
| (5) | or |
|
( ) | 20.底下程式執行時會在即時視窗顯示什麼
Sub test8()
Dim i As Integer
Dim std_no(5) As Integer
For i = 1 To 5
std_no(i - 1) = i * 2 - 1
Next
Debug.Print std_no(3) '顯示陣列索引為3的資料
End Sub
(第四天測驗-10) |
|
| (1) | 7 |
|
| (2) | 9 |
|
| (3) | I don't know |
|
| (4) | 3 |
|
| (5) | 5 |
|
( ) | 21.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | dim |
|
| (2) | I don't know |
|
| (3) | rand |
|
| (4) | randomize |
|
| (5) | int |
|
( ) | 22.在Excel VBA的即時視窗輸入 print left("N1234",1) 請問會顯示
(第二天測驗-26) |
|
| (1) | 2 |
|
| (2) | I don't know |
|
| (3) | N |
|
| (4) | 4 |
|
| (5) | 1 |
|
( ) | 23.在Excel VBA的即時視窗輸入 print mid("N1234",2,1) 請問會顯示
(第二天測驗-18) |
|
| (1) | I don't know |
|
| (2) | N |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
|
( ) | 24.在圖中的數字1代表
(第一天測驗-23) |
|
| (1) | cell |
|
| (2) | I don't know |
|
| (3) | row(列) |
|
| (4) | column(行) |
|
| (5) | worksheet |
|
( ) | 25.下列那一個Excel VBA語法是正確的
(第一天測驗-14) |
|
| (1) | excel.range("a1").text=123 |
|
| (2) | I don't know |
|
| (3) | range(a1).value=123 |
|
| (4) | cells("a1").value=123 |
|
| (5) | cells(1,1)=123 |
