|
( ) | 1.程式碼如下
LRandomNumber = Int ((300 - 200 + 1) * Rnd + 200)，請問LRandomNumber的範圍為
(第三天測驗-03) |
|
| (1) | 201 |
|
| (2) | 201<=LRandomNumber<=301 |
|
| (3) | I don't know |
|
| (4) | 200 |
|
| (5) | 200<=LRandomNumber<=300 |
|
( ) | 2.在 圖中的數字6代表
(第一天測驗-28) |
|
| (1) | worksheet |
|
| (2) | range |
|
| (3) | cell |
|
| (4) | I don't know |
|
| (5) | workbook |
|
( ) | 3.在Excel VBA的即時視窗輸入 print 1+2+3 請問會顯示
(第二天測驗-28) |
|
| (1) | 0 |
|
| (2) | I don't know |
|
| (3) | 123 |
|
| (4) | 1+2+3 |
|
| (5) | 6 |
|
( ) | 4.程式碼如下
For i= 1 to 10
cells(1,i).value=i
Next i
此程式的執行結果?
(第三天測驗-06) |
|
| (1) | 在儲存格A1:J1填入1到1 |
|
| (2) | I don't know |
|
| (3) | 在儲存格A1:A10填入1到10 |
|
| (4) | 在儲存格A1:A10都顯示1 |
|
| (5) | 在儲存格A1:J1填入1到10 |
|
( ) | 5.在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 |
|
( ) | 6.請問 此圖i若變成95，執行時會在即時視窗顯示
(第二天測驗-21) |
|
| (1) | 丙 |
|
| (2) | 丁 |
|
| (3) | I don't know |
|
| (4) | 甲 |
|
| (5) | 乙 |
|
( ) | 7.工作表如圖 ，若執行底下程式會顯示什麼?
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) | 18 |
|
| (2) | I don't know |
|
| (3) | 15 |
|
| (4) | 16 |
|
| (5) | 17 |
|
( ) | 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.工作表如圖，若執行底下程式會顯示什麼?
Sub test3()
Dim i As Integer
i = 1
Do While Cells(i, 2).Value <> ""
i = i + 1
Loop
MsgBox i
End Sub
(第三天測驗-18) |
|
| (1) | 5 |
|
| (2) | 6 |
|
| (3) | 7 |
|
| (4) | 8 |
|
| (5) | I don't know |
|
( ) | 10.在Excel VBA參數與參數中間是用什麼符號區隔
(第一天測驗-30) |
|
| (1) | I don't know |
|
| (2) | 逗點 |
|
| (3) | 等號 |
|
| (4) | 冒號 |
|
| (5) | 減號 |
|
( ) | 11.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 |
|
( ) | 12.在Excel中工作表的英文名稱為
(第一天測驗-02) |
|
| (1) | workbook |
|
| (2) | worksheet |
|
| (3) | excel |
|
| (4) | Application |
|
| (5) | I don't know |
|
( ) | 13.下列那一個Excel VBA語法是正確的
(第一天測驗-14) |
|
| (1) | cells(1,1)=123 |
|
| (2) | excel.range("a1").text=123 |
|
| (3) | I don't know |
|
| (4) | range(a1).value=123 |
|
| (5) | cells("a1").value=123 |
|
( ) | 14.在Excel VBA的即時視窗輸入 print right("N1234",1) 請問會顯示
(第二天測驗-27) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | I don't know |
|
| (4) | N |
|
| (5) | 4 |
|
( ) | 15.在Excel物件的使用方式中是用什麼來表示階層
(第一天測驗-10) |
|
| (1) | 冒號 |
|
| (2) | 減號 |
|
| (3) | I don't know |
|
| (4) | 句號 |
|
| (5) | 等號 |
|
( ) | 16.在圖中的數字4代表
(第一天測驗-26) |
|
| (1) | worksheet |
|
| (2) | I don't know |
|
| (3) | range |
|
| (4) | cell |
|
| (5) | workbook |
|
( ) | 17.在Excel VBA的即時視窗輸入 print mid("N1234",2,1) 請問會顯示
(第二天測驗-18) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | 3 |
|
| (4) | I don't know |
|
| (5) | N |
|
( ) | 18.在Excel VBA的即時視窗輸入 print len(trim(" 1+2=3 ")) 請問會顯示
(第二天測驗-20) |
|
| (1) | 4 |
|
| (2) | 5 |
|
| (3) | 6 |
|
| (4) | 0 |
|
| (5) | I don't know |
|
( ) | 19.底下程式執行時會在即時視窗顯示什麼
Sub test1()
Dim no As Variant
no = Array(1, 2, 3, 4, 5)
Debug.Print no(1) '顯示陣列索引為1的資料
End Sub
(第四天測驗-02) |
|
| (1) | 2 |
|
| (2) | 3 |
|
| (3) | 4 |
|
| (4) | I don't know |
|
| (5) | 1 |
|
( ) | 20.底下程式執行時會在即時視窗顯示什麼
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) | 1 |
|
| (2) | 2 |
|
| (3) | 3 |
|
| (4) | 4 |
|
| (5) | I don't know |
|
( ) | 21.在圖中的數字2代表
(第一天測驗-24) |
|
| (1) | cell |
|
| (2) | I don't know |
|
| (3) | workbook |
|
| (4) | worksheet |
|
| (5) | range |
|
( ) | 22.在Excel VBA中不等於的符號是
(第二天測驗-12) |
|
| (1) | >=< |
|
| (2) | == |
|
| (3) | I don't know |
|
| (4) | != |
|
| (5) | <> |
|
( ) | 23.在Excel VBA的即時視窗輸入 print left("N1234",1) 請問會顯示
(第二天測驗-26) |
|
| (1) | 1 |
|
| (2) | 2 |
|
| (3) | I don't know |
|
| (4) | N |
|
| (5) | 4 |
|
( ) | 24.請問 此圖那一個的真值表
(第二天測驗-02) |
|
| (1) | not |
|
| (2) | xor |
|
| (3) | I don't know |
|
| (4) | or |
|
| (5) | and |
|
( ) | 25.在Excel 2007要儲存含有巨集的格式,檔案副檔名為
(第一天測驗-09) |
|
| (1) | I don't know |
|
| (2) | xlsm |
|
| (3) | xlsx |
|
| (4) | csv |
|
| (5) | txt |
