|
( ) | 1.程式碼如下
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) | 在儲存格C5顯示15 |
|
| (2) | 在儲存格E3顯示3 |
|
| (3) | 在儲存格C5顯示5 |
|
| (4) | I don't know |
|
| (5) | 在儲存格E3顯示15 |
|
( ) | 2.在Excel VBA要強制宣告變數才可以使用，要在程式的最上方加上
(第二天測驗-15) |
|
| (1) | I don't know |
|
| (2) | Option Explicit |
|
| (3) | Option |
|
| (4) | Explicit |
|
| (5) | dim |
|
( ) | 3.在Excel VBA中下列那一個敍述是錯的
(第一天測驗-03) |
|
| (1) | i=i |
|
| (2) | i=-i |
|
| (3) | I don't know |
|
| (4) | i+1=i |
|
| (5) | let i=i+1 |
|
( ) | 4.在Excel VBA中要宣告變數I為整數語法為
(第一天測驗-05) |
|
| (1) | dim I as single |
|
| (2) | dim I as string |
|
| (3) | dim I as date |
|
| (4) | I don't know |
|
| (5) | dim I as integer |
|
( ) | 5.在 圖中的數字2代表
(第一天測驗-24) |
|
| (1) | I don't know |
|
| (2) | workbook |
|
| (3) | worksheet |
|
| (4) | range |
|
| (5) | cell |
|
( ) | 6.底下程式碼執行結果會在即時視窗出現
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) | 3,10 |
|
| (2) | 4,10 |
|
| (3) | 5,10 |
|
| (4) | I don't know |
|
| (5) | 4,11 |
|
( ) | 7.工作表如圖 ，若執行底下程式會顯示什麼?
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 |
|
( ) | 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) | 6 |
|
| (2) | I don't know |
|
| (3) | 4 |
|
| (4) | 3 |
|
| (5) | 5 |
|
( ) | 9.程式碼如下
sub test()
Dim i As Integer
For i = 1 To 10
Cells(i + 1, 1).Value = 11 - i
Next i
end sub
(第三天測驗-08) |
|
| (1) | I don't know |
|
| (2) | 在儲存格A2:A11顯示10到1的數字 |
|
| (3) | 在儲存格B2:B11顯示10到1的數字 |
|
| (4) | 在儲存格C2:C11顯示10到1的數字 |
|
| (5) | 在儲存格D2:D11顯示10到1的數字 |
|
( ) | 10.在Excel VBA的即時視窗輸入 print 2^3請問會顯示
(第二天測驗-09) |
|
| (1) | 1 |
|
| (2) | I don't know |
|
| (3) | 8 |
|
| (4) | 6 |
|
| (5) | 23 |
|
( ) | 11.在Excel VBA的即時視窗輸入 print right("N1234",1) 請問會顯示
(第二天測驗-27) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | I don't know |
|
| (4) | N |
|
| (5) | 4 |
|
( ) | 12.工作表如圖，若執行底下程式會顯示什麼?
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 |
|
( ) | 13.在圖中的數字1代表
(第一天測驗-23) |
|
| (1) | worksheet |
|
| (2) | cell |
|
| (3) | I don't know |
|
| (4) | row(列) |
|
| (5) | column(行) |
|
( ) | 14.底下程式執行時會在即時視窗顯示什麼
Sub test4()
Dim std_no As Variant
no = Split("國文,英文,數學,理化", ",")
Debug.Print no(3) '顯示陣列索引為3的資料
End Sub
(第四天測驗-06) |
|
| (1) | 理化 |
|
| (2) | I don't know |
|
| (3) | 國文 |
|
| (4) | 英文 |
|
| (5) | 數學 |
|
( ) | 15.變數的命名規則
(第一天測驗-19) |
|
| (1) | 以上皆是 |
|
| (2) | I don't know |
|
| (3) | 第一個字元需英文字母 |
|
| (4) | 變數名稱不可包含空白、點、，逗號或其他特殊字元 |
|
| (5) | 變數名稱不可為關鍵字，例如for、next、while、public等 |
|
( ) | 16.在Excel中活頁簿的英文名稱為
(第一天測驗-01) |
|
| (1) | excel |
|
| (2) | Application |
|
| (3) | I don't know |
|
| (4) | workbook |
|
| (5) | worksheet |
|
( ) | 17.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | rand |
|
| (2) | randomize |
|
| (3) | int |
|
| (4) | dim |
|
| (5) | I don't know |
|
( ) | 18.底下程式執行時會在即時視窗顯示什麼
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 |
|
( ) | 19.在ExcelVBA中要使用除(只取整數的商)要用那一個?
(第二天測驗-04) |
|
| (1) | / |
|
| (2) | * |
|
| (3) | mod |
|
| (4) | I don't know |
|
| (5) | \ |
|
( ) | 20.在Excel VBA的即時視窗輸入 print 5/2 請問會顯示
(第二天測驗-07) |
|
| (1) | 1 |
|
| (2) | 0 |
|
| (3) | I don't know |
|
| (4) | 2.5 |
|
| (5) | 2 |
|
( ) | 21.在Excel VBA中變數的宣告要使用那一個指令
(第一天測驗-15) |
|
| (1) | set |
|
| (2) | I don't know |
|
| (3) | dim |
|
| (4) | let |
|
| (5) | print |
|
( ) | 22.程式碼如下
LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200)，請問LRandomNumber的範圍為
(第三天測驗-03) |
|
| (1) | I don't know |
|
| (2) | 200 |
|
| (3) | 200<=LRandomNumber<=300 |
|
| (4) | 201 |
|
| (5) | 201<=LRandomNumber<=301 |
|
( ) | 23.程式碼如下
For i= 1 to 10
cells(i,1).value=i
Next i
此程式的執行結果?
(第三天測驗-04) |
|
| (1) | 在儲存格A1:A10填入1到10 |
|
| (2) | 在儲存格A1:A10都顯示1 |
|
| (3) | 在儲存格A1:J1填入1到10 |
|
| (4) | 在儲存格A1:J1填入1到1 |
|
| (5) | I don't know |
|
( ) | 24.在Excel 中要如何在變數d設定為日期1972/3/31
(第一天測驗-29) |
|
| (1) | d='1972/3/31' |
|
| (2) | I don't know |
|
| (3) | d=1972/3/31 |
|
| (4) | d=#1972/3/31# |
|
| (5) | d="1972/3/31" |
|
( ) | 25.底下程式執行時會在即時視窗顯示什麼
Sub test1()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(1) '顯示陣列索引為1的資料
End Sub
(第四天測驗-02) |
|
| (1) | 3 |
|
| (2) | 4 |
|
| (3) | I don't know |
|
| (4) | 1 |
|
| (5) | 2 |
