NEW
Font size
WorksheetsSCMA 175
Total questions: 12
Worksheet time: 6mins
What is not a characteristic of Visual Basic for Application?
The macro programming.
A Microsoft programming language.
The way to write a function in Excel.
Microsoft programming environment.
What is not an accepted variable naming convention?
Thai-Taxrate
UserName
Exit_Loop
My_Sub
Why macro is used?
To enable worksheet
To automate repetitive tasks
To link different formula on a worksheet
To show programming code
What data type can hold any type of data?
Object
Variant
String
Boolean
Which extension is used to save on Excel workbook including macro?
.xlsx
.html
.xlsm
.vba
Which part of VBA window, refers to area where code is written for user defined function?
Module
Sheet1(code)
Function
ThisWorkbook
Which data type in VBA has only 2 values?
Byte
Double
Boolean
Long
What is the difference between Subroutine and Function?
Subroutine can write in Module and Sheets
The comments can put only in Subroutine
Function can call subroutine
Function can return values
What is the shortcut to return multi-value function in Windows OS?
Ctrl+Shift+Enter
Ctrl+Alt+Enter
Alt+Shift+Enter
Enter
Which operator is used to return the remainder of a division?
/
\
Mod
&
What is a structure for decision involving three or more options?
Switch
Select Case
Do-While loop
Function
Which function in VBA is used to formats a number?
Format
InputBox
MsgBox
End Sub
