Excel VBA基本觀念測驗(二)

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

池田大作名言:【54、決定人生的是自己。自己就是這人生戲劇的主人翁。】
1小時內上線人數：248 人

您有要使用NordVPN嗎?可以透過https://joymall.co/3FKHS?uid1=exam&uid2=txt&uid3=url 連結去購買會有分潤支持網站營運