|
|
|
考試題目 |
 |
|
( ) | 1.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test1()
Dim i As Integer
i = 1
Do While Cells(i, 1).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-16) |
|
| (1) | 17 |
|
| (2) | 18 |
|
| (3) | I don't know |
|
| (4) | 15 |
|
| (5) | 16 |
|
( ) | 2.底下程式碼執行結果會在即時視窗出現
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,0 |
|
| (2) | I don't know |
|
| (3) | 3,-1 |
|
| (4) | 5,0 |
|
| (5) | 5,-2 |
|
( ) | 3.程式碼如下
For i= 1 to 10
cells(i,1).value=1
Next i
此程式的執行結果?
(第三天測驗-05) |
|
| (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.工作表如圖，若執行底下程式會顯示什麼?
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) | I don't know |
|
| (2) | 86 |
|
| (3) | 62 |
|
| (4) | 38 |
|
| (5) | 41 |
|
( ) | 5.程式碼如下
LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200)，請問LRandomNumber的範圍為
(第三天測驗-03) |
|
| (1) | 201<=LRandomNumber<=301 |
|
| (2) | I don't know |
|
| (3) | 200 |
|
| (4) | 200<=LRandomNumber<=300 |
|
| (5) | 201 |
|
( ) | 6.程式碼如下
sub test()
Dim i As Integer
For i = 1 To 10
Cells(i + 1, 1).Value = 11 - i
Next i
end sub
(第三天測驗-08) |
|
| (1) | 在儲存格B2:B11顯示10到1的數字 |
|
| (2) | 在儲存格C2:C11顯示10到1的數字 |
|
| (3) | 在儲存格D2:D11顯示10到1的數字 |
|
| (4) | I don't know |
|
| (5) | 在儲存格A2:A11顯示10到1的數字 |
|
( ) | 7.底下程式碼執行結果會在執行視窗出現
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) | I don't know |
|
| (2) | 3,13 |
|
| (3) | 4,10 |
|
| (4) | 3,10 |
|
| (5) | 10,10 |
|
( ) | 8.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | dim |
|
| (2) | I don't know |
|
| (3) | rand |
|
| (4) | randomize |
|
| (5) | int |
|
( ) | 9.程式碼如下
For i= 1 to 10
cells(1,i).value=i
Next i
此程式的執行結果?
(第三天測驗-06) |
|
| (1) | 在儲存格A1:A10都顯示1 |
|
| (2) | 在儲存格A1:J1填入1到10 |
|
| (3) | 在儲存格A1:J1填入1到1 |
|
| (4) | I don't know |
|
| (5) | 在儲存格A1:A10填入1到10 |
|
( ) | 10.底下程式碼執行結果會在即時視窗出現
Sub test2()
Dim i, n As Integer
n = 0
For i = 5 To 1
n = n + 1
Next i
Debug.Print n & "," & i
End Sub
(第三天測驗-11) |
|
| (1) | I don't know |
|
| (2) | 0,5 |
|
| (3) | 0,6 |
|
| (4) | 5,6 |
|
| (5) | 5,0 |
|
( ) | 11.底下程式碼執行結果會在即時視窗出現
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) | 3,7 |
|
| (2) | 4,11 |
|
| (3) | 3,8 |
|
| (4) | 4,10 |
|
| (5) | I don't know |
|
( ) | 12.程式碼如下
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 |
|
( ) | 13.程式碼如下
For i= 1 to 10
cells(1,i).value=1
Next i
此程式的執行結果?
(第三天測驗-07) |
|
| (1) | I don't know |
|
| (2) | 在儲存格A1:A10填入1到10 |
|
| (3) | 在儲存格A1:A10都顯示1 |
|
| (4) | 在儲存格A1:J1填入1到10 |
|
| (5) | 在儲存格A1:J1填入1到1 |
|
( ) | 14.底下程式碼執行結果會在即時視窗出現
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 |
|
( ) | 15.工作表如圖，若執行底下程式會顯示什麼?
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 |
|
( ) | 16.工作表如圖，若執行底下程式會顯示什麼?
Sub test4()
Dim i As Integer
i = 1
Do While Cells(i + 1, 2).Value <> ""
i = i + 1
Loop
MsgBox Cells(i, 2).Value
End Sub
(第三天測驗-19) |
|
| (1) | 37 |
|
| (2) | 63 |
|
| (3) | 68 |
|
| (4) | 0 |
|
| (5) | I don't know |
|
( ) | 17.工作表如圖，若執行底下程式會顯示什麼?
Sub test3()
Dim i As Integer
i = 1
Do While Cells(i, 2).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-18) |
|
| (1) | 6 |
|
| (2) | 7 |
|
| (3) | 8 |
|
| (4) | I don't know |
|
| (5) | 5 |
|
( ) | 18.底下程式碼執行結果會在即時視窗出現
Sub test3()
Dim i, n As Integer
n = 0
For i = 5 To 1 Step -1
n = n + 1
Next i
Debug.Print n & "," & i
End Sub
(第三天測驗-12) |
|
| (1) | 5,-1 |
|
| (2) | 0,5 |
|
| (3) | I don't know |
|
| (4) | 5,0 |
|
| (5) | 5,1 |
|
( ) | 19.使用debug.print rnd(1)不可能產生那一個數字
(第三天測驗-01) |
|
| (1) | 1 |
|
| (2) | 0 |
|
| (3) | 0.99 |
|
| (4) | 0.5 |
|
| (5) | I don't know |
|
( ) | 20.程式碼如下
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 |
|
|
|
|
|
|
