|
( ) | 1.在Excel VBA中下列那一個敍述是錯的
(第一天測驗-03) |
|
| (1) | let i=i+1 |
|
| (2) | i=i |
|
| (3) | i=-i |
|
| (4) | I don't know |
|
| (5) | i+1=i |
|
( ) | 2.變數的命名規則
(第一天測驗-19) |
|
| (1) | 變數名稱不可包含空白、點、，逗號或其他特殊字元 |
|
| (2) | 變數名稱不可為關鍵字，例如for、next、while、public等 |
|
| (3) | 以上皆是 |
|
| (4) | I don't know |
|
| (5) | 第一個字元需英文字母 |
|
( ) | 3.在 圖中的數字4代表
(第一天測驗-26) |
|
| (1) | cell |
|
| (2) | workbook |
|
| (3) | worksheet |
|
| (4) | I don't know |
|
| (5) | range |
|
( ) | 4.請問此圖 那一個的真值表
(第二天測驗-03) |
|
| (1) | and |
|
| (2) | not |
|
| (3) | xor |
|
| (4) | I don't know |
|
| (5) | or |
|
( ) | 5.程式碼如下
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 |
|
| (5) | I don't know |
|
( ) | 6.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | dim |
|
| (2) | I don't know |
|
| (3) | rand |
|
| (4) | randomize |
|
| (5) | int |
|
( ) | 7.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test10()
Dim i As Integer
i = 1
Do While Cells(6, i).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-25) |
|
| (1) | 4 |
|
| (2) | I don't know |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
|
( ) | 8.工作表如圖，若執行底下程式會顯示什麼?
Sub test8()
Dim i As Integer
i = 1
Do While Cells(1, i + 1).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-23) |
|
| (1) | I don't know |
|
| (2) | 4 |
|
| (3) | 3 |
|
| (4) | 5 |
|
| (5) | 6 |
|
( ) | 9.在Excel VBA參數與參數中間是用什麼符號區隔
(第一天測驗-30) |
|
| (1) | 逗點 |
|
| (2) | 等號 |
|
| (3) | 冒號 |
|
| (4) | 減號 |
|
| (5) | I don't know |
|
( ) | 10.在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 |
|
( ) | 11.Dim StdNo(10) as String這樣的宣告跟底下那一個相同
(第四天測驗-05) |
|
| (1) | Dim StdNo(1 to 10) as String |
|
| (2) | Dim StdNo(0 to 10) as String |
|
| (3) | Dim StdNo(0 to 10) as date |
|
| (4) | Dim StdNo(10) as Integer |
|
| (5) | I don't know |
|
( ) | 12.在圖中的數字2代表
(第一天測驗-24) |
|
| (1) | workbook |
|
| (2) | worksheet |
|
| (3) | range |
|
| (4) | cell |
|
| (5) | I don't know |
|
( ) | 13.在Excel物件的使用方式中是用什麼來表示階層
(第一天測驗-10) |
|
| (1) | I don't know |
|
| (2) | 句號 |
|
| (3) | 等號 |
|
| (4) | 冒號 |
|
| (5) | 減號 |
|
( ) | 14.在Excel VBA中小於等於的符號是
(第二天測驗-11) |
|
| (1) | >= |
|
| (2) | => |
|
| (3) | <= |
|
| (4) | =< |
|
| (5) | I don't know |
|
( ) | 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) | 10,10 |
|
| (2) | I don't know |
|
| (3) | 3,13 |
|
| (4) | 4,10 |
|
| (5) | 3,10 |
|
( ) | 16.在圖中的數字3代表
(第一天測驗-25) |
|
| (1) | cell |
|
| (2) | I don't know |
|
| (3) | row |
|
| (4) | column |
|
| (5) | range |
|
( ) | 17.inputbox的回傳值型別是
(第一天測驗-22) |
|
| (1) | I don't know |
|
| (2) | integer |
|
| (3) | string |
|
| (4) | single |
|
| (5) | date |
|
( ) | 18.在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 |
|
( ) | 19.MsgBox的回傳值型別是
(第一天測驗-20) |
|
| (1) | single |
|
| (2) | date |
|
| (3) | I don't know |
|
| (4) | integer |
|
| (5) | string |
|
( ) | 20.在Excel VBA中物件屬性的圖示為
(第一天測驗-12) |
|
| (1) |  |
|
| (2) |  |
|
| (3) | I don't know |
|
| (4) |  |
|
| (5) |  |
|
( ) | 21.程式碼如下
For i= 1 to 9
For j=1 to 9
cells(i,j).value=i*j
Next j
Next i當i=5,j=3時,執行結果
(第三天測驗-09) |
|
| (1) | 在儲存格E3顯示3 |
|
| (2) | 在儲存格C5顯示5 |
|
| (3) | I don't know |
|
| (4) | 在儲存格E3顯示15 |
|
| (5) | 在儲存格C5顯示15 |
|
( ) | 22.在Excel VBA中物件方法的圖示為
(第一天測驗-21) |
|
| (1) | |
|
| (2) | I don't know |
|
| (3) | |
|
| (4) | |
|
| (5) | |
|
( ) | 23.在Excel VBA的即時視窗輸入 print left("N1234",1) 請問會顯示
(第二天測驗-26) |
|
| (1) | 2 |
|
| (2) | I don't know |
|
| (3) | N |
|
| (4) | 4 |
|
| (5) | 1 |
|
( ) | 24.底下程式執行時會在即時視窗顯示什麼
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) | 3 |
|
| (2) | 4 |
|
| (3) | I don't know |
|
| (4) | 1 |
|
| (5) | 2 |
|
( ) | 25.在Excel VBA的中斷模式時，按那一個按鈕可以逐一行執行
(第二天測驗-25) |
|
| (1) | F5 |
|
| (2) | shift+F8 |
|
| (3) | Ctrl+Shift+F9 |
|
| (4) | I don't know |
|
| (5) | F8 |
