Master Demo Never Delete

ITI Copa MCQ IN Gujarati | ITI Copa MCQ IN Hindi | ITI Copa MCQ IN English

NCVT AITT (All India Trade Test) CBT exam Practice COPA trade MCQ (Multiple choice Question) online. Also you can practice mock test exam online.

I.T.I COPA Trade MCQ also useful for competitive exam like PSU Job exam As well as Government Job Exam, Apprentice job.

1.

Which VBA built in function returns location at the second string occurs within the first string?

1. Mid ( )
2. Chr ( )
3. ASC ( )
4. Instr ( )

2.

Which keyword is used to declare the variables in project scope?

1. Static
2. Private
3. Public
4. Protect

3.

In VBA, How many types of access specifiers available in VBA?

1. 2
2. 3
3. 4
4. 6

4.

Which type of variable cannot be declared within a procedure in VBA?

1. Project scope
2. Local scope
3. Global scope
4. Module scope

5.

Which variable recognized only within the procedure in which it is declared?

1. Local scope
2. Module scope
3. Global scope
4. Project scope

6.

How many levels of variable scope available in VBA?

1. 2
2. 3
3. 4
4. 7

7.

What will be the output of the following VBA code? Debug.printformat(#1/1/2017#,”yyyy/mm/dd”)

1. 1/1/2017
2. Sun, Jan01, 2017
3. 2017/01/01
4. Sunday, January 01,2017

8.

Which function returns true if the expression is a valid date, otherwise it returns false in VBA?

1. CDate ( )
2. IsDate ( )
3. Day ( )
4. Dateadd ( )

9.

What is the full form of UDF in VBA?

1. User Data Functions
2. User Defined Functions
3. Undefined Functions
4. Used Data Functions

10.

Which function returns the day of the month (number from 1 to 31) given date value in VBA?

1. Day ( )
2. Date ( )
3. Month ( )
4. Date part ( )

11.

Which function returns the current system date and time in VBA?

1. Date ( )
2. Day ( )
3. Hour ( )
4. Now ( )

12.

Which function extracts the first 5 characters from a string in VBA?

1. Right (str,5)
2. Left (str,5)
3. Mid (str,5)
4. Substr (str,5)

13.

Which color of dot indicate the breakpoint in VBA?

1. Grey
2. Yellow
3. Maroon
4. Red

14.

Which shortcut key is used to set the properties of form while designing?

1. F4
2. Ctrl + F4
3. Alt + F4
4. Shift + F4

15.

Which shortcut key is used to open code window in VBA?

1. F7
2. Alt + F7
3. Ctrl + F7
4. Shift + F7

16.

Which code is used to display a user form in VBA?

1. Load user Form1
2. User Form1.Show
3. User Form1.Show False
4. User Form1.Load

17.

Which mathematical function returns square root of a specified number in VBA?

1. Sqt ( )
2. Squr ( )
3. Sqrt ( )
4. Sqr ( )

18.

Which VBA function is used to convert the string from uppercase to lowercase?

1. Lcase ( )
2. Lower ( )
3. Ucase ( )
4. Upper ( )

19.

Which of the following is logical operator in VBA?

1. +
2. -
3. *
4. And

20.

Which character is to be suffixed for long data type in VBA?

1. &
2. !
3. #
4. @

21.

What is the storage size of decimal data type in VBA?

1. 2 bytes
2. 4 bytes
3. 8 bytes
4. 12 bytes

22.

What is the storage size of currency data type in VBA?

1. 2 bytes
2. 4 bytes
3. 8 bytes
4. 12 bytes

23.

How many numeric data types available in Excel VBA?

1. 4
2. 5
3. 7
4. 8

24.

What is the another name for keywords in VBA?

1. Literals
2. Variables
3. User defined words
4. Reserved words

25.

Which key word is used to declare the variable in VBA?

1. Sub
2. Declare
3. Dim
4. AS

26.

Which data type can hold any type of values in VBA?

1. Variant
2. Variable
3. Constant
4. Keyword

27.

Which entitie hold data in VBA?

1. Literals
2. Constants
3. Keywords
4. Variables

28.

Which worksheet method is used to copy a sheet to another location in the workbook?

1. Activate
2. Copy
3. Save AS
4. Select

29.

Which VBA worksheet property return or sets a string value that represents the object name?

1. Name
2. Index
3. Range
4. Cells

30.

Which method displays the data form associated with the worksheet in VBA?

1. Copy
2. Printout
3. Show Data Form
4. Select

31.

Which VBA property returns a range object that represents all the cells on the worksheet?

1. Cells
2. Rows
3. Index
4. Name

32.

Which object is member of the workbook?

1. Sheets
2. Workbook
3. Worksheet
4. Range

33.

Which type of work book method cannot be modified in VBA?

1. Close
2. Save
3. Save AS
4. Protect

34.

Which workbook property returns a string value that represents the name of the object in VBA?

1. Full name
2. Name
3. Path
4. Worksheets

35.

Which workbook property returns the name of the object including its path on disk in VBA?

1. Full name
2. Name
3. Path
4. Worksheets

36.

Which can hold lot of data with one variable in VBA?

1. Arrays
2. Collections
3. Groups
4. Methods

37.

Which type of list box enables one choice of adjacent choice in VBA?

1. Drop down list
2. Single - selection list box
3. Multiple - selection list box
4. Extended - selection list box

38.

Which button has three states in VBA?

1. Option button
2. Spin button
3. Push button
4. Command button

39.

Which box groups related controls into one visual unit in a rectangle with an optional label?

1. Label box
2. Group box
3. List box
4. Combo box

40.

Which is used to create user interface forms?

1. C
2. VBA
3. HTML
4. Javascript

41.

Where does Excel come in object hierarchy of VBA?

1. Range object
2. Workbook object
3. Worksheet object
4. Application object

42.

Which shortcut key is used to open project explorer window in VBA?

1. Ctrl + R
2. Ctrl + P
3. Ctrl + W
4. Ctrl + E

43.

Which shortcut key is used to open VBA Editor from the Excel worksheet?

1. Ctrl + F11
2. Alt + F11
3. Ctrl + V
4. Ctrl + F7

44.

What is the Full form of IDE?

1. Integrated Development Element
2. Internal Development Environment
3. Integrated Development Environment
4. Internal Distributed Environment

45.

Which shortcut key is used to step into line - by - line execution in VBA?

1. F2
2. F4
3. F5
4. F8

46.

What is called the set of commands bundled together under one name?

1. Properties
2. Macros
3. Procedures
4. Events

47.

What is called the set of statement that are executed under one name?

1. Macros
2. Properties
3. Procedures
4. Events

48.

Which one is attributes of an object in VBA?

1. Procedures
2. Events
3. Macros
4. Properties

49.

What is called double clicking an object in VBA?

1. Events
2. Macros
3. Procedures
4. Methods

50.

Which is used to type / edit the programming code in VBA?

1. Form window
2. Properties window
3. Immediate window
4. Visual basic editor

51.

What is the alternate name of Bugs?

1. Errors
2. Keywords
3. Variables
4. Constants

52.

Which shortcut key is used to open the Visual Basic Editor In VBA?

1. Alt + F11
2. Ctrl + F11
3. Shift + F11
4. Shift + Ctrl + F11

53.

Which simplifies the work to be eliminating or rewriting the code in VBA?

1. Class
2. Object
3. Macros
4. Functions

54.

Which type of variable can be accessed or used by subroutines outside the modules in VBA?

1. Static
2. Private
3. Protect
4. Public

55.

Where there is no difference between dim and private in VBA?

1. Local scope
2. Module scope
3. Global scope
4. Project scope

56.

Which method is used to pass the reference to the arguments?

1. Ref
2. Val
3. Reference
4. By Ref

57.

Which function is used to check whether the given input is numeric or Not in VBA?

1. Numeric ( )
2. Is number ( )
3. Is numeric ( )
4. Is num ( )

58.

Which function returns specified part of a given date in VBA?

1. Day ( )
2. Datevalue ( )
3. Date diff ( )
4. Date part ( )

59.

Which function returns the difference between two date values based on the interval specified in VBA?

1. Date diff ( )
2. Day ( )
3. Day diff ( )
4. Date dif ( )

60.

What is the return type of CSng function in VBA?

1. Boolean
2. Variant
3. Single
4. String

61.

Which VBA code is used to load user form into memory but do not display?

1. User form1.Show
2. Load userform1
3. Userform1.load
4. Show userform1

62.

Which VBA code is used to remove the user form from memory?

1. Unload me
2. Userform1.hide
3. Unload userform1
4. User form show false

63.

Which window displays the watched expression including the one just added?

1. Module window
2. Immediate window
3. Watch window
4. Debug window

64.

Which one is indicated by a red dot with a line of code highlighted in red in VBA?

1. Break point
2. Start point
3. End point
4. Error point

65.

Which is used to repeats the same steps in case of frequency needed actions in VBA?

1. Class
2. Object
3. Functions
4. Macros

66.

Which function returns the integer portion of a number in VBA?

1. Int ( )
2. Format ( )
3. Abs ( )
4. Sign ( )

67.

Which function returns the hyperbolic cosine of the specified angle in VBA?

1. Abs ( )
2. Cos ( )
3. Cosh ( )
4. hcos ( )

68.

Which mathematical function generates a random number in VBA?

1. Random ( )
2. Rnd ( )
3. Rand ( )
4. Round ( )

69.

Which operators are concatenation operator in VBA?

1. + and -
2. & and -
3. & and +
4. & and *

70.

Which type of words cannot use for any other purpose in VBA?

1. Literals
2. Keywords
3. Constants
4. Variables

71.

Which is a series of items where all items share the same properties and methods in VBA?

1. Arrays
2. Groups
3. Methods
4. Collections

72.

Which button allows a single choice within a limited set of mutually exclusive choice?

1. Button
2. Option button
3. Spin button
4. Toggle button

73.

Which box has three states in VBA?

1. List box
2. Combo box
3. Check box
4. Group box

74.

Which one creates a box with a scrollable list containing a number of input values in VBA?

1. Combo box
2. Option button
3. Text box
4. List box

75.

Which control is suitable to collect the input from the user in VBA?

1. Label
2. Text box
3. Command button
4. User form

76.

Which is a proper object hierarchy in VBA?

1. Worksheet, Workbook, Application, Range
2. Range, Application, Worksheet, Workbook
3. Range, Worksheet, Workbook, Application
4. Application, Workbook, Worksheet, Range

77.

What is the shortcut key to run the current procedure in VBA?

1. F2
2. F4
3. F5
4. F8

78.

Which window displays the entire list of local varibles and their current values in VBA?

1. Locals window
2. Watch window
3. Immediate window
4. Debugging window

79.

Which window is similar to the locals window, but it is used to tracing the variables in VBA?

1. Call stack window
2. Watch window
3. Immediate window
4. Debugging window

80.

Which shortcut key is used to open the immediate window?

1. Ctrl + G
2. Ctrl + L
3. Alt + G
4. Alt + L

81.

What is the another name trigger for an action in VBA?

1. Methods
2. Modules
3. Events
4. Macros

82.

Which shortcut key allows debugger to run the current procedure and go line after line called the procedure in VBA?

1. Ctrl + Shift + F6
2. Ctrl + Shift + F7
3. Ctrl + Shift + F8
4. Ctrl + Shift + F9

83.

While debugging code, which statement allows to go to the highlighted line?

1. Step into
2. Step over
3. Step out
4. Show next

84.

Which control is used to increase or decrease a value, such as a number time or date?

1. Scroll Bar
2. Spin Button
3. Combo Box
4. Toggle Button

85.

Which VBA function compares given strings and returns -1 if the first string is smaller than the second string, returns 0 if both are equal and 1 if the first string is greater than second string?

1. Strcmp
2. Strcomp
3. Compare
4. Scmp

86.

Which scope does the variable declared with dim and remains in the existance only as long as the procedure in which if is declared is running?

1. Global scope
2. Local scope
3. Module scope
4. Project scope

87.

What will be the output of the following VBA code? Sub test ( )a = 9Debug.Print Sqr (a) End sub

1. 3
2. 9
3. 18
4. 81

88.

What will be the output for the following VBA code? Debug.print DateDiff(“yyyy”,”1/12/2016”,”31/1/2017”)

1. 0
2. 1
3. 11
4. 30

89.

What will be the output of the following VBA code? Sub test ( )x = “institue”Debug.print Format (x,”>”) End sub

1. Institute
2. institute
3. INSTITUTE
4. instiTUTE

90.

What will be the output of the following VBA code? Sub test ( )Dim S AS stringS = “wholehearted” Debug.Print mid(s,6,4) End sub

1. arte
2. hear
3. hole
4. eart

91.

What will be the output of the following VBA code? Sub test ( )a = “ Computer operator” Debug.Print left(a,10) End sub

1. Operator
2. Computer 0
3. Computer
4. Computer operator

92.

What will be the output of the following VBA code? Sub test ( )Dim l as integer Dim S as stringS = “Time is money” l = len(s) Debug.print “The length is “ & l End sub

1. 13
2. The length is 11
3. The length is 13
4. THE LENGTH IS 13

93.

What will be the output of the following VBA function?Sub stg ( )Str = “Mathematics” Debug.Print right (str,6) End sub

1. Matics
2. Mathem
3. Mathemat
4. Mathematics

1 2 3 4 5 6 7 8 9 10