| (1) | 1.在Excel中活頁簿的英文名稱為 (第一天測驗-01) |
| * | (1) | workbook |
| (2) | worksheet |
| (3) | excel |
| (4) | Application |
| | |
| (1) | 2.在Excel VBA中下列那一個敍述是錯的 (第一天測驗-03) |
| * | (1) | i+1=i |
| (2) | let i=i+1 |
| (3) | i=i |
| (4) | i=-i |
| | |
| (1) | 3.在Excel VBA中物件屬性的圖示為 (第一天測驗-12) |
| * | (1) |  |
| (2) |  |
| (3) |  |
| (4) |  |
| | |
| (1) | 4.修改Excel按鈕顯示文字是使用那一個屬性 (第一天測驗-16) |
| * | (1) | caption |
| (2) | name |
| (3) | text |
| (4) | value |
| | |
| (2) | 5.inputbox的回傳值型別是 (第一天測驗-22) |
| (1) | integer |
| * | (2) | string |
| (3) | single |
| (4) | date |
| | |
| (2) | 6.在 圖中的數字3代表 (第一天測驗-25) |
| (1) | row |
| * | (2) | column |
| (3) | range |
| (4) | cell |
| | |
| (1) | 7.在圖中的數字4代表 (第一天測驗-26) |
| * | (1) | range |
| (2) | cell |
| (3) | workbook |
| (4) | worksheet |
| | |
| (2) | 8.在Excel 中要如何在變數d設定為日期1972/3/31 (第一天測驗-29) |
| (1) | d=1972/3/31 |
| * | (2) | d=#1972/3/31# |
| (3) | d="1972/3/31" |
| (4) | d='1972/3/31' |
| | |
| (1) | 9.在ExcelVBA中要使用除(只取整數的商)要用那一個? (第二天測驗-04) |
| * | (1) | \ |
| (2) | / |
| (3) | * |
| (4) | mod |
| | |
| (2) | 10.在Excel VBA的即時視窗輸入 print 10 mod 3 請問會顯示 (第二天測驗-06) |
| (1) | 3 |
| * | (2) | 1 |
| (3) | 1.33 |
| (4) | 0 |
| | |
| (1) | 11.在Excel VBA的即時視窗輸入 print 2^3請問會顯示 (第二天測驗-09) |
| * | (1) | 8 |
| (2) | 6 |
| (3) | 23 |
| (4) | 1 |
| | |
| (3) | 12.在Excel VBA中小於等於的符號是 (第二天測驗-11) |
| (1) | >= |
| (2) | => |
| * | (3) | <= |
| (4) | =< |
| | |
| (2) | 13.在Excel VBA的即時視窗輸入? Mid("daylong", 2, 3)請問會顯示 (第二天測驗-14) |
| (1) | ay |
| * | (2) | ayl |
| (3) | yl |
| (4) | ylo |
| | |
| (2) | 14.請問 此圖程式執行結果 (第二天測驗-17) |
| (1) | 在變數i不等於5時會中斷程式 |
| * | (2) | 在變數i=5時會中斷程式 |
| (3) | 在變數i<5時會中斷程式 |
| (4) | 在變數i>5時會中斷程式 |
| | |
| (1) | 15.在Excel VBA的即時視窗輸入 print left("N1234",1) 請問會顯示 (第二天測驗-26) |
| * | (1) | N |
| (2) | 4 |
| (3) | 1 |
| (4) | 2 |
| | |
| (2) | 16.在Excel VBA的即時視窗輸入 print right("N1234",1) 請問會顯示 (第二天測驗-27) |
| (1) | N |
| * | (2) | 4 |
| (3) | 1 |
| (4) | 2 |
| | |
| (3) | 17.在Excel VBA的即時視窗輸入 print 1 & 2 & 3 請問會顯示 (第二天測驗-29) |
| (1) | 1+2+3 |
| (2) | 6 |
| * | (3) | 123 |
| (4) | 0 |
| | |
| (2) | 18.程式碼如下
LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200)，請問LRandomNumber的範圍為 (第三天測驗-03) |
| (1) | 200 |
| * | (2) | 200<=LRandomNumber<=300 |
| (3) | 201 |
| (4) | 201<=LRandomNumber<=301 |
| | |
| (1) | 19.程式碼如下
sub test()
Dim i As Integer
For i = 1 To 10
Cells(i + 1, 1).Value = 11 - i
Next i
end sub (第三天測驗-08) |
| * | (1) | 在儲存格A2:A11顯示10到1的數字 |
| (2) | 在儲存格B2:B11顯示10到1的數字 |
| (3) | 在儲存格C2:C11顯示10到1的數字 |
| (4) | 在儲存格D2:D11顯示10到1的數字 |
| | |
| (2) | 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顯示15 |
| * | (2) | 在儲存格C5顯示15 |
| (3) | 在儲存格E3顯示3 |
| (4) | 在儲存格C5顯示5 |
| | |
| (3) | 21.工作表如圖 ，若執行底下程式會顯示什麼?
Sub test1()
Dim i As Integer
i = 1
Do While Cells(i, 1).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub (第三天測驗-16) |
| (1) | 15 |
| (2) | 16 |
| * | (3) | 17 |
| (4) | 18 |
| | |
| (2) | 22.工作表如圖，若執行底下程式會顯示什麼?
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 |
| | |
| (2) | 23.工作表如圖，若執行底下程式會顯示什麼?
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 |
| | |
| (1) | 24.工作表如圖，若執行底下程式會顯示什麼?
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) | 4 |
| (2) | 3 |
| (3) | 5 |
| (4) | 6 |
| | |
| (3) | 25.底下程式執行時會在即時視窗顯示什麼
Sub test7()
Dim i As Integer
Dim std_no(5) As Integer
For i = 1 To 5
std_no(i - 1) = i - 1
Next
Debug.Print std_no(3) '顯示陣列索引為3的資料
End Sub (第四天測驗-09) |
| (1) | 1 |
| (2) | 2 |
| * | (3) | 3 |
| (4) | 4 |
| | |
