1. Personal computer is otherwise called .
(a) micro-computer
(b) desktop
(c) both a & b
(d) neither a nor b
Ans. c
2. In a personal computer, multiple users .
(a) can login and work at different times
(b) cannot login and work at the same time
(c) although multiple users are supported, only one person can login at given time
(d) all of them
Ans. d
3. A computer which supports concurrent login for 100 or 200 persons is called .
(a) mini-computer
(b) micro-computer
(c) tablet PC
(d) laptop
Ans. a
4. A computer which supports concurrent login for thousands of users is called .
(a) mainframe computer
(b) micro-computer
(c) tablet PC
(d) laptop
Ans. a
5. computer has enormous processing power, memory and storage and supports thousands of concurrent logins.
(a) mainframe computer
(b) micro-computer
(c) cloud computer
(d) laptop
Ans. a
6. A collection of computers used for online data storage through the Internet is called .
(a) mainframe computer
(b) micro-computer
(c) cloud computer
(d) laptop
Ans. c
7. A computer having large processing power, used for scientific research, simulation of experiments, nuclear research, high power number crunching, etc. is called .
(a) smartphone
(b) micro-computer
(c) workstation computer
(d) supercomputer
Ans. d
8. The most common type of computer used at homes and offices is called .
(a) Personal Computer (PC)
(b) super computer
(c) main frame computer
(d) mini computer
Ans. a
9. In computers, PC is expanded as .
(a) Process Computer
(b) Progressive Computer
(c) Personal Computer
(d) Plus Computer
Ans. c
10. Personal computer is otherwise called .
(a) super computer
(b) main frame computer
(c) mini computer
(d) micro-computer
Ans. d
11. A micro-computer/PC permits working of at the same time.
(a) many users
(b) one user
(c) hundreds of users
(d) thousands of users
Ans. b
12. Laptops, tabs, mobile phones, raspberry PI, etc. are classified under .
(a) super computer
(b) main frame computer
(c) mini computer
(d) micro-computer
Ans. d
13. The main advantage of computer is .
(a) speed
(b) large storage capacity
(c) ease of creating programs for new jobs
(d) all of them
Ans. d
14. CAD stands for .
(a) Computer Analog Design (b) Computer Aided Dialog
(c) Computer Aided Design (d) Computer Android Design
Ans. c
15. CAM stands for .
(a) Computer Analog Manufacture
(b) Computer Aided Monitoring
(c) Computer Aided Maintenance
(d) Computer Aided Manufacturing
Ans. d
16. CAD/CAM help in reduction of required for manufacture while maintaining high quality and precision.
(a) time
(b) money
(c) both a & b
(d) neither a nor b
Ans. c
17. Mission critical operations (like rocket launching, control of space vehicles) are possible through computers.
(a) real time (b) main frame
(c) super (d) mini
Ans. a
18. Real time computers have lag in processing input signals.
(a) zero (b) lengthy
(c) lot of (d) heavy
Ans. a
19. Banks store and retrieve core banking transactions using .
(a) mobile phones
(b) centralized server computers
(c) tablet computers
(d) micro-computers
Ans. b
20. Computers help in creation of high quality multi-media content at .
(a) high speed
(b) high quality
(c) lower cost compared to manual creation
(d) all of them
Ans. d
21. Computer networks in the form of LAN, WAN, MAN and the Internet help in .
(a) sharing of information
(b) transactions of e-commerce
(c) sharing of hardware (like printers)
(d) all of them
Ans. d
22. Which is the sequence, in which computer operates?
A Input, output, process B Input, process, output C Process, input, output D Output, process, input
Ans. b
23. Which is the first general purpose programmable electronic computer?
A ENIAC B EDVAC C EDSAC D UNIVAC
Ans. a
24. What type of device is computer?
A Electrical device B Electronic device C Electro magnetic
D Electro mechanical
Ans. b
25. Who invented Analytical engine?
A Charles Babbage
B John Lickert C John Mauchy D M.V Wilkes
Ans. a
26. How does the parallel port transfer a byte?
A Bit by bit
B 2 bits at a time C 4 bits at a time D 8 bits at a time
Ans. d
27. What is the purpose of expansion slot in mother board ?
A To insert the RAM
B To insert the mouse
C To insert the keyboard
D To insert the additional peripherals
Ans. d
28. What is the purpose of memory unit in a computer?
A Accepts data B Displays data C Process data D Stores data
Ans. d
29. How many pins are there in DIMM?
A 138
B 148
C 158
D 168
Ans. d
30. How many pins are there in SIMMs?
A 32 - 72
B 42 - 82
C 52 - 92
D 62 -102
Ans. a
31. Which one is an example for OS?
A Antivirus B Windows
C MS Office D Macromedia
Ans. b
32. Which acts as an intermediate between a user and a computer?
A Macros
B Antivirus
C MS Office
D Operating system
Ans. d
33. What is the function of OS?
A calculation
B word processing
C drawing pictures
D process & memory management
Ans. d
34. Which tool in control panel is used to adjust your computer setting to control computer with voice command?
A System and security
B Appearance and personalization
C Hardware and sound
D Ease of access Ans. d
Ans. d
35. Which control panel applet gives the information of computer?
A System and security B Hardware and sound C Programs
D Appearance and personalization
Ans. a
36. What is the extension of applet files in control panel?
A . Ctl B . Cpl C . Cal D . Csl
Ans. b
37. Which shortcut key is used to copy and paste a file folder?
A Ctrl+ X and Ctrl + V B Ctrl + A and Ctrl + V C Ctrl + Z and Ctrl + V D Ctrl + C and Ctrl + V
Ans. d
38. Which shortcut key is used to refresh windows desktop?
A F1 B F2
C F5 D F12
Ans. c
39. Where does the pinned application stayed in Windows Os?
A Desktop B Notification Area
C Start Button D Task Bar
Ans. d
40. What is the capacity of typical DVD?
A 40 MB
B 50 MB
C 60 MB
D 4.7 Gb
Ans. d
41. Which process is used to record data on to an optical disc?
A Burning B Reading C Accepting
D Accessing
Ans. a
42. Which software interface the major hardware components of the computer with OS?
A BIOS B CMOS C DOS D POST
Ans. a
43. What is BIOS?
A firmware
B Hardware C Middleware D Software
Ans. a
44. What is the purpose of Nero StartSmart?
A Format HDD
B Burn CD/DVD
C Format pen drive D Format CD/DVD
Ans. b
45. Which system is used by bluetooth for board casting?
A Satellite
B Microwaves
C Telephone lines D Radio waves Ans. d
Ans. d
46. Which one is used as authentication for paring bluetooth devices?
A Keyboard B Keycode C Passcode D Password
Ans. c
47. Which program is used to enable the devices to work with OS ?
A Antivirus B Device driver
C System Software D Application Software
Ans. b
48. Which key is used to open CMOS setup utility?
A Alt
B Del C Enter D Tab
Ans. b
49. What is the process of deleting all the data on the hard drive?
A Delete
B Erase
C Formatting D Uninstall
Ans. c
50. What is the purpose of BIOS shadow?
A Copying RAM to ROM B Coping ROM to RAM C Copying HD to RAM D Copying RAM to HD
Ans. b
51. What should be done, after fixing a problem or installing a new application or making configuration in a computer?
A Hibernate
B Restart
C Shutdown D Sleep
Ans. b
52. What is the name of hierarchical file system in DOS?
A Tree structure B Root structure C Hybrid structure
D Directory structure
Ans. b
53. Which DOS command is used to delete a directory?
A RD
B REMOVE
C DEL
D DELETE
Ans. a
54. Which character is used to represent parent directory in Linux?
A . B ..
C ~ D *
Ans. b
55. Which character is used to redirect output in to an existing file in Linux?
A > B >>
C < D <<
Ans. b
56. Which command is used to specify the location of files or folders in MSDOS?
A dir
B path
C sub directories
D tree
Ans. b
57. How the directories under the root directory are called?
A dir
B path
C sub directories
D tree Ans. c
59. Which filename will matches the command. DIR????T.TxT in DOS?
A TIME . TXT B TEXT . TXT C TEMP . TXT D TEMPT . TxT
Ans. d
60. What is the used of CD command in DOS?
A create a directory
B change the device name
C create root directory
D change the path of current directory Ans. d
61. What is the maximum number of character allowed as file name in DOS?
A 3 characters
B 6 characters
C 7 characters
D 8 characters
Ans. d
62. Which DOS command is used to create a text file?
A List
B Type
C Copycon
D Dir
Ans. c
63. Which one of the following is the directory separator in Linux?
A /
B \ C // D \\
Ans. a
64. Which character is used to represent a range of values in Linux?
A ( ) B [ ]
C { } D < >
Ans. b
65. Which character redirects the output of one command to another in Linux?
A . dot
B | pipe
C : colon
D ; semicolon
Ans . b
66. Which Linux command list the content of all sub directory?
A ls ~ B ls * / C ls / D ls ../ Ans. b
67. Which Linux command list the contents of parent directory?
A ls ~ B ls */ C ls / D ls .. / Ans. d
68. What is use of „who‟ command in Linux?
A login user
B logout user
C login password D logout password Ans. a
69. Which command is used to hide the file?
A attrib -h filename B attrib +h filename C attrib /h filename D attrib \h filename Ans. b
70. Which command is used to release the read only permission?
A attrib -r filename B attrib +r filename C attrib /r filename D attrib \r filename Ans. a
71. Write the Linux command to remove all the permission to the user and group on the directory
„software‟?
A chmod ug - rwx software B chmod ug - a software
C chmod ug - A software D chmod ug - Rwx software
Ans. a
72. Which DOS command is used to display system time?
A Now B TIME
C SYSTEM D SYSTEMTIME
Ans. a
73. What in the result of the DOS command PROMPT $D$G?
A Prompt >
B D : >
C Current date > D Current time > Ans. c
74. Which DOS command is used to list all com files in D drive?
A DIR D :\ com B DIR D :\ com. * C DIR D :\ * .com
D DIR D :\ * com *
Ans. c
75. Which Linux command is used to sort the text file „network‟ in descending order?
A Sort / r network B Sort - r networkC Sort + r network D Sort \ r network Ans. b
76. Which Linux command to set the permission „x‟ to user, „rw‟ to others and „rwx‟ to group for the file launcher?
A chmod 176 launcher B chmod 671 launcher C chmod 167 launcher D chmod 166 launcher Ans. c
77. Which command is used to store the active document permanently?
A Save
B Send
C Prepare D Save as Ans. a
78. Which shortcut key is used to high light the entire word document?
A ctrl + A B ctrl + O C ctrl + S D ctrl + E Ans. a
79. Which tool in MS Word is used to keep the familiar and repeated options?
A title bar B task bar
C scroll bar D quick aceess tool bar
Ans. d
80. Which area in MS Word is used to enter the text?
A work space B work sheet C slides D work book Ans. a
81. Which bar contains the current position of the cursor in MS Word?
A layout
B title bar
C status bar
D horizontal ruler
Ans. c
82. Where does the close button appear in MS Word?
A top left corner of the window
B bottom left corner of the window
C top right corner of the window
D bottom right corner of the window
Ans. c
83. Which one of the following is a word processor?
A MS Word B MS Excel C MS Access
D MS Office publisher
Ans. a
84. Which one of the following is text styling feature of MS Word?
A word fill
B word art
C word colour D word font Ans. b
85. Which option is used to view an exiting word document?
A new
B open
C publish D prepare Ans. b
86. Which document view given an appearance as in web browser?
A Draft view
B Outline view
C Web layout view
D Full screen reading
Ans. c
87. Which group includes superscript, subscript, strike through options in MS Word?
A Clipboard
B Font
C Paragraph
D Style Ans. b
88. What is the purpose of quick access toolbar?
A To hold advance function B To hold special function
C To hold basic function D To hold familiar and repeated function
Ans. d
89. What in the purpose of ⌧ button?
A Close button
B Office button
C Maximize buttons D Minimize button Ans. a
90. What is the purpose of zoom option? A Enlarge and reduce document / text size B Move up and down document / picture C Scroll left and light document / picture
D Minimize and maximize the document / picture
Ans. a
91. Which option is used for tab setting?
A horizontal ruler
B status bar
C vertical ruler
D vertical scroll bar
Ans. a
92. What in the purpose of vertical scroll bar?
A Move the document up and down
B Move the document left side
C Move the document right side
D Move the document only upwards
Ans. a
93. What in the purpose of undo action in MS Word?
A Restore previous action B Get the current action C Goes to previous page
D Goes to previous paragraph
Ans. a
94. Which option is used to activate and deactivate ruler?
A View → grids
B View → ruler
C Insert → tool bar D Insert → ruler Ans. b
95. What is the purpose of cover page?
A Allows to fill title, author, date and other information
B Fills the list of people intent to mail
C To view the mailed list
D Contains details of the documents
Ans. a
96. Which menu contains, Symbol option in MS Word?
A tools B table
C format D insert
Ans. d
97. Which operation is to be performed before paste?
A Ctrl + V
B Cut / copy C Select all D Select text Ans. b
98. Which option is used to locate any specific character, symbols or formulas in a document?
A Find
B Searching text
C Replace
D Selecting text
Ans. a
99. Which sequence of operation is required to insert bullets for list of data?
A Paragraph group → numbering button → select any number type
B Paragraph group → number button → select none C Paragraph group → bullet button → type of bullets D Paragraph group → bullet button → select none Ans. c
100. Which sequence of operation is required to remove numbering from a list of data?
A Number button → select none from number type B Number button → select number from number list C Bullet button → select none from bullet type
D Bullet button → select bullets from bullets list
Ans. a
101. Which sequence of operation is required to remove tab stop markers from ruler?
A Drag the tab stop makers out of the ruler
B Double click the tab marker and clear all
C Right click the tab stop marker and choose remove D Left click the tab stop marker and choose remove Ans. a
102. Which feature is used to adjust the amount of space between words for alignment in MS Word?
A Spacing B Scaling C Justifying
D Positioning
Ans. c
103. Which shortcut key is used to invoke thesaurus dialog box in MS Word?
A Shift+F7 B Ctrl+F7
C Alt+F7 D Ctrl+Alt+F7 Ans. a
104. Where does the file name of the active document displays?
A title bar B task bar
C menu bar D status bar
Ans. a
105. How can we rectify the errors occurs while typing?
A Auto entry B Auto add C Auto spell
D Auto correct
Ans. d
106. Which sequence of operation is required to force page break in word document?
A by using insert / selection black on the insert tab
B by positioning the cursor at the appropriate place and press enter
C by positioning the cursor at the appropriate place and press F1 key
D by position the cursor at the appropriate place and pressing ctrl + enter
Ans. d
107. What is the purpose of inserting header and footer in document?
A To make the starting and ending page
B To entrance the appearance of the document
C To make larger document more readable
D To allow page headers and footer appear on the document
Ans. d
106. What is the purpose of word wrap?
A Aligning text with the right margin
B Inserting space between paragraphs
C Inserting space automatically between words D Moving text automatically to the next line Ans. a
107. What is purpose of thesaurus tool is MS Word?
A Grammar option
B Spelling suggestion
C Synonyms and antonyms words
D Auto correction Ans. c
108. How Cells are named in MS Excel?
A Alphabetically
B Numerically
C Alphanumerically D Special Character Ans. c
109. What is the maximum limit of rows in MS Excel 2010?
A 1084567
B 1048567
C 1048576
D 1084576
Ans. c
110. What is the maximum limit of column in MS Excel 2010?
A 16384 B 16438
C 16843 D 16348
Ans. a
111. Which bar lies top of the window in Excel Screen?
A Status Bar
B Ruler
C Title Bar D Scroll Bar Ans. c
112. How rows are numbered in MS Excel?
A Alphabetically
B Numerically
C Alphanumerically D Special characters Ans. b
113. How columns are named in MS Excel?
A Alphabetically
B Numerically
C Alphanumerically D Special characters Ans. a
114. Which tab is used to include pivot table, charts, hyperlinks to a spread sheet?
A Insert
B Page Layout
C Data
D Review Ans. a
115. Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet‟s data list?
A Formula
B Data
C Review D Insert Ans. b
116. Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
A Formula
B Data
C Review D View Ans. c
117. What type of software is MS Office?
A Application Software B Operating System C Programming Language D System Software Ans. a
118. Which tool in MS office is best for organizing data and making lists?
A Access B Excel
C Power Point D Word Ans. b
119. What is the file extension of Excel 2010?
A xls B xlsb C xlsm D xlsx Ans. d
120. What do you mean by A3,B13:B20,C7 reference in Excel?
A Range
B Union
C Formula D General Ans. a
121. Which type of key should combine with ctrl key to create a macro key in Excel?
A Numeric
B Alphabetic
C Alphanumeric
D Special characters Ans. b
122. Which bar is used to display the sheet information and insertion point location in MS Excel?
A Ruler
B Scroll Bar C Status Bar D Title Bar Ans. c
123. Which function key is used to open save as dialogue box in MS Excel?
A F2 B F5 C F7 D F12
Ans. d
124. Which tab is used to change the display of worksheet area and the data it contains?
A Page Layout
B Data
C Review D View Ans. d
125. Which view in Excel displays the pages exactly as they appear when printed?
A Custom View
B Full screen View C Page Break View D Page Layout view Ans. d
126. Which one of the following will starts with “=” sign in Excel 2010?
A Data B Text
C Numbers D Formulas
Ans. d
127. Which tab is used for creating, formatting and editing a spreadsheet?
A Data B Home C Insert
D Review
Ans. b
128. Which function is used to count the number of cells that contain numbers, in a range?
A Count () B Countif() C Sum()
D Sumif()
Ans. a
129. Which function is used to add the values in a range?
A Count()
B Sum()
C ABS()
D Sumif()
Ans. b
130. which symbol is used to execute formulas in MS Excel?
A = B „ C # D “
Ans. a
131. Where does the result displays when a formula is entered in Excel?
A Current Cell
B Next Cell
C Previous Cell D Formula Bar Ans. a
132. Which function in Excel is used to find the biggest value in a range?
A Ceiling B DMAX C LEN
D MAX
Ans. d
133. Which one of the following is a text function in MS Excel?
A MID()
B NOW()
C COUNT()
D SIGN
Ans. a
134. Which one of the following is a „Date & Time‟ function in Excel?
A FIND() B MOD()
C NOW() D MID()
Ans. c
135. Which function is used to find the middle number in a range?
A MEDIAN()
B MID()
C TRIM()
D MODE()
Ans. a
136. What is the purpose „Tab‟ key in MS Excel?
A Moves cell pointer to previous column
B Moves cell pointer to next column C Moves cell pointer previous row D Moves cell pointer next row
Ans. b
137. What is the purpose of „Enter Key‟ in MS Excel?
A Moves cell pointer to previous column
B Moves cell pointer to next column C Moves cell pointer to previous row D Moves cell pointer to next row Ans. d
138. Which function key is used to open goto dialogue box in MS Excel?
A F2 B F5 C F7 D F11
Ans. b
139. Which option in MS Excel is used to display the rows that meet certain conditions?
A Find
B Filter C Format D Sort Ans. b
140. Which option in Excel is used to rearrange the rows base on the content of a particular column?
A Find B Filter C Sort
D Format
Ans. c
141. Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?
A Mixed B General
C Relative D Absolute Ans. a
142. Which one of the following is „no argument‟ function?
A Now() B Lower()
C Max() D IF()
Ans. a
143. Which key is used to make multiple line in a single cell?
A Alt+ ↵ B Tab+↵ C Ctrl+ ↵ D Shift+ ↵ Ans. a
144. Which item, contains text graphics, charts, sound, video, etc., in power point
A Slides
B Folder
C Handouts
D Desktop screen
Ans. a
145. Which contains miniature representation of slides?
A Slides
B Handout
C Template
D Slide master
Ans. b
146. Which button is used to add instant animation to the presentation and helps interactive presentation?
A Add button B Start button C Insert button
D Action button
Ans. d
147. What type of software program is power point?
A Word Processor
B Spread Sheet
C Presentation Graphics D Database Management Ans. c
148. Which tool allows user to select different layout for slide?
A Apply design
B Bullets
C New slide
D Slide Layout Ans. a
149. Which key is used to stop a power point presentation?
A ESC B Tab
C Ctrl D Enter
Ans. a
150. How many panes are these in backstage view in power point 2010?
A 3 B 5
C 7 D 9
Ans. a
151. Which menu is used to apply various effects to the text in a slide?
A Animation
B Design
C Transitions D Slide show Ans. a
152. Which menu is used to apply various visual effects to the slide in power point?
A Animation
B Design
C Slide show D Transitions Ans. d
153. Which menu is used to select a predefined chart style?
A Animation
B Design
C Slide show D Transitions Ans. b
154. Which template makes specify common design elements in all slides in the presentation?
A Fax template B User template C Data template
D Master template
Ans. d
155. Which dialog box in Power Point allows to change slides automatically in a period of time?
A Action setting B Slide transition C Slide animation
D Custom animation
Ans. b
156. Which shortcut key is used to invoke thesaurus dialog box in Power Point?
A Shift+F7 B Ctrl+F7 C Alt+F7
D Ctrl+Alt+F7
Ans. a
157. Which option is used to create a presentation automatically in Power Point?
A Template
B Blank Presentation C Auto content wizard D Standard test bar Ans. c
158. Which option offers a built in design through a dialog box?
A Auto content wizard B Blank Presentation
C Standard tool bar D Template Ans. d
159. Which function key is used to run a powerpoint presentation?
A F3 B F5 C F7 D F9
Ans. b
160. Which shortcut key is used to create a new slide in power point?
A Ctrl + C B Ctrl + N C Ctrl + M D Ctrl + S Ans. c
161. Which holder holds text, title and picture in power point?
A Contemt Holder
B Image Holder C Place Holder D Slide Holder Ans. c
162. Which one of the following is extension of power point 2010 presentation file?
A .potx B .pptx C .ppsx D .thmx Ans. b
163. Which option is used to insert the related hints of a slide?
A Note Master
B Presentation Master
C Slide Master D Hints Master Ans. a
164. Which combination of key is used to select all slides from current slide to first slide?
A Alt + Home B Ctrl + Home C Shift + Home D Tab + Home Ans. c
165. Which view hides the hidden slides in Power Point?
A Normal
B Notes Page C Reading view D Slide Sorter Ans. c
166. Which option is used to display the selected slides only for presentation?
A From Beginning B From current slide C Broadcast slide show D Custom slide show Ans. d
167. Which one of the following is a effect option in power point presentation?
A Diamond
B Fade C Push D Reveal Ans. a
168. Which combination of key is used to show the laser pointer during slide show?
A Alt + left mouse button B Alt + right mouse button C Ctrl + left mouse button D Ctrl + right mouse button Ans. c
169. What is the maximum number of characters allowed in text field is access?
A 255
B 256
C 64000
D 65000
Ans. a
170. What is the expansion of OLE in Access?
A object linking and embedding B object linking and encrypting C object linking and editing
D objet linking
Ans. a
171. What is the maximum length of the field name in Access?
A 16 characters
B 32 characters
C 64 characters
D 128 characters
Ans. c
172. Which view is used to arrange table data in different graphical layouts to summarize data?
A Table view
B Design view
C Data sheet view D Pivot chart view Ans. d
173. Which view allows to modify table‟s structure in Access?
A Design view
B Datasheet view C Pivot table view D Pivot chart view Ans. a
174. Which object stores information about related data?
A Document B Table
C Page D Screen Ans. b
175. Which key stoke is used to move the active cell towards right, in access table?
A Ctrl + Tab B Alt + Tab C Tab
D Shift + Tab
Ans. c
176. Which key stoke moves the active cell towards left in Access table?
A F2
B F5
C Tab
D Shift + Tab
Ans. d
177. Which combination of key zooms the content of active cell in Access table?
A Ctrl + F2 B Ctrl + F5 C Shift + F2 D Shift + F5 Ans. c
178. Which combination of key allows user to move to the first field in the first record in Access table?
A Ctrl + Tab
B Shift +Tab
C Shift + Home D Ctrl + Home Ans. d
179. Which command quickly locates the data is Access table?
A Find
B Locate C Search D Edit Ans. a
180. Which validation rule accepts only a - z letters for fields in Access?
A Is null or NOT like “*[! a - z]*” B Is null or NOT like “*[a - z ]*” C Is null or NOT like “*![a - z]*”D Is null or NOT like “[! a - z]” Ans. a
181. Which validation rule allows only 0 - 9 for fields in Access?
A Is Null or Not Like “*[ ! 0 - 9 ]*” B Is Null or Not Like “[! 0 - 9]” C Is Null or Not Like “*[0 - 9]*”D Is Null or Not Like “*[!0-9]*” Ans. d
182. What is allowed the input mark symbol # in Access?
A Letter or digit B Letter A through Z
C A digit 0 - 9 with +/- sign D A digit 0 - 9 without +/- sign
Ans. c
183. Which validation rule allows exactly digits for number fields in Access?
A Is Null or Between 100000 and 99999
B Is Null or Like “????”
C Is Null or >= 0 AND< = 99999
D Is Null or < = 99999 Ans. c
184. What is the output when the data „1678.95‟ is set to the number format „###0.00‟ in Access?
A 1670.00
B 1670.95
C 1678.00
D 1678.95
Ans. d
185. Which of the following is a valid time format is Access?
A hh:mm:ss AM/PM B hh.mm.ss AM/PM C hh-mm-ss AM/PM D hh/mm/ss AM/PM Ans. a
186. Write the output when the data „Primary Key‟ is set to the text < in Access?
A Primary key
B primary key
C PRIMARY KEY
D Primary Key
Ans. b
187. What is the output when the data “FOREIGN key‟ is set to the text format > in Access?
A foreign key
B FOREIGN KEY
C Foreign Key D Foreign key Ans. b
188. What is the reason for not accepting zero in the fields of Access tables?
A Fields is set with is Null or > 0 B Fields is set with is Null or < = 0 C Fields is set with is Null or! [0]
D Fields is set with is Null or like “?” Ans. a
189. Which layer in OSI model performs network routing, flow control and error control function?
A Network layer B Session layer C Physical layer D Data link layer Ans. a
190. What is the full form of IP?
A internet protect B intranet protocol
C internet protocol D international protocol
Ans. c
191. What is the full form of TCP?
A Test Control Protocol
B Transfer Control Protocol
C Transport Control Protocol
D Transmission Control Protocol
Ans. d
192. Which layer is the layer 2 in OSI network model?
A Session layer B Physical layer C Data link layer D Transport layer Ans. c
193. Which layer is the layer 4 in OSI model?
A Session layer B Network layer C Data link layer D Transport layer Ans. d
194. Which is the 6th layer in OSI communication model?
A Session layer
B Network layer
C Application layer D Presentation layer Ans. d
195. What is the abbreviation of OSI?
A Open Source Internet
B Open System Interaction
C Open Source Interconnection D Open System Interconnection Ans. d
196. What is the full form of EFT?
A Electronic Form Transfer B Electronic Fund Transfer C Electronic Field Transfer
D Electronic Format Transfer
Ans. b
197. Which is an example for WAN?
A Ethernet
B Home network
C Campus network D Bluetooth network Ans. a
198. What is the full form of ADSL?
A Asymmetrical Digital System Line B Automatic Digital Subscriber Line
C Asymmetrical Digital Subscriber Line D Asynchronous Digital Subscriber Line
Ans. c
199. Which is the layer 3 in OSI model?
A Network layer B Session layer C Physical layer D Data link layer Ans. a
200. Which is a reference tool for understanding data communication between any two network system?
A LAN
B WAN
C ISO model D OSI model Ans. d
201. What is called the interconnected computer systems located at different places?
A internet
B computer layout
C computer network
D connectivity of computer
Ans. c
202. How many pairs of wires contains in category 5 UTP cable?
A 3
B 4
C 5
D 6
Ans. b
203. What is the maximum speed supported by category 5 UTP cable?
A 1mbps
B 10mbps
C 100mbps D 1000mbps Ans. c
204. Which device is installed in a subscriber‟s telephone line to allow both ADSl and regular voice (telephone) services to be used at the same time?
A Hub B Switch
C MODEM D Micro filter
Ans. d
205. Which layer of OSI Model, transfer data between network entities?
A Layer 1 B Layer 2
C Layer 3 D Layer 4
Ans. d
206. Which device connects multiple network segments along with the data link layer?
A Hub B Bridge
C Router D Switch
Ans. b
207. Which device is used to amplify or regenerate digital signals received while sending them from one port of a network into another?
A Hub
B Bridge
C Switch
D Repeater
Ans. d
208. Which device is used to connect one network with another network that uses different protocols?
A Hub
B Router
C Switch
D Gateway
Ans. d
209. Which device forwards data packet between computer network?
A Hub
B Router
C Switch
D Gateway
Ans. b
210. What is the speed of standard 10 base T cable?
A 1 mbps
B 10 mbps
C 100 kbps
D 100 mbps Ans. b
211. Which type of cable is used in 10 base-FL cable standard?
A UTP
B STP
C Co-axial
D Fibre optic
Ans. d
212. What is the speed of 100BASE-TX cable?
A 1 mbps
B 10 mbps
C 100 kbps
D 100 mbps
Ans. c
213. Which is the standard connector for category-5, unshielded twisted pair cabling?
A RJ11 B RJ14
C RJ25 D RJ45
Ans. d
214. How many pairs of wires are there in category 1 UTP cables?
A 1 B 2
C 3 D 4
Ans. a
215. Which is an application layer of internet standard protocol used by local e-mail clients to retrieve e-mail from a remote server over a TCP/IP connection?
A IP
B FTP C UDP D POP
Ans. d
216. What is the purpose of the last three layers in OSI model?
A common application services
B data presentation within the end-user system
C passing traffic through the network to an end system
D manage the dialogue between end user application process
Ans. c
217. Which layers of OSI model is the router operate?
A Layer 2
B Layer 3
C Layer 6
D Layer 7
Ans. b
218. Which layer of OSI network model does repeater works?
A Layer 1
B Layer 2
C Layer 3
D Layer 4
Ans. a
219. Which is a network protocol used on the internet or LAN to provide a bi-directional interactive text oriented communication facility using a virtual terminal connection?
A FTP B TCP C UDP
D Telnet Ans. d
220. Which html tag is used to display a picture in a web page?
A <src>
B <img>
C <img src> D <image> Ans. c
221. Which html tag inserts a line horizontally in a page?
A <lr> B <l>
C <hr> D <line> Ans. c
222. What is the full form of CSS?
A Computer style sheet B Cascading style sheet C Cascading system style D Customized style sheet Ans. b
223. Which html tag is the smallest heading?
A <h1> B <h2> C <h6>
D <head> Ans. c
224. What is the another name of web address?
A URL
B Html
C Http
D Webpage Ans. a
225. Which character in html is used to indicate end tag?
A \
B /
C !
D <#
Ans. b
226. Which symbols starts with html comments?
A <!
B </
C <#
D <\ Ans. a
227. Which is used to publish the webpage to a web hosting server?
A Http
B Php
C Kompozer D Blogger Ans. c
228. Which attribute is used with <td> tag to merge two cells horizontally?
A Colspan = 2 B Rowspan = 2 C Mergerows D mergecols Ans. a
229. Which tag creates a checkbox for a form in html?
A <check box>
B <input check box>
C <input = check box>
D <input type = “check box”> Ans. d
230. Which html tag is used to add a row in a table?
A <tr> and </tr> B <cr> and </cr> C <th> and </th> D <td> and </td> Ans. a
231. Which html tag is used to divide a row into data cells?
A <tr> and </tr> B <cr> and </cr> C <th> and </th> D <td> and </td> Ans. d
232. Which is the correct syntax for adding alternate text for image, if the image cannot be displayed?
A <img src = “boat.gif” alt = “big boat”/>
B <img src = “boat.gif” alt text = “big boat”/>
C <img src = “boat.gif” alternate = “big boat”/>
D <img src = “boat.gif” alternate text = “big boat”/>
Ans. a
233. Which is the correct H1 tag for right alignment?
A <h1 align = “right”>..... </h1>
B <h1 tag align = “right”>..... </h1>
C <h1 align = “r”>..... </h1>
D <h1 alignment = “right”>.... </h1>
Ans. a
234. What is the use of forms in HTML?
A To display a table
B To display a list
C To send the data to server D To display email contents Ans. c
235. What is the correct syntax for making a hyperlink?
A <http: // nimi.gov.in”</a>
B <url = “http: // nimi.gov.in”>nimi
C <a href = “http:// nimi.gov.in”>nimi</a> D <a ref = “http:// nimi.gov.in”>nimi</a> Ans. c
236. Which is the correct tag for adding iframe in html?
A <iframe http://nimi.gov.in> </iframe>
B <iframe =”http: // nimi.gov.in”></iframe>
C <iframe src = “http: //nimi.gov.in”></iframe> D <iframe href = “http: //nimi.gov.in”> </iframe> Ans. c
237. what is the correct html tag for adding a background color?
A <body color = “Yellow”> B <body bgcolor = “Yellow”> C <body background = “Yellow”> D <body bg = “Yellow”> Ans. b
238. How do you add a link which will allow the visitor to send an email from the page?
A <a href = “mailto : youradderss”> B <a href = “sendmailtoyour address”>
C <a=”mailto”> D <href = “mailto”> Ans. a
239. What will happen, If the background image is smaller than the screen, what will happen?
A It will be stretched
B It will leave a blank space at the bottom of the page
C It will leave a blank space at the top of the page
D It will be repeated Ans. d
240. Which is the correct css syntax?
A body: color = black; B body { color; black} C {body: color : black;}
D {body : color = black;}
Ans. b
241. which is the correct html tag for making a text input field?
A <text type = “Text”>
B <input type = “text”>
C <input type = “textfield”> D <input type = “textbox”> Ans. b
242. Which is the correct html tag for creating password field?
A <text type = “password”>
B <input type = “pwd”>
C <input type = “password”> D <input type = “passcode”> Ans. c
243. What is the correct html code for inserting a background image?
A <Body background = “image jpg”>
B <body = “image.jpg”>
C <background = “image.jpg”>
D <body background = image.jpg>
Ans. a
244. Which option will match, while making bulleted list?
A Square, disc, polygon
B triangle, disc, circle
C triangle, square, circle D disc, circle, square Ans. d
245. What is the meaning of increase the cell padding?
A Increase the thickness of table border
B Increase the space between cells
C Increase the distance between cell and content
D Increase the no of cells
Ans. c
246. Which property of cells will how many rows a cell should span?
A Colspan = 5 B Rowspan = 5 C Cellspan = 5 D Span = 5 Ans. b
247. Which web language give more control over the HTML elements and allows them to change at any time without returning to the Web server?
A BML B XML
C HTML D DHTML
Ans. d
248. What will be the output of the following HTML code?
<html>
<body>
<p><strong>NIMI</strong></p>
<p>CHENNAI</p>
</body>
</html>
A NIMI CHENNAI B NIMI CHENNAI
C CHENNAI NIMI
D CHENNAI NIMI
Ans. b
249. What is the output of the following html?
<html>
<body>
<h2>NIMI<small>CHENNAI</small> formatting</h2>
</body>
</html>
A NIMI chennai B NIMI CHENNAI
C NIMI chennaiformatting D NIMICHENNAI formatting Ans. c
250. What is the output of the following html code?
<html>
<body>
<p>NIMI<sup>CHENNAI</sup></p>
</body>
</html>
A NIMI chennai B NIMI chennai
C NIMI chennai D NIMI - CHENNAI
Ans. a
251. Which of the following code is used to add a plain color background to the web page?
A <body bgcolor = “36, 2437”>
B <body color = “#FF000”>
C <body bgcolor = “#FF000”>
D <bgcolor = “blue”> Ans. c
252. What is the process of writing instruction to be get executed by the computer?
A Debugging B Executing
C Presenting D Programming
Ans. d
253. Which is a statement terminator in javascript?
A ,
B ;
C :
D . .
Ans . b
254. Which programming language‟s syntax influences javascript syntex?
A C
B COBOL
C Java
D JDK
Ans. a
255. Which web server provides good customer support if it had any issues?
A Apache
B IIS
C Lite speed D Nginx Ans. b
256. Which web server has high performance stability simple configuration and low resosurce usage?
A Apache
B IIS
C Lite speed D Nginx Ans. d
257. Which key is used to declare a variable in javascript?
A const B dec C dim D var Ans. d
258 Which is a variable seperator if more than one variable declared in one statement?
A ,
B :
C -
D /
Ans. a
259. Which brackets is used to write array in java script?
A Curve bracket B Square bracket C Curly bracket D Corner bracket Ans. b
260. Which bracket is used to write object in javascript?
A Curve bracket B Square bracket C Curly bracket D Corner bracket Ans. c
261. How many types of operation are there in javascript?
A 3
B 4
C 6
D 8
Ans. d
262. What is the purpose module (%) operator in javascript?
A Percentage value
B Product value
C Remainder value D Quotient value Ans. c
263. How many part are there in „For‟ loop?
A 2
B 3
C 4
D 5
Ans. b
264. Which part in loop evaluates the conditions?
A Condition part
B Increment /Decrement part
C Initialisation part D Looping part Ans. a
265. How many types of error are there in javascript programming?
A 3
B 4
C 6
D 8
Ans. a
266. How many different values can be returned by the error name property in javascript ?
A 3
B 4
C 5
D 6
Ans. d
267. Which object method is used to return the value rounded down to its nearest interger?
A abs() B ceil() C floor()
D round() Ans. c
268. Which special variable holds more than one value at a time?
A Array B Element
C Function D Object
Ans. a
269. Which is the parameter name separator in javascript?
A ,
B :
C -
D /
Ans. a
270. Which function in javassript converts a number to a string?
A Num()
B Str()
C String() D to string() Ans. d
271. Which allows developers to bundle all functionality under a unique application -specific name?
A Class
B Name space
C Object D Property Ans. b
272. Which is a valid js code to sort element of an array tracle?
A Trade.sort:
B Trade.sort(); C Sort.trade(); D Sort.(trade); Ans. b
273. What is the full form of BOM?
A Browser Object Method
B Browser Object Model
C Browser Oriented Method D Browser Oriented Model Ans. b
274. What is the full form of TOC?
A Text of content
B Time of calculation
C Table of content
D Terminator of content
Ans. c
275. Which is the first phase of System Development Life Cycle?
A Testing B Planning
C Developing D Defining
Ans. b
276. What is the abbreviation of W3C in Dom?
A Word Wide Web Curriculum B World Wide Web Consortium C World Wide Web Centre D World Wide Web Content Ans. b
277. What is the main purpose of JavaScript?
A Client side validation B Create web browsers C Read and write files
D Store data in the server
Ans. a
278. Which one is responsible of running javascript code?
A Browser
B Notepad++
C Sublime Text
D Visual studio code
Ans. a
279. Which one enables the hosting providers to manage multiple domains on a single server?
A Network server
B SQL server
C Web server
D Database server
Ans. a
280. Which data type in javascript returns the value „True‟ or „Flase‟?
A Boolean B Dynamic C Object D String Ans. a
281. Which operator is used to check both value and type in javascript?
A # B = C = =
D = = =
Ans. d
282. Which assignment operator is equivalent to a = a * 5?
A a = 5 * 9 B a = * 5 C a * = 5 D a = 5
Ans. c
283. Which single charcter escape sequence represents „line feed‟‟ javascript?
A \ b B \ f
C \ n D \ t Ans. c
284. What is the purpose of Initialisation part in‟for‟ loop?
A exit the loop
B evaluate the condition
C increase or decrease the initial variable
D Initiate the variable
Ans. d
285. Which keyboard in switch case statement specifies the code to run if there is no case match?
A Break B Case C Default D End Ans. c
286. Which statement is used to test a block of code for errors?
A Catch B Finally C Throe D Try Ans. d
287. Which statement is used to handle the error?
A Try
B Catch C Throw D Finally Ans. b
288. Which statement is used create custom error in javascript?
A Catch B Finally C Throw D Try Ans. c
289. Which statement is used to execute code after try and catch?
A Finally
B Syntax error
C Throw
D Type error
Ans. a
290. Which error indicates that the numbers is outside the range of legal values?
A Range Error
B Reference Error
C Type Error D URI Error Ans. a
291. Which error indicates that the variable used is not declared?
A Eval Error
B Range Error
C Reference Error D Syntax Error Ans. c
292. Which error indicates that the value is outside the range of expected type?
A) Eval Error B) Range Error
C) Syntax Error D) Type Error Ans. d
293. Which is used to access individual value in an array? A Content Number
B Element Number C Table Number
D Variable Number Ans. b
294. What is the purpose of length property in array? A Returns number of array element
B Returns number of characters
C Returns number of fields in object array D Returns number of highest array index Ans. a
295. Which method joins all array element into string with specified separator? A Join()
B Pop() C Push()
D To string() Ans. a
296. Which method removes the last elements from an array? A Join()
B Push() C Pop() D Shift() Ans. c
297. Which method is used to add new element to an array? A Join()
B Push() C Pop() D Shift() Ans. b
298. Which method removes the first array element? A Join()
B Pop() C Push() D Shift() Ans. d
299. Which variable works as function argument in java script? A Function variable
B Global variable C Local variable D Object variable Ans. c
300. Which variable declared outside a function in Javascript? A Function variable B Global variable
C Local variable D Object variable Ans. b
301. Which feature in Javascript has properties and methods? A Array
B Function C Object D Controls Ans. c
302. Which variable are deleted in JavaScript when the page is closed? A Function variable
B Global variable C Local variable D Object variable Ans. b
303. Which method is called at the moment of instentiation of an object? A Constructor
B Inheritance
C Polymorphism D Property
Ans. a
304. Which is an instance of class? A Class
B Name space C Object
D property Ans. c
305. Which is window method is used to move the current window? A Move()
B Move to()
C Window move()
D Window.move to() Ans. d
306. Which is property returns the width of the visitor‟s screen in pixels? A Width()
B Screen width() C Screen.width() D Width.screen() Ans. c
307. Which is property returns the URL of the current page? A href()
B < herf >
C Location.herf D herf.location Ans. b
308. Which property is used to transfer files from one host to another host over internet?
A IP B FTP
C HTTP D SMTP
Ans. b
309. Which open source software is used to upload from client to server or download from server to client?
A PHP
B Perl
C HTTP
D FILEZILLA
Ans. d
310. How will javascript treat a number, when it is enclosed with double or single quotes?
A Error
B Number C String D Zero Ans. c
311. What will be the output for the following Javascript code? var x = 13 +”03”
Alert(x);
A 16
B 133
C 1303
D 13 03
Ans. c
312. What will be the output, if the javascript code is executed var x = 1324;
var y = new Number(1324); if( x === y)
alert(“Yes”); else alert(“No”) A Infinity
B Error C No D Yes Ans. d
313. What is the output of the following javascript code? var x = “ ITI “;
var y = “ GOVT “; var o = y concat(x) document.write(o);
A ITI GOVT B ITIGOVT
C GOVTITI D GOVT ITI
Ans. c
314. What is the output of the following javascript code? var name = “ Kanya Kumari” ;
var x = name.substr(8,2); document.write(x);
A um B ma
C ar D Ku Ans. b
315. Which VBA built in function returns location at the second string occurs within the first string?
A Mid()
B Chr()
C ASC()
D Instr() Ans. d
316. Which keyword is used to declare the variables in project scope?
A Static B Private C Public D Protect Ans. c
317. In VBA, How many types of access specifiers available in VBA?
A 2
B 3
C 4
D 6
Ans. a
318. Which type of variable cannot be declared within a procedure in VBA?
A Project scope B Local scope C Global scope D Module scope Ans. d
319. Which variable recognized only within the procedure in which it is declared?
A Local scope B Module scope C Global scope D Project scope Ans. a
320. How many levels of variable scope available in VBA?
A 2
B 3
C 4
D 7
Ans. c
321. What will be the output of the following VBA code? Debug.printformat(#1/1/2017#,”yyyy/mm/dd”)
A 1/1/2017 B Sun, Jan01, 2017
C 2017/01/01 D Sunday, January 01, 2017 Ans. c
322. Which function returns true if the expression is a valid date, otherwise it returns false in VBA?
A CDate() B IsDate() C Day() D Dateadd() Ans. b
323. Which function returns the day of the month (number from 1 to 31) given date value in VBA?
A Day()
B Date()
C Month()
D Date part() Ans. a
324. Which function returns the current system date and time in VBA?
A Date() B Day() C Hour() D Now() Ans. d
325. Which function extracts the first 5 characters from a string in VBA?
A Right(str,5) B Left(str,5) C Mid(str,5)
D Substr(str,5) Ans. b
326. Which color of dot indicate the breakpoint in VBA?
A Grey
B Yellow C Maroon D Red Ans. d
327. Which shortcut key is used to set the properties of form while designing?
A F4
B Ctrl + F4
C Alt + F4
D Shift + F4 Ans. a
328. Which shortcut key is used to open code window in VBA?
A F7
B Alt + F7
C Ctrl + F7 D Shift + F7 Ans. a
329. Which code is used to display a user form in VBA?
A Load user Form1
B User Form1.Show
C User Form1.Show False
D User Form1.Load
Ans. b
330. Which mathematical function returns square root of a specified number in VBA?
A Sqt() B Squr()
C Sqrt() D Sqr()
Ans. d
331. Which VBA function is used to convert the string from uppercase to lowercase?
A Lcase() B Lower() C Ucase() D Upper() Ans. a
332. Which of the following is logical operator in VBA?
A +
B -
C *
D And
Ans. d
333. Which character is to be suffixed for long data type in VBA?
A & B ! C #
D @
Ans. a
334. What is the storage size of decimal data type in VBA?
A 2 bytes
B 4 bytes
C 8 bytes
D 12 bytes
Ans. d
335. What is the storage size of currency data type in VBA?
A 2 bytes
B 4 bytes
C 8 bytes
D 12 bytes
Ans. c
336. How many numeric data types available in Excel VBA?
A 4
B 5
C 7
D 8
Ans. c
337. What is the another name for keywords in VBA?
A Literals
B Variables
C User defined words D Reserved words Ans. d
338. Which entities hold data in VBA?
A Literals B Constants C Keywords D Variables Ans. d
339. Which worksheet method is used to copy a sheet to another location in the workbook?
A Activate
B Copy
C Save AS D Select Ans. b
340. Which VBA worksheet property return or sets a string value that represents the object name?
A Name B Index C Range D Cells Ans. a
341. Which method displays the data form associated with the worksheet in VBA?
A Copy
B Printout
C Show Data Form
D Select Ans. c
342. Which VBA property returns a range object that represents all the cells on the worksheet?
A Cells B Rows C Index D Name Ans. a
343. Which object is member of the workbook?
A Sheets
B Workbook C Worksheet D Range Ans. c
344. Which type of work book method cannot be modified in VBA?
A Close
B Save
C Save AS D Protect Ans. d
345. Which workbook property returns a string value that represents the name of the object in VBA?
A Full name B Name
C Path D Worksheets
Ans. b
346. Which workbook property returns the name of the object including its path on disk in VBA?
A Full name B Name
C Path D Worksheets
Ans. a
347. Which can hold lot of data with one variable in VBA?
A Arrays
B Collections
C Groups D Methods Ans. b
348. Which type of list box enables one choice of adjacent choice in VBA?
A Drop down list
B Single - selection list box
C Multiple - selection list box D Extended - selection list box Ans. c
349. Which button has three states in VBA?
A Option button B Spin button C Push button
D Command button
Ans. a
350. Which box groups related controls into one visual unit in a rectangle with an optional label?
A Label box B Group box C List box
D Combo box
Ans. b
351. Which is used to create user interface forms?
A C
B VBA
C HTML
D Javascript
Ans. b
352. Where does Excel come in object hierarchy of VBA?
A Range object
B Workbook object C Worksheet object D Application object Ans. d
353. Which shortcut key is used to open project explorer window in VBA?
A Ctrl + R B Ctrl + P C Ctrl + W D Ctrl + E Ans. a
354. Which shortcut key is used to open VBA Editor from the Excel worksheet?
A Ctrl + F11 B Alt + F11
C Ctrl + V D Ctrl + F7
Ans. b
355. What is the Full form of IDE?
A Integrated Development Element
B Internal Development Environment
C Integrated Development Environment D Internal Distributed Environment Ans. c
356. Which shortcut key is used to step into line - by - line execution in VBA?
A F2 B F4 C F5 D F8
Ans. d
357. What is called the set of commands bundled together under one name?
A Properties
B Macros
C Procedures D Events Ans. b
358. What is called the set of statement that are executed under one name?
A Macros
B Properties C Procedures D Events Ans. c
359. Which one is attributes of an object in VBA?
A Procedures
B Events
C Macros
D Properties
Ans. d
360. What is called double clicking an object in VBA?
A Events
B Macros
C Procedures D Methods Ans. a
361. Which is used to type / edit the programming code in VBA?
A Form window
B Properties window C Immediate window D Visual basic editor Ans. d
362. What is the alternate name of Bugs?
A Errors B Keywords
C Variables D Constants
Ans. a
363. Which shortcut key is used to open the Visual Basic Editor In VBA?
A Alt + F11
B Ctrl + F11
C Shift + F11
D Shift + Ctrl + F11 Ans. a
364. Which simplifies the work to be eliminating or rewriting the code in VBA?
A Class B Object C Macros
D Functions
Ans. c
365. Which type of variable can be accessed or used by subroutines outside the modules in VBA?
A Static B Private C Protect D Public Ans. d
366. Where there is no difference between dim and private in VBA?
A Local scope B Module scope C Global scope D Project scope Ans. b
367. Which method is used to pass the reference to the arguments?
A Ref
B Val
C Reference D By Ref Ans. d
368. Which function is used to check whether the given input is numeric or Not in VBA?
A Numeric() B Isnumber() C Isnumeric() D Isnum() Ans. c
369. Which function returns specified part of a given date in VBA?
A Day() B Datevalue()
C Datediff() D Datepart()
Ans. d
370. Which function returns the difference between two date values based on the interval specified in VBA?
A Datediff() B Day()
C Daydiff() D Datedif() Ans. a
371. What is the return type of CSng function in VBA?
A Boolean B Variant C Single D String Ans. c
372. Which VBA code is used to load user form into memory but do not display?
A User form1.Show B Load userform1 C Userform1.load D Show userform1 Ans. b
373. Which VBA code is used to remove the user form from memory?
A Unload me
B Userform1.hide
C Unload userform1
D User form show false
Ans. c
374. Which window displays the watched expression including the one just added?
A Module window
B Immediate window
C Watch window D Debug window Ans. c
375. Which one is indicated by a red dot with a line of code highlighted in red in VBA?
A Break point B Start point C End point D Error point Ans. a
376. Which is used to repeats the same steps in case of frequency needed actions in VBA?
A Class
B Object
C Functions D Macros Ans. d
377. Which function returns the integer portion of a number in VBA?
A Int()
B Format()
C Abs() D Sign() Ans. a
378. Which function returns the hyperbolic cosine of the specified angle in VBA?
A Abs() B Cos()
C Cosh() D hcos() Ans. c
379. Which mathematical function generates a random number in VBA?
A Random()
B Rnd()
C Rand() D Round() Ans. b
380. Which operators are concatenation operator in VBA?
A + and - B & and - C & and + D & and * Ans. c
381. Which type of words cannot use for any other purpose in VBA?
A Literals
B Keywords C Constants D Variables Ans. b
382. Which is a series of items where all items share the same properties and methods in VBA?
A Arrays B Groups C Methods
D Collections
Ans. d
383. Which button allows a single choice within a limited set of mutually exclusive choice?
A Button
B Option button
C Spin button
D Toggle button
Ans. b
384. Which box has three states in VBA?
A List box
B Combo box C Check box D Group box Ans. c
385. Which one creates a box with a scrollable list containing a number of input values in VBA?
A Combo box B Option button C Text box
D List box
Ans. d
386. Which control is suitable to collect the input from the user in VBA?
A Label B Text box
C Command button D User form
Ans. b
387. Which is a proper object hierarchy in VBA?
A Worksheet, Workbook, Application, Range B Range, Application, Worksheet, Workbook C Range, Worksheet, Workbook, Application D Application, Workbook, Worksheet, Range Ans. d
388. Which window displays the entire list of local varibles and their current values in VBA?
A Locals window
B Watch window
C Immediate window D Debugging window Ans. a
389. Which window is similar to the locals window, but it is used to tracing the variables in VBA?
A Call stack window
B Watch window
C Immediate window D Debugging window Ans. b
390. Which shortcut key is used to open the immediate window?
A Ctrl + G B Ctrl + L C Alt + G D Alt + L Ans. a
391. What is the another name trigger for an action in VBA?
A Methods B Modules C Events D Macros Ans. c
392. Which shortcut key allows debugger to run the current procedure and go line after line called the procedure in VBA?
A Ctrl + Shift + F6 B Ctrl + Shift + F7 C Ctrl + Shift + F8 D Ctrl + Shift + F9 Ans. c
393. While debugging code, which statement allows to go to the highlighted line?
A Step into B Step over
C Step out D Show next Ans. d
394. Which control is used to increase or decrease a value, such as a number time or date?
A Scroll Bar B Spin Button
C Combo Box D Toggle Button Ans. b
395. 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?
A Strcmp B Strcomp
C Compare D Scmp
Ans. a
396. 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?
A Global scope B Local scope
C Module scope D Project scope
Ans. b
397. What will be the output of the following VBA code? Sub test()
a = 9
Debug.Print Sqr(a) End sub
A 3
B 9
C 18
D 81
Ans. a
398. What will be the output for the following VBA code? Debug.print DateDiff(“yyyy”,”1/12/2016”,”31/1/2017”)
A 0
B 1
C 11
D 30
Ans. b
399. What will be the output of the following VBA code? Sub test()
x = “institue”
Debug.print Format(x,”>”) End sub
A Institute
B institute
C INSTITUTE
D instiTUTE
Ans. c
400. What will be the output of the following VBA code? Sub test()
Dim S AS string
S = “wholehearted” Debug.Print mid(s,6,4) End sub
A arte B hear C hole D eart Ans. b
401. What will be the output of the following VBA code? Sub test()
a = “ Computer operator” Debug.Print left(a,10) End sub
A Operator
B Computer o
C Computer
D Computer operator
Ans. b
402. What will be the output of the following VBA code? Sub test()
Dim l as integer Dim S as string
S = “Time is money” l = len(s)
Debug.print “The length is “ & l End sub
A 13
B The length is 11
C The length is 13
D THE LENGTH IS 13
Ans. c
403. What will be the output of the following VBA function? Sub stg()
Str = “Mathematics” Debug.Print right(str,6) End sub
A matics
B Mathem
C Mathemat
D Mathematics Ans. a
404. What type of software is Tally?
A Accounting Software B Application Software C Language Translator D System Software Ans. a
405. What is the purpose of financial management feature in Tally?
A Importing and exporting data
B For stock transfer
C To get daily balances and Transaction value
D To prepare purchase records
Ans. c
406. Which area in Tally screen provides quick access to different options?
A Button bar B Calculator C Product info D Work area Ans. a
407. Which is prepared to ascertain actual profit or loss of the business?
A Balance sheet
B Book-keeping
C Profit and loss account
D Trading account
Ans. c
408. What is meant by current date in Tally?
A Calendar date
B Last voucher date C Last worked date D System date Ans. c
409. Which are the things and properties for resale that converts into cash?
A Current assets
B Business Transaction
C Liabilities D Purchase Ans. a
410. Who receives benefits without giving money immediately but liable to pay in future?
A Creditor B Debtor C Owner D Worker Ans. b
411. Which function key is used to record fund transfer between cash and bank account?
A F4 B F5 C F6 D F7
Ans. a
412. Which document is issued by the receiver of cash to the giver of cash acknowledging the cash received voucher?
A Ledgers B Journals C Receipts D Vouchers Ans. c
413. What is a summarized record of all the transactions to every person, every property and every type of service?
A Account B Journals
C Ledgers D Vouchers
Ans. a
414. Which is the main book of final entry for accounts?
A Balance sheet B Ledger
C Receipts D Vouchers
Ans. b
415. What is termed as excess of credit side total amount over debit side total amount in profit and loss account?
A Credit B Debit C Loss D Profit Ans. d
416. Which book is used to record transactions relating to return of goods to suppliers?
A Purchase Book
B Purchase Return Book
C Sales Book
D Sales Return Book
Ans. b
417. Which is a statement of assets and liabilities?
A Balance sheet
B Journals
C Ledgers
D Trial balance Ans. a
418. Which accounting system is incomplete and unscientific?
A Double Entry System B Single Entry System C Triple Entry System D Multi Entry System Ans. b
419. What is the rule for real account? A Debtor the receiver, Creditor the giver B Debtor the giver, Creditor the receiver C Debit comes in, Credit goes out
D Debit goes out, Credit comes in
Ans. c
420. Which shortcut key is used to activate calculator in Tally?
A Ctrl + C B Ctrl + M C Ctrl + N D Ctrl + T Ans. c
421. Which activity in Tally is used to find out the financial position of the organisation?
A Balance sheet B Book-keeping C Trading D Profit and loss Ans. a
422. What is referred to as buying and selling of goods?
A Normal account B Real account
C Profit and loss account D Trading account
Ans. d
423. Which factor determines the cost of the product?
A Direct cost
B Elements of cost
C Indirect cost D Standard cost Ans. b
424. What is the shortcut key to export the report in ASCII, SDF, HTML or XML format?
A Alt + C B Alt + D C Alt + E D Alt + X Ans. c
425. Who gives benefits without receiving money, but will claim in future?
A Creditor B Debtor C Owner D Worker Ans. a
426. Which is the ledger grouping for bills receivable in Tally ERP9?
A Fixed asset
B Current asset
C Direct expenses D Indirect expenses Ans. b
427. What is the purpose of financial management feature in Tally?
A Handles different types of vouchers B Allows importing and exporting data C Provides budgeting option
D Provides option for data backup Ans. c
428. What is the purpose of Inventory Management Feature in Tally?
A Provides option for data backup
B Provides all relevant information for any stock item in a single screen
C Provides daily balance and transaction value
D Provides option to upload reports on the website directly
Ans. b
429. What is the purpose of security feature in Tally?
A Provides budget option
B Provides option for data backup C Provides option to upload reports D Provides statement of accounts Ans. b
430. Which term is used for receiving aspects of a transaction?
A Credit B Debit
C Profit D Receipt
Ans. b
431. What is the purpose of Tally audit feature in Tally ERP 9?
A Allows easy analysis of result / reports with graphical values
B Allows statutory reporting for VAT, CST, TCS, TDS, FBT, GST
C Allows splitting of company data into multiple compaines
D Verify, validate and accept accounting information
Ans. d
432. Which combination of key is used to change the financial period in Tally?
A F2
B Alt + F2
C Ctrl + F2 D Shift + F2 Ans. b
433. Which combination of key is used to open “Tally Reference Manual”?
A Alt + H B Alt + M C Alt + R D Alt + T Ans. a
434. Which function of key is used the list / select a company in Tally?
A F1 B F3 C F5 D F7
Ans. a
435. Where does the transactions are entered, before taken to the appropriate ledger account?
A Balance sheet
B Journals C Receipts D Vouchers Ans. b
436. Which term is used for the amount invested for starting a business by a person?
A Asset B Capital C Debit
D Liabilities
Ans. b
437. What is the purpose of Technological feature in Tally?
A Allows importing and exporting data
B Flexible units of measure
C Provides budgeting option
D Provides option for data backup
Ans. a
438. Which term is used for giving aspect of a transaction?
A Credit B Debit C Journal D Voucher Ans. a
439. Which term is used for all the amounts payable by a business concern to outsiders?
A Assets B Capitals C Debits
D Liabilities
Ans. d
440. Which is a statement of all the ledger account balance prepared at the end of particular period to verify the accuracy of the entries?
A Journals
B Receipts
C Trial Balance D Vouchers Ans. c
441. What is the purpose of Ctrl + Q key is the Gateway of Tally screen?
A Close the tally screen
B Quit tally current screen
C Exit with confirmation
D Exit without confirmation
Ans. d
442. What is the purpose of Alt + W key in Tally?
A Change the financial period
B Invoke Tally Reference Manual
C Open default web browser
D Exist Tally without confirmation
Ans. c
443. Which combination of function key is used to open inventory voucher‟s entry menu?
A Alt + F1 B Alt + F3 C Alt + F5 D Alt + F7
Ans. a
444. Which combination of key is used to save the information in Tally?
A Ctrl + A B Ctrl + I C Ctrl + S D Ctrl + X Ans. a
445. Which shortcut key is used to shut a company from the gateway of Tally screen?
A Alt + F1 B Alt + F3
C Alt + F5 D Alt + F7
Ans. a
446. Which register is used to post the journal entries periodically?
A Bill book B Cash book C Ledger D Trial balance Ans. c
447. Which sequence of option is used to view the trial balance on the screen?
A Gateway of Tally →Trial balance
B Gateway of Tally → Display → Trial Balance
C Gateway of Tally → Accounts Info → Trial Balance
D Geteway of Tally → Display → Account Book → Trial balance
Ans. b
448. Which report displays the summary of all the cost centres under a cost category?
A Category summary
B Cost centre Break-up
C Group Break-up D Ledger break-up Ans. a
449. Which function key is used to enter purchase?
A F6 B F7 C F8 D F9
Ans. d
450. Which function key is used to enter receipts?
A F2 B F4 C F6 D F8
Ans. c
451. Which shortcut key is used to open debit Note Voucher?
A Alt + F9
B Alt + F10
C Ctrl + F9 D Ctrl + F10 Ans. c
452. Which shortcut key is used to remove a line in a report in report screen?
A Alt + I B Alt + R C Alt + S D Alt + X Ans. b
453. Which feature offers a parallel classification of stock item?
A Stock categories
B Stock group C Stock item D Stock query Ans. a
454. Which budget is prepared for a very short period?
A Current budget B Long term budget C Rolling budget D Short term budget Ans. a
455. Which ratio evaluate the availability of cash to pay debit?
A Activity ratio
B Debit ratio
C Liquidity ratio D Market ratio Ans. c
456. Which function key is used to enter payment?
A F3 B F5 C F7 D F9
Ans. b
457. Which report displays ledgers and group summary information for the selected cost centre?
A Category summary
B Cost centre Break-up
C Ledger break-up D Group Break-up Ans. b
458. Which name indicates the decreasing value of an Asset?
A Current asset
B Depreciation
C Indirect expenses D Sundry debitor Ans. b
459. Which shortcut key is used to cancel a voucher in Day book / List of vouchers in Tally?
A Alt + D B Alt + I C Alt + S D Alt + X Ans. d
460. What is the full form of EDI?
A Electronic Data Interchange B Electronic Direct Interchange C Electronic Data Information
D Electronic Data Interconnection
Ans. a
461. What is the abbreviation of CGI?
A Computer Gateway Interface
B Common Gateway Interface
C Computer Gateway Interconnection D Common Gateway Interconnection Ans. b
462. Which type of E - Commerce is payment Gateway?
A b2b B b2c
C g2c D g2b
Ans. c
463. Which type of E - Commerce is tenders and submission of application?
A b2b B b2c C g2c D g2b Ans. d
464. Which type of E - Commerce is Amazon?
A b2b B b2c C g2b D g2c Ans. b
465. What is called sale or purchase of items without physically visiting a shop?
A E - Commerce
B POS
C Traditional Commerce
D E - Service
Ans. a
466. Which scope of E- Commerce business platforms like amazon, ebay, etc?
A National
B Local C Global D Virtual Ans. c
467. What is the full form of COD in E -Commerce?
A Cash on Delivery
B Cash on Demand
C Commerce on Delivery
D Cart on Delivery
Ans. a
468. Which one is a online payment?
A Flipkart B Paytm C Gmail
D Reliance jio
Ans. b
469. Which type of attack is a method of defeating a cryptographic scheme of trying a large number of possibilities?
A Teardrop attack B Brute force attack C Phlashing
D Smurf attack
Ans. b
470. Which is the model in E - Commerce, if the seller and buyer are both business firms?
A Consumer to Business B Business to Consumer C Business to Business
D Consumer to Consumer
Ans. c
471. Which is the model in E - Commerce, if the seller is a business and the individual is an consumer?
A Consumer to Business B Business to Consumer C Business to Business
D Consumer to Consumer
Ans. b
472. Which is the model in E - Commerce, if the seller is an individual and the buyer is a business firm?
A Consumer to Business B Business to Consumer C Business to Business
D Consumer to Consumer
Ans. a
473. Which is the model in E - Commerce, if the seller and the buyer are the both individuals?
A Consumer to Business B Business to Consumer C Business to Business
D Consumer to Consumer Ans. d
474. Which is the function of specifying access rights to resources related to information security?
A OTP
B Pin
C Authoriztion D Passcode Ans. c
475. Which refers to paying the money back to the buyer after the price has been deducted from the account?
A Refund
B Return
C Deduction
D Charge bace Ans. a
476. Which card permits online payment using balance amount available in bank account?
A Credit card B Paypal
C Debit card D Wallet Ans. c
477. Which is the set of rules that limits access to information?
A Availability B Integrity C Authenticity D Confidentiality
Ans. d
478. Which is the process of ensuring the data, transactions, communication or documents are genuine?
A Availability
B Integrity
C Authenticity
D Confidentiality
Ans. c
479. What is the purpose of OLX web site?
A Uploading Files
B Buying and selling products
C Searching Documents
D Recovering files
Ans. b
480. Which of the following authenticates and handles credit card payment for E-Commerce?
A Payment gateway
B E - Commerce gateway
C Software gateway
D E-Wallets
Ans. a
481. What is the another name called PDoS?
A Brute force attack
B Non technical attack
C Phlashing
D Smurf attack
Ans. c
482. What is the full form of LDAP?
A Light Weight Directory Access Provider B Light Weight Directory Access Protocol C Light Weight Directory Access Program D Light Weight Directory Access Protection Ans. b
483. What is called the collective terms of malicious software, such as viruses, worms and trojans?
A Spam B Phishing C Malware D Harm
Ans. c
484. What is called the protection of information and data from unauthorized Access?
A Physical security B Link security
C Risk management D Information security
Ans. d
485. What is the full form of CIA under information security?
A Confidentiality Integrity Availability
B Criminal Investigation Agency
C Cost Information Agency D Credit Integrity Assement Ans. a
486. What is called periodic assessment of security vulnerability in computer system?
A Threat B Attack C Hacking
D Security audit
Ans. d
487. What is called a single point of access for several networking services?
A Phishing
B Web service
C Directory service
D Worms
Ans. c
488. Which activities endanger the sovereignty and integrity of nation?
A Cyber Terrorism B Cyber vandalism C Cyber squatting D Carding
Ans. a
489. Which crime involves the use of computer networks to create, distribute or access materials that sexually expoit underage persons?
A Assault by Threat B Cyber squatting C Cyber vandalism
D Child pornography
Ans. d
490. What is called the unauthorized control/acess over the computer system and destroys the data?
A Defamation
B Carding
C Hacking
D Cyber - stalking
Ans. c
491. Which method go through all the files or network elements with an intention to detect something unusual?
A Probing B Phishing C Infecting D Scanning Ans. d
492. Which is a standard network protocol used to transfer files from one host or to another host over a TCP based network, such as the internet?
A FTP B TCP C UDP D SMTP
Ans. a
493. What is the first tag in html document?
A <html> B <head> C <title> D </html> Ans. a
494. The <b> tag makes the enclosed text bold, which other html tag is used to make text bold?
A <dark> B <bold> C <th>
D <strong> Ans. d
495. what is the full form of HTTP?
A Hyper text testing protocol B Hyper text transfer protocol C Hyper test transfer protocol D Hyper text transfer program Ans. b
496. What are the two main parts, available in html document?
A Title and Body B Head and title C Head and Body
D Head and document
Ans. c
497. Who developed javascript?
A Brendan Eich B Brendan Rich C John Eckerl D John Mauchy Ans. a
498. Which sign an „assignment‟ operator in javascript?
A = B # C = = D < >
Ans. a
499. What is the full form of UDF in VBA?
A User Data Functions
B User Defined Functions
C Undefined Functions D Used Data Functions Ans. b
500. Which key word is used to declare the variable in VBA?
A Sub B Declare
C Dim D AS
Ans. c
501. Which data type can hold any type of values in VBA?
A Variant B Variable C Constant D Keyword Ans. a
502. What is the shortcut key to run the current procedure in VBA?
A F2 B F4 C F5 D F8
Ans. c
503. Which one is E - Commerce site?
A Yahoo
B Bing
C Google D Amazon Ans. d
504. Which option in E - Commerce, helps to keep selected products until checkout / payment?
A Basket B Cart
C Tray D COD
Ans. b
505. When the Indian parliament passed the IT Act? A 1990B 1992 C 2000 D 2005 Ans. c
506. What is called protecting data from online attacks, deletions, malwares?
A Physical security B Cyber security
C Cyber attack D Virus
Ans. b
Post a Comment