Excel VBA基本觀念測驗(二)

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

池田大作名言:【16、青春是人生之花，是生命的自然表現。】
1小時內上線人數：312 人

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