Excel VBA基本觀念測驗(二)

開始測驗時間:2026-04-22 19:56:59
最新考題: 印前丙級（依公告）含共同科目1058題任選80題  印前丙級（依課本）含共同科目1058題任選80題  AppSheet快速上手與維護實戰測驗(亂數選25題) 
考卷名稱.: Excel VBA基本觀念測驗(二)
android版安裝(.APK)
使用者名稱:
記住1週時間
查看考試結果密碼:
  紙本測驗
※可以直接用滑鼠點選答案選項作答
字體大小:A  A  A  將未填答自動填: 1到4亂數   1   2   3   4  
  
　 考試題目
( )1.在Excel VBA要強制宣告變數才可以使用，要在程式的最上方加上       (15)
(1)dim
(2)I don't know
(3)Option Explicit
(4)Option
(5)Explicit
( )2.在ExcelVBA中要將3顯示在即時視窗要如何使用       (13)
(1)echo 3
(2)debug.echo 3
(3)I don't know
(4)print 3
(5)debug.print 3
( )3.在Excel VBA的即時視窗輸入 print 10 mod 3 請問會顯示       (6)
(1)3
(2)1
(3)1.33
(4)0
(5)I don't know
( )4.請問此圖那一個的真值表       (3)
(1)not
(2)xor
(3)I don't know
(4)or
(5)and
( )5.在Excel VBA的即時視窗輸入 print ucase("How are you")請問會顯示       (23)
(1)How are you
(2)how are you
(3)How Are You
(4)I don't know
(5)HOW ARE YOU
( )6.在Excel VBA的即時視窗輸入 print 2^3請問會顯示       (9)
(1)1
(2)I don't know
(3)8
(4)6
(5)23
( )7.在Excel VBA的即時視窗輸入 print instr("1+2=3","=") 請問會顯示       (19)
(1)2
(2)3
(3)4
(4)I don't know
(5)1
( )8.在Excel VBA的即時視窗輸入 print len("中文字abc")請問會顯示       (16)
(1)3
(2)0
(3)I don't know
(4)6
(5)9
( )9.在Excel VBA的即時視窗輸入 print mid("N1234",2,1) 請問會顯示       (18)
(1)3
(2)I don't know
(3)N
(4)1
(5)2
( )10.在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
( )11.在Excel VBA的即時視窗輸入 print left("N1234",1) 請問會顯示       (26)
(1)N
(2)4
(3)1
(4)2
(5)I don't know
( )12.請問此圖那一個的真值表       (2)
(1)and
(2)not
(3)xor
(4)I don't know
(5)or
( )13.在ExcelVBA中要使用餘數要用那一個?       (5)
(1)mod
(2)I don't know
(3)\
(4)/
(5)*
( )14.請問此圖程式執行結果       (17)
(1)在變數i>5時會中斷程式
(2)I don't know
(3)在變數i不等於5時會中斷程式
(4)在變數i=5時會中斷程式
(5)在變數i<5時會中斷程式
( )15.在Excel VBA中小於等於的符號是       (11)
(1)=<
(2)I don't know
(3)>=
(4)=>
(5)<=
( )16.請問此圖i若變成95，執行時會在即時視窗顯示       (22)
(1)丙
(2)丁
(3)I don't know
(4)甲
(5)乙
( )17.在Excel VBA的即時視窗輸入 print 5/2 請問會顯示       (7)
(1)2.5
(2)2
(3)1
(4)0
(5)I don't know
( )18.在Excel VBA的中斷模式時，按那一個按鈕可以逐一行執行       (25)
(1)shift+F8
(2)Ctrl+Shift+F9
(3)I don't know
(4)F8
(5)F5
( )19.在Excel VBA中不等於的符號是       (12)
(1)<>
(2)>=<
(3)==
(4)I don't know
(5)!=
( )20.在Excel VBA中大於等於的符號是       (10)
(1)I don't know
(2)>=
(3)=>
(4)<=
(5)<>
( )21.在Excel VBA的即時視窗輸入 print 1+2+3 請問會顯示       (28)
(1)I don't know
(2)123
(3)1+2+3
(4)6
(5)0
( )22.在ExcelVBA中要使用除(只取整數的商)要用那一個?       (4)
(1)I don't know
(2)\
(3)/
(4)*
(5)mod
( )23.請問此圖i若變成95，執行時會在即時視窗顯示       (21)
(1)丁
(2)I don't know
(3)甲
(4)乙
(5)丙
( )24.在Excel VBA的即時視窗輸入 print right("N1234",1) 請問會顯示       (27)
(1)I don't know
(2)N
(3)4
(4)1
(5)2
( )25.在Excel VBA的即時視窗輸入 print 5\2 請問會顯示       (8)
(1)1
(2)0
(3)I don't know
(4)2.5
(5)2
( )26.請問此圖那一個的真值表       (1)
(1)and
(2)not
(3)xor
(4)I don't know
(5)or
( )27.在Excel VBA的即時視窗輸入 print 1 & 2 + 3 請問會顯示       (30)
(1)0
(2)15
(3)I don't know
(4)123
(5)6
( )28.在Excel VBA的即時視窗輸入 print 1 & 2 & 3 請問會顯示       (29)
(1)6
(2)123
(3)0
(4)I don't know
(5)1+2+3
( )29.在Excel VBA的即時視窗輸入 print len(trim(" 1+2=3 ")) 請問會顯示       (20)
(1)0
(2)I don't know
(3)4
(4)5
(5)6
( )30.在Excel VBA的即時視窗輸入? Mid("daylong", 2, 3)請問會顯示       (14)
(1)I don't know
(2)ay
(3)ayl
(4)yl
(5)ylo
  
  

靜思語400句:【325.將氣憤的境，轉為柔和的心境，再轉換為友愛，這個世間將愈益完美。】
1小時內上線人數：435 人

您有在博客來購物嗎?可以透過https://shoppingfun.co/31m3x?uid1=exam&uid2=text&uid3=link 連結去購物會有分潤支持網站營運