| (1) | 1.在Excel中活頁簿的英文名稱為 (1) |
| * | (1) | workbook |
| (2) | worksheet |
| (3) | excel |
| (4) | Application |
| | |
| (2) | 2.在Excel中工作表的英文名稱為 (2) |
| (1) | workbook |
| * | (2) | worksheet |
| (3) | excel |
| (4) | Application |
| | |
| (1) | 3.在Excel VBA中下列那一個敍述是錯的 (3) |
| * | (1) | i+1=i |
| (2) | let i=i+1 |
| (3) | i=i |
| (4) | i=-i |
| | |
| (1) | 4.在Excel VBA中程式碼註解是用什麼字元 (4) |
| * | (1) | 單引號 |
| (2) | 雙斜線 |
| (3) | 冒號 |
| (4) | 分號 |
| | |
| (1) | 5.在Excel VBA中要宣告變數I為整數語法為 (5) |
| * | (1) | dim I as integer |
| (2) | dim I as single |
| (3) | dim I as string |
| (4) | dim I as date |
| | |
| (2) | 6.在Excel VBA中要宣告變數I為有小數語法為 (6) |
| (1) | dim I as integer |
| * | (2) | dim I as single |
| (3) | dim I as string |
| (4) | dim I as date |
| | |
| (3) | 7.在Excel VBA中要宣告變數I為字串語法為 (7) |
| (1) | dim I as integer |
| (2) | dim I as single |
| * | (3) | dim I as string |
| (4) | dim I as date |
| | |
| (4) | 8.在Excel VBA中要宣告變數I為日期語法為 (8) |
| (1) | dim I as integer |
| (2) | dim I as single |
| (3) | dim I as string |
| * | (4) | dim I as date |
| | |
| (1) | 9.在Excel 2007要儲存含有巨集的格式,檔案副檔名為 (9) |
| * | (1) | xlsm |
| (2) | xlsx |
| (3) | csv |
| (4) | txt |
| | |
| (1) | 10.在Excel物件的使用方式中是用什麼來表示階層 (10) |
| * | (1) | 句號 |
| (2) | 等號 |
| (3) | 冒號 |
| (4) | 減號 |
| | |
| (2) | 11.在Excel VBA中要顯示一段文字hello那一段語法是對的 (11) |
| (1) | msgbox hello |
| * | (2) | msgbox "hello" |
| (3) | say "hello" |
| (4) | say hello |
| | |
| (1) | 12.在Excel VBA中物件屬性的圖示為 (12) |
| * | (1) |  |
| (2) |  |
| (3) |  |
| (4) |  |
| | |
| (1) | 13.在Excel VBA中列的英文為 (13) |
| * | (1) | row |
| (2) | column |
| (3) | cell |
| (4) | x |
| | |
| (3) | 14.下列那一個Excel VBA語法是正確的 (14) |
| (1) | range(a1).value=123 |
| (2) | cells("a1").value=123 |
| * | (3) | cells(1,1)=123 |
| (4) | excel.range("a1").text=123 |
| | |
| (1) | 15.在Excel VBA中變數的宣告要使用那一個指令 (15) |
| * | (1) | dim |
| (2) | let |
| (3) | print |
| (4) | set |
| | |
| (1) | 16.修改Excel按鈕顯示文字是使用那一個屬性 (16) |
| * | (1) | caption |
| (2) | name |
| (3) | text |
| (4) | value |
| | |
| (4) | 17.切換設計模式及執行模式圖示是 (17) |
| (1) |  |
| (2) |  |
| (3) |  |
| * | (4) |  |
| | |
| (1) | 18.插入按鈕是那個圖示 (18) |
| * | (1) |  |
| (2) |  |
| (3) |  |
| (4) |  |
| | |
| (4) | 19.變數的命名規則 (19) |
| (1) | 第一個字元需英文字母 |
| (2) | 變數名稱不可包含空白、點、，逗號或其他特殊字元 |
| (3) | 變數名稱不可為關鍵字，例如for、next、while、public等 |
| * | (4) | 以上皆是 |
| | |
| (1) | 20.MsgBox的回傳值型別是 (20) |
| * | (1) | integer |
| (2) | string |
| (3) | single |
| (4) | date |
| | |
| (4) | 21.在Excel VBA中物件方法的圖示為 (21) |
| (1) | |
| (2) | |
| (3) | |
| * | (4) | |
| | |
| (2) | 22.inputbox的回傳值型別是 (22) |
| (1) | integer |
| * | (2) | string |
| (3) | single |
| (4) | date |
| | |
| (4) | 23.在 圖中的數字1代表 (23) |
| (1) | row(列) |
| (2) | column(行) |
| (3) | worksheet |
| * | (4) | cell |
| | |
| (1) | 24.在圖中的數字2代表 (24) |
| * | (1) | workbook |
| (2) | worksheet |
| (3) | range |
| (4) | cell |
| | |
| (2) | 25.在圖中的數字3代表 (25) |
| (1) | row |
| * | (2) | column |
| (3) | range |
| (4) | cell |
| | |
| (1) | 26.在圖中的數字4代表 (26) |
| * | (1) | range |
| (2) | cell |
| (3) | workbook |
| (4) | worksheet |
| | |
| (1) | 27.在圖中的數字5代表 (27) |
| * | (1) | row |
| (2) | column |
| (3) | range |
| (4) | cell |
| | |
| (2) | 28.在圖中的數字6代表 (28) |
| (1) | workbook |
| * | (2) | worksheet |
| (3) | range |
| (4) | cell |
| | |
| (2) | 29.在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) | 30.在Excel VBA參數與參數中間是用什麼符號區隔 (30) |
| * | (1) | 逗點 |
| (2) | 等號 |
| (3) | 冒號 |
| (4) | 減號 |
| | |
