Excel VBA基本觀念測驗(一)

開始測驗時間:2026-04-22 23:41:57
最新考題: 印前丙級（依公告）含共同科目1058題任選80題  印前丙級（依課本）含共同科目1058題任選80題  AppSheet快速上手與維護實戰測驗(亂數選25題) 
考卷名稱.: Excel VBA基本觀念測驗(一)
android版安裝(.APK)
使用者名稱:
記住1週時間
查看考試結果密碼:
  紙本測驗
※可以直接用滑鼠點選答案選項作答
字體大小:A  A  A  將未填答自動填: 1到4亂數   1   2   3   4  
  
　 考試題目
( )1.在Excel VBA中要宣告變數I為字串語法為       (7)
(1)dim I as string
(2)dim I as date
(3)I don't know
(4)dim I as integer
(5)dim I as single
( )2.在Excel VBA中物件方法的圖示為       (21)
(1)
(2)
(3)
(4)
(5)I don't know
( )3.插入按鈕是那個圖示       (18)
(1)
(2)
(3)
(4)I don't know
(5)
( )4.在圖中的數字4代表       (26)
(1)I don't know
(2)range
(3)cell
(4)workbook
(5)worksheet
( )5.在Excel中活頁簿的英文名稱為       (1)
(1)workbook
(2)worksheet
(3)excel
(4)Application
(5)I don't know
( )6.在Excel 中要如何在變數d設定為日期1972/3/31       (29)
(1)d='1972/3/31'
(2)I don't know
(3)d=1972/3/31
(4)d=#1972/3/31#
(5)d="1972/3/31"
( )7.在Excel VBA中要宣告變數I為有小數語法為       (6)
(1)dim I as string
(2)dim I as date
(3)I don't know
(4)dim I as integer
(5)dim I as single
( )8.在Excel 2007要儲存含有巨集的格式,檔案副檔名為       (9)
(1)I don't know
(2)xlsm
(3)xlsx
(4)csv
(5)txt
( )9.在圖中的數字5代表       (27)
(1)row
(2)column
(3)range
(4)cell
(5)I don't know
( )10.變數的命名規則       (19)
(1)以上皆是
(2)I don't know
(3)第一個字元需英文字母
(4)變數名稱不可包含空白、點、，逗號或其他特殊字元
(5)變數名稱不可為關鍵字，例如for、next、while、public等
( )11.在Excel VBA中要顯示一段文字hello那一段語法是對的       (11)
(1)msgbox hello
(2)msgbox "hello"
(3)say "hello"
(4)say hello
(5)I don't know
( )12.在Excel VBA中要宣告變數I為整數語法為       (5)
(1)dim I as string
(2)dim I as date
(3)I don't know
(4)dim I as integer
(5)dim I as single
( )13.在圖中的數字2代表       (24)
(1)cell
(2)I don't know
(3)workbook
(4)worksheet
(5)range
( )14.在Excel VBA參數與參數中間是用什麼符號區隔       (30)
(1)I don't know
(2)逗點
(3)等號
(4)冒號
(5)減號
( )15.在圖中的數字3代表       (25)
(1)row
(2)column
(3)range
(4)cell
(5)I don't know
( )16.在Excel VBA中物件屬性的圖示為       (12)
(1)
(2)
(3)I don't know
(4)
(5)
( )17.在Excel VBA中變數的宣告要使用那一個指令       (15)
(1)set
(2)I don't know
(3)dim
(4)let
(5)print
( )18.在Excel VBA中要宣告變數I為日期語法為       (8)
(1)dim I as string
(2)dim I as date
(3)I don't know
(4)dim I as integer
(5)dim I as single
( )19.修改Excel按鈕顯示文字是使用那一個屬性       (16)
(1)text
(2)value
(3)I don't know
(4)caption
(5)name
( )20.inputbox的回傳值型別是       (22)
(1)string
(2)single
(3)date
(4)I don't know
(5)integer
( )21.在圖中的數字1代表       (23)
(1)I don't know
(2)row(列)
(3)column(行)
(4)worksheet
(5)cell
( )22.在Excel VBA中下列那一個敍述是錯的       (3)
(1)i=i
(2)i=-i
(3)I don't know
(4)i+1=i
(5)let i=i+1
( )23.在Excel物件的使用方式中是用什麼來表示階層       (10)
(1)減號
(2)I don't know
(3)句號
(4)等號
(5)冒號
( )24.在Excel中工作表的英文名稱為       (2)
(1)worksheet
(2)excel
(3)Application
(4)I don't know
(5)workbook
( )25.MsgBox的回傳值型別是       (20)
(1)string
(2)single
(3)date
(4)I don't know
(5)integer
( )26.在Excel VBA中列的英文為       (13)
(1)x
(2)I don't know
(3)row
(4)column
(5)cell
( )27.在Excel VBA中程式碼註解是用什麼字元       (4)
(1)分號
(2)I don't know
(3)單引號
(4)雙斜線
(5)冒號
( )28.下列那一個Excel VBA語法是正確的       (14)
(1)range(a1).value=123
(2)cells("a1").value=123
(3)cells(1,1)=123
(4)excel.range("a1").text=123
(5)I don't know
( )29.切換設計模式及執行模式圖示是       (17)
(1)I don't know
(2)
(3)
(4)
(5)
( )30.在圖中的數字6代表       (28)
(1)range
(2)cell
(3)I don't know
(4)workbook
(5)worksheet
  
  

勵志智慧小語:【13.為什麼會難？因為没有學。不是你不行，不是你不會，而是你没有學。】
1小時內上線人數：439 人

您有要購買udemy課程嗎?可以透過https://iorange.biz/3FKHX?uid1=exam&uid2=txt&uid3=url 連結去購買會有分潤支持網站營運