|
( ) | 1.底下程式執行時會在即時視窗顯示什麼
Sub test3()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print UBound(no) '顯示陣列最大索引值
End Sub
(第四天測驗-04) |
|
| (1) | 0 |
|
| (2) | I don't know |
|
| (3) | 3 |
|
| (4) | 4 |
|
| (5) | 5 |
|
( ) | 2.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 |
|
( ) | 3.底下程式執行時會在即時視窗顯示什麼
Sub test2()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(5) '顯示陣列索引為5的資料
End Sub
(第四天測驗-03) |
|
| (1) | 3 |
|
| (2) | 4 |
|
| (3) | 1 |
|
| (4) | I don't know |
|
| (5) | 出現陣列索引超出範圍 |
|
( ) | 4.在ExcelVBA中要使用餘數要用那一個?
(第二天測驗-05) |
|
| (1) | mod |
|
| (2) | I don't know |
|
| (3) | \ |
|
| (4) | / |
|
| (5) | * |
|
( ) | 5.在Excel VBA的即時視窗輸入 print instr("1+2=3","=") 請問會顯示
(第二天測驗-19) |
|
| (1) | 2 |
|
| (2) | 3 |
|
| (3) | 4 |
|
| (4) | I don't know |
|
| (5) | 1 |
|
( ) | 6.在Excel VBA的中斷模式時，按那一個按鈕可以逐一行執行
(第二天測驗-25) |
|
| (1) | I don't know |
|
| (2) | F8 |
|
| (3) | F5 |
|
| (4) | shift+F8 |
|
| (5) | Ctrl+Shift+F9 |
|
( ) | 7.底下程式執行時會在即時視窗顯示什麼
Sub test4()
Dim std_no As Variant
no = Split("國文,英文,數學,理化", ",")
Debug.Print no(3) '顯示陣列索引為3的資料
End Sub
(第四天測驗-06) |
|
| (1) | 國文 |
|
| (2) | 英文 |
|
| (3) | 數學 |
|
| (4) | 理化 |
|
| (5) | I don't know |
|
( ) | 8.程式碼如下
For i= 1 to 10
cells(1,i).value=1
Next i
此程式的執行結果?
(第三天測驗-07) |
|
| (1) | 在儲存格A1:A10都顯示1 |
|
| (2) | 在儲存格A1:J1填入1到10 |
|
| (3) | 在儲存格A1:J1填入1到1 |
|
| (4) | I don't know |
|
| (5) | 在儲存格A1:A10填入1到10 |
|
( ) | 9.在Excel VBA的即時視窗輸入 print 1 & 2 & 3 請問會顯示
(第二天測驗-29) |
|
| (1) | 6 |
|
| (2) | 123 |
|
| (3) | 0 |
|
| (4) | I don't know |
|
| (5) | 1+2+3 |
|
( ) | 10.底下程式執行時會在即時視窗顯示什麼
Sub test5()
Dim std_no As Variant
no = Split(",國文,英文,數學,理化", ",")
Debug.Print no(3) '顯示陣列索引為3的資料
End Sub
(第四天測驗-07) |
|
| (1) | I don't know |
|
| (2) | 國文 |
|
| (3) | 英文 |
|
| (4) | 數學 |
|
| (5) | 理化 |
|
( ) | 11.在Excel VBA的即時視窗輸入 print ucase("How are you")請問會顯示
(第二天測驗-23) |
|
| (1) | how are you |
|
| (2) | How Are You |
|
| (3) | I don't know |
|
| (4) | HOW ARE YOU |
|
| (5) | How are you |
|
( ) | 12.請問此圖 那一個的真值表
(第二天測驗-03) |
|
| (1) | not |
|
| (2) | xor |
|
| (3) | I don't know |
|
| (4) | or |
|
| (5) | and |
|
( ) | 13.在Excel VBA的即時視窗輸入 print lcase("How are you")請問會顯示
(第二天測驗-24) |
|
| (1) | How Are You |
|
| (2) | I don't know |
|
| (3) | HOW ARE YOU |
|
| (4) | How are you |
|
| (5) | how are you |
|
( ) | 14.使用debug.print rnd(1)不可能產生那一個數字
(第三天測驗-01) |
|
| (1) | 1 |
|
| (2) | 0 |
|
| (3) | 0.99 |
|
| (4) | 0.5 |
|
| (5) | I don't know |
|
( ) | 15.在Excel 中要如何在變數d設定為日期1972/3/31
(第一天測驗-29) |
|
| (1) | d="1972/3/31" |
|
| (2) | d='1972/3/31' |
|
| (3) | I don't know |
|
| (4) | d=1972/3/31 |
|
| (5) | d=#1972/3/31# |
|
( ) | 16.在ExcelVBA中要使用除(只取整數的商)要用那一個?
(第二天測驗-04) |
|
| (1) | \ |
|
| (2) | / |
|
| (3) | * |
|
| (4) | mod |
|
| (5) | I don't know |
|
( ) | 17.底下程式碼執行結果會在執行視窗出現
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 |
|
( ) | 18.為了使亂數每次產生的都不一樣，可以在產生亂數前加入那一個指令
(第三天測驗-02) |
|
| (1) | rand |
|
| (2) | randomize |
|
| (3) | int |
|
| (4) | dim |
|
| (5) | I don't know |
|
( ) | 19.底下程式碼執行結果會在即時視窗出現
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) | 5,-1 |
|
| (3) | 0,5 |
|
| (4) | I don't know |
|
| (5) | 5,0 |
|
( ) | 20.在Excel VBA中要顯示一段文字hello那一段語法是對的
(第一天測驗-11) |
|
| (1) | say hello |
|
| (2) | I don't know |
|
| (3) | msgbox hello |
|
| (4) | msgbox "hello" |
|
| (5) | say "hello" |
|
( ) | 21.在Excel VBA要強制宣告變數才可以使用，要在程式的最上方加上
(第二天測驗-15) |
|
| (1) | dim |
|
| (2) | I don't know |
|
| (3) | Option Explicit |
|
| (4) | Option |
|
| (5) | Explicit |
|
( ) | 22.在Excel中活頁簿的英文名稱為
(第一天測驗-01) |
|
| (1) | Application |
|
| (2) | I don't know |
|
| (3) | workbook |
|
| (4) | worksheet |
|
| (5) | excel |
|
( ) | 23.請問 此圖i若變成95，執行時會在即時視窗顯示
(第二天測驗-22) |
|
| (1) | 丙 |
|
| (2) | 丁 |
|
| (3) | I don't know |
|
| (4) | 甲 |
|
| (5) | 乙 |
|
( ) | 24.在Excel VBA中要宣告變數I為整數語法為
(第一天測驗-05) |
|
| (1) | dim I as integer |
|
| (2) | dim I as single |
|
| (3) | dim I as string |
|
| (4) | dim I as date |
|
| (5) | I don't know |
|
( ) | 25.底下程式執行時會在即時視窗顯示什麼
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) | 4 |
|
| (2) | I don't know |
|
| (3) | 1 |
|
| (4) | 2 |
|
| (5) | 3 |
