|
( ) | 1.在Excel 2007要儲存含有巨集的格式,檔案副檔名為
(第一天測驗-09) |
|
| (1) | txt |
|
| (2) | I don't know |
|
| (3) | xlsm |
|
| (4) | xlsx |
|
| (5) | csv |
|
( ) | 2.變數的命名規則
(第一天測驗-19) |
|
| (1) | 變數名稱不可包含空白、點、，逗號或其他特殊字元 |
|
| (2) | 變數名稱不可為關鍵字，例如for、next、while、public等 |
|
| (3) | 以上皆是 |
|
| (4) | I don't know |
|
| (5) | 第一個字元需英文字母 |
|
( ) | 3.程式碼如下
For i= 1 to 10
cells(i,1).value=i
Next i
此程式的執行結果?
(第三天測驗-04) |
|
| (1) | 在儲存格A1:J1填入1到1 |
|
| (2) | I don't know |
|
| (3) | 在儲存格A1:A10填入1到10 |
|
| (4) | 在儲存格A1:A10都顯示1 |
|
| (5) | 在儲存格A1:J1填入1到10 |
|
( ) | 4.請問 此圖程式執行結果
(第二天測驗-17) |
|
| (1) | 在變數i=5時會中斷程式 |
|
| (2) | 在變數i<5時會中斷程式 |
|
| (3) | 在變數i>5時會中斷程式 |
|
| (4) | I don't know |
|
| (5) | 在變數i不等於5時會中斷程式 |
|
( ) | 5.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test3()
Dim i As Integer
i = 1
Do While Cells(i, 2).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-18) |
|
| (1) | 8 |
|
| (2) | I don't know |
|
| (3) | 5 |
|
| (4) | 6 |
|
| (5) | 7 |
|
( ) | 6.在 圖中的數字2代表
(第一天測驗-24) |
|
| (1) | workbook |
|
| (2) | worksheet |
|
| (3) | range |
|
| (4) | cell |
|
| (5) | I don't know |
|
( ) | 7.在Excel VBA中小於等於的符號是
(第二天測驗-11) |
|
| (1) | => |
|
| (2) | <= |
|
| (3) | =< |
|
| (4) | I don't know |
|
| (5) | >= |
|
( ) | 8.底下程式碼執行結果會在即時視窗出現
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) | 3,-1 |
|
| (2) | 5,0 |
|
| (3) | 5,-2 |
|
| (4) | 3,0 |
|
| (5) | I don't know |
|
( ) | 9.在Excel中活頁簿的英文名稱為
(第一天測驗-01) |
|
| (1) | excel |
|
| (2) | Application |
|
| (3) | I don't know |
|
| (4) | workbook |
|
| (5) | worksheet |
|
( ) | 10.修改Excel按鈕顯示文字是使用那一個屬性
(第一天測驗-16) |
|
| (1) | name |
|
| (2) | text |
|
| (3) | value |
|
| (4) | I don't know |
|
| (5) | caption |
|
( ) | 11.在圖中的數字4代表
(第一天測驗-26) |
|
| (1) | worksheet |
|
| (2) | I don't know |
|
| (3) | range |
|
| (4) | cell |
|
| (5) | workbook |
|
( ) | 12.請問 此圖i若變成95，執行時會在即時視窗顯示
(第二天測驗-21) |
|
| (1) | 乙 |
|
| (2) | 丙 |
|
| (3) | 丁 |
|
| (4) | I don't know |
|
| (5) | 甲 |
|
( ) | 13.在圖中的數字6代表
(第一天測驗-28) |
|
| (1) | range |
|
| (2) | cell |
|
| (3) | I don't know |
|
| (4) | workbook |
|
| (5) | worksheet |
|
( ) | 14.底下程式執行時會在即時視窗顯示什麼
Sub test1()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(1) '顯示陣列索引為1的資料
End Sub
(第四天測驗-02) |
|
| (1) | 4 |
|
| (2) | I don't know |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
|
( ) | 15.底下程式碼執行結果會在執行視窗出現
Sub test1()
Dim i, n As Integer
n = 0
For i = 1 To 9 Step 4
n = n + 1
Next i
Debug.Print n & "," & i
End Sub
(第三天測驗-10) |
|
| (1) | 3,13 |
|
| (2) | 4,10 |
|
| (3) | 3,10 |
|
| (4) | 10,10 |
|
| (5) | I don't know |
|
( ) | 16.工作表如圖，若執行底下程式會顯示什麼?
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) | 86 |
|
| (2) | 62 |
|
| (3) | 38 |
|
| (4) | 41 |
|
| (5) | I don't know |
|
( ) | 17.在Excel VBA中要宣告變數I為有小數語法為
(第一天測驗-06) |
|
| (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 |
|
( ) | 18.底下程式碼執行結果會在即時視窗出現
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 |
|
( ) | 19.在Excel VBA中程式碼註解是用什麼字元
(第一天測驗-04) |
|
| (1) | 冒號 |
|
| (2) | 分號 |
|
| (3) | I don't know |
|
| (4) | 單引號 |
|
| (5) | 雙斜線 |
|
( ) | 20.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | rand |
|
| (2) | randomize |
|
| (3) | int |
|
| (4) | dim |
|
| (5) | I don't know |
|
( ) | 21.在Excel VBA中要顯示一段文字hello那一段語法是對的
(第一天測驗-11) |
|
| (1) | msgbox hello |
|
| (2) | msgbox "hello" |
|
| (3) | say "hello" |
|
| (4) | say hello |
|
| (5) | I don't know |
|
( ) | 22.插入按鈕是那個圖示
(第一天測驗-18) |
|
| (1) |  |
|
| (2) |  |
|
| (3) |  |
|
| (4) |  |
|
| (5) | I don't know |
|
( ) | 23.工作表如圖，若執行底下程式會顯示什麼?
Sub test1()
Dim i As Integer
i = 1
Do While Cells(i, 1).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-16) |
|
| (1) | 16 |
|
| (2) | 17 |
|
| (3) | 18 |
|
| (4) | I don't know |
|
| (5) | 15 |
|
( ) | 24.程式碼如下
For i= 1 to 10
cells(i,1).value=1
Next i
此程式的執行結果?
(第三天測驗-05) |
|
| (1) | 在儲存格A1:J1填入1到10 |
|
| (2) | 在儲存格A1:J1填入1到1 |
|
| (3) | I don't know |
|
| (4) | 在儲存格A1:A10填入1到10 |
|
| (5) | 在儲存格A1:A10都顯示1 |
|
( ) | 25.在圖中的數字3代表
(第一天測驗-25) |
|
| (1) | I don't know |
|
| (2) | row |
|
| (3) | column |
|
| (4) | range |
|
| (5) | cell |
