Question List

Sr. No. Question A B C D

After processing is done on the raw
1 Both A & B Meaningful Useful None of the above
data, data becomes___________.
The key to the computer's
2 I/O Memory CPU All of the above
versatility is_________.
Approximately One million bytes is
3 1 GB 1 KB 1 MB 1 TB
equal to,
People who are trained in the use
of a programming language and Database
4 Programmers Designers Analysts
also write programs are administrators
called__________.

_________ integrates the

computer's hardware components Application
5 System software MS Office None of the above
and provides tools for day-to-day software
maintenance tasks.

Data must be ________ but

6 doesn't need to be relevant, timely Processed Useful Accurate Meaningful
or concise, unlike information.
Supercomputers are not
7 extensively used in the Health Aerospace Automative Chemical
___________industry.
Input/output- Intensive
Supercomputers are rarely used for Weather
8 Seismic Analysis intensive mathematical
__________________. Forecasting
processing calculations
_____________are also frequently
Embedded
9 used as servers for local area Mainframes Workstations Super computers
Computers
networks.

The computing needs of engineers,

architects and other professionals
10 Workstations Mini computers Micro computers Super computers
who need detailed graphics display
is met by _____________.

______________processors are
useful in special-purpose
11 Intel RISC CISC None of the above
applications such as graphics
wherein speed in critical.

Smart cards that we popularly use

Microprocessor & Memory chips &
12 nowadays, incorporate_________ ROM & RAM Hard Disk & RAM
Memory chips RAM
and ____________.
Integrated circuits are also called
13 Both A & B Chips Semiconductors None of the above
___________.
In the fourth generation of
computers, the
________________concept High-Level Object Oriented
14 Networks VLSI
encouraged programmers to reuse Languages Programming
code by maintaining libraries of
code segments.
 Handheld PCs, iPad, Biomatrix
Devices,Generation Future
15 Processing, AI and Ultra book are Fifth First Second Third
features of __________generation
of computers.

Performing comparisons,
16 sorting,combining data etc are the IR CU ALU ACC
fuctions of which part of the CPU?
The control unit uses the
instruction contained in the Instruction
17 RAM Accumulator(ACC) None of the above
___________ to decide which Register(IR)
circuits need to be activated.
The answers from many operations
are stored temporarily in the
18 ACC ALU IR CU
__________before being put out
to RAM.

When we load software from a fl

19 oppy disk, hard disk or CD-ROM, it IR Main Memory Hard disk ALU
is stored in the__________.

Sequentially Simple Area Serial Access

20 SAM stands for, None of the above
accessed Memory Memory Memory
SAM works very well for Writing to an USB
21 Memory buffers Reading a CD All of the above
___________. drive
Data in the __________memory
22 ROM SAM RAM Hard Disk
can be accessed in any order.
___________is the use of a faster
but smaller memory type to
23 Cache Memory Virtual Memory Flash memory RAM
accelerate a slower but larger
memory type.
_________is used for storing
special sets of instructions which
24 SAM ROM Hard Disk RAM
the computer needs when it starts
up.
Compact Flash, BIOS chip, Smart
25 Media etc. are examples RAM Cache Flash ROM
of___________memory.
The area of the hard disk that
26 stores the RAM image is called Page Virtual Swap None of the above
a_______file.
Input devices other than the
27 keyboard are sometimes Backup devices Secondary devices Alternate devices All of the above
called____________.
Microsoft's natural keyboard is an
28 example of an Standard Ergonomic Multimedia Internet
_________keyboard.
 The _________mouse is also useful
for graphics programs that allows
29 to draw pictures by using the T17 Optical Mechanical Wireless
mouse like a pen, pencil or
paintbrush.
__________is the most quick and
30 Wireless Optomechanical Optical Mechanical
precisely pointing mouse.
The static nature of digitizing
31 tablets makes them effective CAD CAM Tracing drawings All of the above
for_____________.

__________scanners do not
32 Sheet Fed Optical Text Flat Bed
distinguish text from illustrations.

To edit text read by an optical

scanner, we need Optical Character Optical Mark
33 Bar Code Reader None of the above
an__________system to translate Recognition Reader
the image into ASCII characters.
__________scanner is much more
34 expensive than the common CCD Sheet Fed Drum Hand held Flat Bed
based scanners.
___________scanners are
excellent for loose sheets of paper,
35 Flat Bed Hand held Sheet Fed Drum
but they are unable to handle
bound documents.

__________readers allow ATMs to

36 read account information and MICR OCR OMR BCR
facilitate monetary transactions.
Which of the following input device
37 senses the presence or absence of OCR MICR BCR OMR
a pencil mark.
________ scanners are more
secure biometric authentication
38 Hand Face Iris Voice
schemes than other types of
scanners.
___________is the identification of
39 a person by the measurement of Punching Biometrics Scanning None of the above
their biological features.
Color monitors are also called as
40 RGB monitors Dynamic monitors Workstations Digital monitors
____________.

VGA and SVGA video standards

require _____________ monitors
41 Color Analog Digital Gray scale
to display variable colors
continuously.

Monitors that are 16 or more

Full-page
42 inches diagonally are often Simple monitors Large monitors None of the above
monitors
called________
Another term for dot pitch
43 Nitrogen pitch Sulphur pitch Phosphor pitch Potassium pitch
is_________.
 For___________devices the
44 bandwidth is expressed in cycles Analog Neutral Digital Gray scale
per second or Hertz (Hz).
The _________ printers can print
45 Laser Dot matrix Ink Jet Thermal
to multi-page forms
___________kind of optical disks
46 Erasable WORM CD ROM All of the above
caanot be modified.
Copy machines work in a way
47 Thermal Ink Jet Laser Dot matrix
similar to the __________ printers.

The wavelength used by standard

48 650 850 600 750
DVD lasers is ______ nm.

___________printers can achieve

higher resolutions with special
49 Laser Daisy wheel Thermal Thermal
techniques known generally as
resolution enhancement.

The term helical scan usually refers

50 10 4 8 6
to _____mm tapes.
Which is not the state of the
51 Suspended Blocked Ready Privileged
process ?
The number of processes
52 completed per unit time is known Efficiency Output Throughput Capacity
as_______ ?
Program in High
A program in Contents of main A job in secondary
53 Process is ____________. level language
execution memory memory
kept on disk
Process Program
Program Control Process Control
54 PCB stands for_____________. Communication Communication
Block Block
Block Block
A computer system that permits
Multiprogrammin
55 multiple users to run programs at Multithreading Multitasking Multiprocessing
g
same time.
A Microsoft Windows is
56 Graphics Software Operating System Word Software All of above
a(n)_______.
Which of the following is program
57 MS Paint Accessories MS Word None of the above
group?
Which of the following is not an
58 Windows XP DOS Excel UNIX
operating system?
A Linux Beowulf cluster is an
59 Multi-tasking Loosely-coupled Tightly-coupled None of the above
example of a _____ system.

___ Processor is responsible for

handling communications to and
60 HOST BACK END FROND END None of the above
from all the remote terminals
connected to computer system.
Single-user computers have two
61 Mainframe Workstation Microcomputer Both A & B
categories ___ & ____.
The speed of Supercomputers
62 Picaflop Gigaflop Megaflop All of above
measured in ______.
_____________ is also called Multiprogrammin
63 Multitasking Multiprocessing Multithreading
parallel processing. g
 Enabling the user to swith between
64 MultiProcessing Multitasking Multithreading None of the above
the task is known as_____.
Which of the following facility is
65 not provided by OS layers to use Safe Convenient Efficient None of the above
hardware?
Efficient and fair sharing of
66 resources among programs is a key TRUE FALSE
goal of Operating System.
Major activities of an Operating
Process Deadlock Process
67 System with respect to process All of above
synchronization Handling Communication
management ________.

A_____is a collection of related

68 Program File Document None of the above
information defi ned by its creator.
________ is measured as the
number of processes that are
69 Response time Turnaround time Throughput All of above
completed by the system per unit
time.
Which of the following is not a
70 Status Object Data None of the above
components of a process?
During the lifespan of a process, its
71 execution status may be in one Three Five Four Two
of_____ states.
In multiprogramming ,most of the
time perform I/O operations and I/O Status
72 CPU bound jobs I/O bound jobs None of the above
CPU utilization is very low ,this kind Information
of jobs is called as ____________.

Threads are oftern referred Lightweight

73 Both A and B Mini processes None of the above
as________________. processes
Operating system is a system
74 TRUE FALSE
software.
Each thread of process Own program Own register
75 Own stack All of the above
has___________. counter states

In case of ___________ operating

76 system, the user views the system Network Distributed Centralized Real-time
as a 'Virtual Uniprocessor'.
In Operating System, threads in Different Different
Different parts of Different users of
77 multithreading refer to processes of a programs of a
a single process single processes
______________. single program single process
Which of the operating system was
78 recorded in C programing language DOS UNIX Linux Windows
?
The two commonly used models
for kernel design in operating
79 Both A and B Monolithic kernel Microkernel None of the above
systems are__________
and__________.
 Under ______ option proper mix of
I/O-bound and CPU-bound jobs are
Memory
80 required to effectively overlap the Proper job mix CPU scheduling All of the above
protection
operations of the CPU and I/O
devices.
The attribute of a fi le contains
81 other information about the file File Size Date & Time Last Updated All of the above
such as_______.
______ operation is used with
random access files to first position
82 Seek Read Write Open
the read/write pointer to a specific
place in the file.
______ is used to change the name
83 Write Read Rename Open
of an existing file.
_____ is a prominent example of a
84 DOS MULTICS UNIX MAC
layered operating system.
________is a bridge between
applications and the actual data
85 CPU Operating System Kernel ALU
processing done at the hardware
level.
The design of Linux is an example
86 Both A and B Monolithic Micro None of the above
of ______architecture .

In context with multiprocessing Symetric Server Shared

87 None of the above
,SMP stands for ___________. Multiprocessing Multiprocessing Multiprocessing
Which state of process records the
88 status of I/O devices Running Blocked Suspended None of the above
____________.
Whch of the following measure is
89 used in case of interactive system Response time Throughput Turnaround time None of the above
_____________.
When the process is waititng for an
90 I/O devicethat state is known as Terminating state Sustended Blocked None of the above
_________________.
Requirements of
Job status Memory
91 multiprogramming are Large memory All of the above
preservation protection
_____________.

The part of the CPU which decides

which of the ready jobs must be Instruction Arithmetic Logic
92 Control Unit CPU Scheduler
allocated to the CPU when it is free Register Unit
is known as ________.
Sharing of computing resourses
among many users by the
93 Computer Sharing Resource sharing Time Sharing Processs Sharing
operating system is know
as____________.
Creation and
Which of the following is not an Suspension and
Improve CPU deletion of user A mechanism for
94 activity of Operating system with resumption of
utilization and system deadlock handling
respect to process management? processes
processes
 The memory management module
of an operating system takes care
Suspension Synchronization Allocation de-
95 of the_________________ of None of the above
resumption Asynchronization allocation
memory space to the various
programs in need of this resource.

The _________ module of

operating system ensure that data Memory Security Process Device
96
should be protected from management managemnt management management
unauthorized users.
The Operating system maintains
a_________________ for each Program Control Process Control Process Circuit
97 None of the above
loaded process before taking away Block Block Board
the CPU from a running process.

In UNIX terminology commannd

98 interpreter is referred as Program Kernel Shell None of the above
_________________.

A process control block(PCB) I/O Status Memory

99 Process State Process Identifier
doesn't contain______________. Information Information

In _______the jobs were then

automatically loaded from the
100 input device and executed by the Batch Working Batch Processing Manual Loading All of the above
system one by one without any
operator intervention.

The Navigation Pane

101 provides____number of views of 3 1 2 4
our document
In Navigation Pane, _____ view
102 provides hierachy of headings in search results Headings Thumbnail None
our document
Screenshot feature will not be
available in word2010 if we are
103 Page layout compatibility normal None
working on a document in ____
mode
By default ______ will appear on
104 Redo Save Undo All
the quick access toolbar

The shortcut for opening the

105 ctrl+C ctrl+F ctrl+A None
search area of the navigation pane

_______ feature of word2010

which allows us to recover unsaved check Accesibility
106 Manage versions None
documents which were closed due compatibility checker
to some reasons

Word2010 uses ___file extension

107 .dotx .doc .docx None
to save documents
 To delete the entire word to left of
the cursor position the cursor to
108 cut Ctrl+delete Ctrl+backspace none
the left of the text we want to
delete and for that we press _____

we cannot delete the page break

109 True False
that word inserts automatically

___________ determines the

110 distance of the paragraph from Spacing Indentation Paragraph Line
either the left or the right margin.
Negative indent is also known as
111 Negtive Spacing Indentation Outdent None
_________.
In Indentation, __________
controls the left boundary of every
112 Left Hanging First Line Right
line in a paragraph except the first
one.
Ctrl + Shift+S is used for
113 Styles box Save As Solver Only Save
___________

114 Insert tab includes __________. Text Pages Illustrations All of above
According to Table in Ms
word,_________combine two or
115 Select Cell Combine Cell Merging Cells Delete Cell
more cells in the same row or
column into a single cell.

116 Tables of citations is known as Table of figure Bibliography Table of content Table of Authority
_____ and _______ are used for
CITATION AND footnote and HEADER AND THESAURAS AND
117 provide references for text of
CAPTIONS endnotes FOOTER RESEARCH
document
Cross reference depends on
118 FOOTER CITATIONS captions FOOTNOTE
______
119 Shortcut key for Web layout is ALT+W+L ALT+W+P ALT+W+U ALT+W+O
______is a helpful tool for setting NAVIGATION
120 ruler GRIDLINES HEADINGS
margins and tabs PANE
_________defines the colors,fonts
121 and graphics effects for a WORD ART Theme STYLE WATERMARK
document
if a word too long to fit at the end
122 of a line then to adjust word we WREP TEXT hyphentation ALIGN LINE BREAK
can use
___________ is often used to hide
or trim a part of a picture either for
123 Deleting Cropping Removing Moving
emphasis or to remove unwanted
portions.
____________ is the ratio between
picture width and picture height General Size
124 Aspect Ratio Quick Ratio Equity Ratio
which can be maintained even Ratio
when resizing a picture.
Show non- Shows steps in a
In SmartArt, What is the Purpose of Show a continual Show how parts
125 sequential process or
Cycle? process relate to a whole
information timeline
126 Which of them is a part of Charts? doughnut charts Column charts Surface charts All of above

___________ identifies a location

127 or a selection of text that we name Cross-reference Hyperlink Bookmark None
and identify for future reference.

_______________ are areas in the

128 top, bottom and side margins of Both A and B Header Footer Nither A Nor B
each page in a document.

__________ are those giant letters

129 that begin the first paragraph of a Upper Case Drop Cap All Cap Font Size
chapter or document.

In Word,User create a table of

130 Table Designing Index Heading styles Table Creation
contents by applying __________.
Shortcut key of footnote and end
131 Both A and B CTRL+ALT+ F CTRL+ALT+ D Nither A Nor B
note are __________

__________________ is a list of
sources, usually placed at the end Acknowledgemen
132 Last Slide Source Bibliography None
of a document that we consulted t
or cited in creating the document.

In word, Insert caption is a

133 Equation 1 Table 1 Figure 1 All of above
numbered label, such as_________

In Figures,____________is defined
as a list of the captions that appear
134 Table of Tables Table of Content Table of Figures Table of Equations
in the document and the
associated page numbers.

File>Save &
File>Info>Versions File>Options>Vers
Send>Versions>M
>Manage ions>Manage
In Word2010,What is the path of anage
135 Versions>Recover Versions>Recover None
Recover Unsave Files? Versions>Recover
Unsaved Unsaved
Unsaved
Documents Documents
Documents
In Word2010,Which of them is not
136 included in a show tab under View Gridlines Ruler Formula Bar Navigation Pane
tab?
Switch Windows button contains
137 up to nine open documents in True FALSE
Word2010.
In word2010,_________ is a series
of commands that we can use to
138 automate a repeated task and can Formulas Macro Tabs Data
be run when we have to perform
the task.
_______format preserves
139 document formatting and enables PDF XML XLS DOC
file sharing
 ______ is an Excel feature that we
can use to define restrictions on
140 Data validation Consolidation What if Analysis None
what data can or should be
entered in a cell.
To Validate a List, List option is
141 choose from _______drop down Data Source Allow Criteria
box.
In Excel and according to Data
142 validation Error alert Style includes Information Stop Warning All of These
____________.
_____ option is the only Style
choice that completely prevents
143 Information Stop Warning None
the person using the workbook
from entering invalid data.

In Excel and according to Data

validation clicking OK enters the
144 new data in the cell; Cancel leaves Information Stop Warning None
the cell unchanged that option is
available through _________.

Restrict data to Restrict numbers

Data validation is used for Limit the number
145 predefined items outside a All of These
____________. of text characters
in a list specified range

Data validation options are located Connections

146 Data Tools group Outline group Validation group
on the Data tab, in the ________. group
Restrict data entry
Data validation can be applied to Use a formula to Restrict data entry
to a whole
147 cell to achieve the objectives that calculate what is to values in a drop- All of These
number within
includes ___________. allowed. down list.
limits.
Home>Editing>Fin Home>Editing>Fin Home>Editing>Fin
How to find cells that have data d& d & Select>Go d & Select>Go to
148 None
validation? Select>Find>Data to>Data Special>Data
Validation Validation Validation

______ tools help make sure any

149 invalid data doesn't end up in the Data validation Data Consolidation Data Analusis
worksheets.
To defend against dangers, we
need to use Excels worksheet
150 Both A and B Locked Hidden Nither A Nor B
protection that includes
_________.
Protecting a worksheet involves Protecting
151 Both A and B Protecting cells Nither A Nor B
_________. worksheet

To protect the workbook user Review>Tools>Pro Review>Changes> Review>Sheet>Pr Review>Protect>P

152
select ___________. tect Workbook Protect Workbook otect Workbook rotect Workbook
Excel 2010 offers up to _______
153 255 28 64 None
sort levels.
154 Sort Includes ____________. Order Column Sort on All of These
 __________tool create groups and
155 subtotals all in one click a feature Solver Consolidation Subtotal Scenario manager
that can save us lots of time.
Is Count Function Work other than
156 Not say any thing Yes No None
Number like Text Etc.?
_____ is used to creat a
157 summarised results into one Solver Consolidation Subtotal Scenario manager
worksheet.
Consolidation is used for Inventory
158 Business forecasts Budgets All of These
__________. requirements
Refer to multiple Refer to Single
3-D Formulas in Consolidate means worksheets and worksheets and
159 Only a 3-D effect None
___________. can be used to can be used to
combine data combine data

What-if analysis includes

160 Consolidation Solver Scenario manager All of These
___________.
___________take sets of input
161 values and determine possible Paste Scenarios Data Tables Both A and B
results.
Goal Seek requires
162 By changing cell Set cell To value All of These
__________information.
According to Financial Functions,
163 Future Value Forign Value Fix Value Financial Value
FV means_______.

According to Financial Functions, Beginning of the

164 Exact value End of the period None
Type 0 means _______. period

__________solves the problem by

adjusting a number of input cells
165 according to a set of criteria or Consolidation Solver Scenario manager Data Table
constraints which are defined by
the user.
Solver in Excel 2010, was Frontline Systems
166 Sun Microsoft None
developed by ______________ Inc.
The Format as Table style helps in
167 creating tables with Patterns Banded rows Border colors All of These
______________.
How many built in formats are
168 96885 255 16384 1048576
available in a Excel?
In Excel, According to Home Tab A^ Increases the font Decreases the
169 Both A and B Nither A Nor B
means __________. size font size

________ command freezes

portions of a worksheet, typically
column and row headings, so that
170 Split Data Freeze Data Freeze Panes None
we can view distant parts of the
worksheet while the headings
remain in place.

_________ are graphical

171 Figures Charts Diagram Tables
representations of worksheet data.
 A macro is a program that
172 uses_______ code to automate a Excel Spread Sheet VBA Recording
sequence of actions or instructions.
Excel creates a hidden personal
173 macro workbook with name Personal.xlsm Anyname.xlsm Anyname.xlsb Personal.xlsb
____________.
In Excel, Formula always begins
174 = < > <>
with an ________ sign.
_______ error is shown in a excel if
the formula tries to divide by zero
or the divisor is a reference to a
175 #N/A #NULL! #DIV/0! REF!
blank cell,
which Excel considers to be zero
value.
_______ is always highlighted in
176 Workstation Current sheet Excel Spreadsheet WorlPlace
the sheet tab.
_______function returns the k-th
177 Large Max Maximum MaxA
largest value in a data set.
PowerPoint 2010 presentations
178 .pptx .ppt .ppnt None
have the extension __________

.PPTX is an extention of power

point, where X at the end denotes
179 XML HTML XBRL None
that the new file format is based
on an open ____

In Power point, how the

information is arranged on the
180 Slide Masters Themes Slide layouts All
slide is controlled by ___________
.
________ are combinations of
design elements such as color
181 Slide Masters Themes Slide layouts All
schemes and fonts that make it
easy to create attractive slides.
__________ use to change the
182 appearance of all the slides in our Slide Masters Themes Slide layouts All
presentation at once.
PowerPoint includes a slick
183 diagramming feature called Media clips SmartArt Shapes None
__________
The dialog box launcher button
184 available is in the group at Top-right bottom-right bottom-left Top-left
__________ corner.
________ is a customize toolbar
Quick Access
185 that contains commands Home Tab Control Tab None
Toolbar
frequently in use.
The _________ shows thumbnail
186 Both A & B Slides tab Outline tab None
icons of slides.
_______ keyboard shortcut use to
187 SHIFT+F10 CTRL+S SHIFT +F12 Both A & B
save the document in PowerPoint.
 The arrangement of placeholders
188 Slide Masters Layout Themes None
on a slide is called a __________.

To create a perfect square or circle

189 or Line (In Power Point), press and ALT SHIFT CTRL All
hold _______ while user drag it.

To view presentation in Slide Show

190 view from the first slide, shortcut F6 F4 F5 F7
key use from keyboard is _______
To view presentation in Slide Show
view from the current slide,
191 alt + f5 shift+f5 ctrl + f5 None
shortcut key use from keyboard is
_______
In Power point, slide master option
192 Transition Animation Slide Show View
exist in _________ tab.
PowerPoint template is a pattern
or blueprint of a slide or group of
193 .potx .ppt .pptx .pptt
slides that has an extention
________.
_________ is use to apply
formatting from text, shapes, and
194 Paste Special Format Painter Clipboard None
pictures to another text selection,
shape, or picture.
In Powerpoint 2010, chart utility
195 Animations Design Transitions Insert
exist in _______ tab.

When we insert a chart in

Powerpoint 2010, Only the data
196 Yellow Blue Red None
enclosed by the _________ lines
will appear in the chart.
___________ is a technology that
197 allows linking to documents and Illustrations Hypertext Object Linking None
other objects.
Paste link exist in ________ dialog
198 Paste Special Clipboard Save None
box.
Transpose option exist in
199 Paste Special Clipboard Save None
__________ dialog box.

In PowerPoint, you can use

_________ button to launch any
200 Pull Push Action None
other Presentation, Application or
Website from your presentation.
A ________ is the top slide in a
201 Handout Master Slide Master Notes Master None
hierarchy of slides.
__________ controls the
202 appearance of all speaker notes Handout Master Slide Master Notes Master None
pages.
The PowerPoint presentation
203 Three One Two Four
contains ___________ masters.
In PowerPoint, Master view exist in
204 View Slide Show Design Review
__________ Tab.
205 Screenshots image is __________ Logical Image Static Images Dynamic Image None

A __________ is a visual
representation of information that
206 can quickly and easily create, for Slide Show SmartArt graphic Shapes None
effectively communicate messages
or ideas.

All options to insert a video are

207 located on the Insert tab, in Symbols Image Link Media
the_________ group.
There are ______ different kinds of
208 animation effects in PowerPoint Six Four Five Seven
2010
__________ Animation effects
209 Entrance Emphasis Motion Paths All
exist in PowerPoint 2010

__________ are motion effects

that occur in Slide Show view when
210 Slide Show Animation Slide transitions None
we move from one slide to the
next during a presentation.
Default page orientation in Power
211 Custom Portrait Landscape None
point is ___________
Default number of handouts exist
212 in one page, in PowerPoint are 10 6 8 12
______
In PowerPoint, Rehearse time
213 option exist in ________ group of Set Up Start Slide Show Monitor None
slide show Tab.

__________ slide show option use

From Current
214 for, to choose the slides to use in Custom Show From Beginning None
slide
the show and the order shown.
_________ key is use to exist from
215 Esc Delete Enter Break
slide show.
The __________ view provides a
216 thumbnail view of the slides in a Reading view Slide Sorter Normal view Master view
presentation.
view is to view a presentation not
in full-screen Slide Show view, but
217 in a window with simple controls Reading view Slide Sorter Normal view Master view
that make the presentation easy to
review.
________view occupies the full
computer screen, exactly the way
218 presentation will look on a big Reading view Slide Show Normal view Master view
screen.

__________ View is used in

219 viewing presentation with speaker Reading view Slide Show Normal view Presenter
notes on one computer.
 __________ is the main editing
220 view where we can write and Reading view Slide Show Normal view Presenter
design the slides of a presentation.
_______ Number of tabs exist in
221 12 6 9 13
PowerPoint
Number of master views exist in
222 4 2 3 6
PowerPoint
To insert a new slide in power
223 point using keyboard __________ CTRL+M CTRL+K CTRL+N None
key used
First group in view tab in
224 Zoom Master View Presentation View Macro
powerpoint is __________
which tab contain macro tool in
225 Design Home Tab Insert View
PowerPoint ________
Default paper size in power point
226 Legal A4 Letter Executive
___________
To define time for a particular slide
227 Play Narration Rehearse Time Use Timings None
__________

An Access database stores its

228 tables in a single file, along with Macros Forms Reports All of These
other objects, such as _________.
A part of an Access database are
229 Tables Spreadsheet Document None
__________.

______ are sometimes referred to

230 Reports Tables Forms Queries
as "Data Entry Screens".
_________ are what we use to
231 summarize and present data in the Reports Tables Forms Queries
tables.
Reports are generally formatted to
Sent as e-mail Viewed on the Exported to
232 be printed out, but they can also All of These
message screen another program
be ________
________is used to retrieve
233 Reports Tables Forms Queries
specific data from the tables.
Macro is attached through
_______________on a
234 Both A and B Command button VB Application Nither A Nor B
form so that the macro runs
whenever Macro is required.
A module is a collection of
235 _________ that are stored Procedures Declarations Statements All of These
together as a unit.
A record is also commonly called a
236 ________ and a field is referred as Data,Records Row,Column Column,Row Raw Facts,Data
a _______.
The Size of Memo Data Type is
237 63999 255 63000 16384
___________
_______data type is a
combinations of text and numbers,
238 as well as numbers that don't AlphaNumeric Text Number None
require calculations, such as phone
numbers.
 The Size of Date/Time Data Type is
239 8 bytes 4 bytes 6 bytes 10 bytes
___________
What is the size of AutoNumber
240 Data Type if FieldSize 8 bytes 4 bytes 6 bytes 16 bytes
property is set to Replication?

Yes and No values and fi elds that

241 contain only one of two values that On/Off Yes/No True/False All of These
includes ___________.

_______is used to creates a field

242 Lookup Wizard Text Field None
that allows the user to choose.

Fields that are part of a table

243 Values Text Keys None
relationship are called ________.

A table can have only one

_______________ which consists
244 of one or more fields that uniquely Super key Primary key Foreign key Candidate key
identify each record that is stored
in the table.

________ contains values that

245 correspond to values in the Super key Primary key Foreign key Candidate key
primary key of another table.
Determine the Find and organize
The design process consists of Specify primary
246 purpose of the the information All of These
__________. keys.
database. required.

By importing a By linking to a
table from table from
another data another data
source - such as a source - such as a
We can create a table by creating a Microsoft Offi ce Microsoft Offi ce
Table into an
247 new database, by inserting a Excel 2007 Excel 2007 All of These
existing database
__________. Workbook, a Workbook, a
Microsoft Offi ce Microsoft Offi ce
Word 2007 Word 2007
document or document or
another database. another database.

To import or link a table in a Access Another Access

248 Excel worksheet XML file All of These
2010 user use ______________ Database

SharePoint is a web site that can be

displayed in a browser such as
249 ________ and includes an interface Both A and B IE Access None
for displaying lists and libraries in a
secure database.

The predefined templates in Office

250 Both A and B Contacts Issues Nither A Nor B
Access 2010 include _________.
 Every field has a name that
251 uniquely identifies the field within Not Say's True FALSE None
a table.
Every field has an associated group
252 Properties Records Data None
of settings called __________.

253 _________ is never empty or null. Records Fields Primary key Tables

Access automatically creates an

254 Data Charts Index None
________ for the primary key
___________properties affect how
255 our information appears in table Caption Format InputMask All of These
and query datasheets.

_____is used to enter text that

256 appears when a record violates the Validation Text Records Fields Validation Critaria
Validation Rule expression.
In Ms Access types of controls Calculated
257 Bound Controls Unbound Controls All of These
includes ___________. Controls
In Access, Properties are display in
258 a property sheet also called Property Control Property window Field Discription None
___________.
__________ can be defined as an
operation that extracts record(s)
259 Form Table Query Report
from a database based on a given
condition.

A query consists of search criteria

260 expressed in a database language SQL BASIC COBOL FOTRAN
called ______________.

Choose the Query

Wizard provided Create own
User can create a query in MS- by Microsoft queries from
261 Both A and B Nither A Nor B
Access using __________. Access for the scratch using
ease of user to query design.
build a query.

__________ querie are useful for

summarizing information,
262 Crosstab Select Update Make Table
calculating statistics, spotting bad
data and looking for trends.

Update records or
Action query is used to creating entirely Delete rows from
263 Create new table All of These
___________. new ones in a existing table
table
Delete query not deletes all
264 records in an underlying table from Not Say's True FALSE None
the set results of a query.
_______ query is used to create a
new table and populate it with
265 Crosstab Select Update Make Table
data from one or more existing
tables.
 __________query allows the user
266 to make global changes to data in Crosstab Select Update Make Table
one or more tables.
A _______ query is used to pass a
267 parameter to a different query Data Sub Parameter Make Table
such as an action or a select query.
The SQL aggregate query includes
268 Var Sum Last All of These
__________functions.
___________ may be used by a
269 user to automatically create a Sub Query wizard Simple query None
simple query.
Using Simple Query Wizard,
270 Summary Option functions are Date Text Number Time
word on _________only.
271 <> means __________. Not In Equal to Not equal to Is Null

The _________ property in IDEA

provides statistical information
272 Filters Field Statistics Sorting None of the above
about all Numeric, Date, and Time
fields within the active database.

How can we come to know about By applying the

By checking the Can't be known at
273 the transactions performed on Both A & B dow() function on
date statistics all
Sundays? the sample

The probability-based sampling

274 Stratified Random Systematic Random All of the above
techniques of IDEA are_________.

__________________ is a method
to extract a number of records Systematic Record Monetary Unit
275 Stratified Random Random
from a database at equal intervals Sampling sampling
to a separate database.

Random Sampling in IDEA is done Random Number Without any

276 Functions None of the above
based on____________ Seed technique

To divide the data from the file into

277 bands and gaining the profile of the Sorting Sampling Stratification Filtering
data is known as _______________

________________functions assist
the user to sift through large
Duplicate
278 volumes of data and help pin-point Both A & B Gap Detection Sorting
Detection
specific duplicate entries or specific
missing entries.
Missing cheque numbers can be
Duplicate
279 traced using the Gap Detection Sampling Filtering
Detection
_________function.
The file extension of an IDEA file
280 .IDEA .IMD .IDE .IDF
is_______.
To know any To test for gaps in
Gap Detection is done to check To test for
281 missing unique the invoice All of the above
for____________. completeness
number numbersequence
 In order to map the outstanding
debts at the year end so as to to
determine provisions required
282 Ageing Analysis Sampling Gap Detection Filtering
against bad
debts,__________technique is
used.
Intervals for ageing analysis in IDEA
283 Years Days Months All of the above
can be in________.
The most common use of the Accounts
284 Ageing analysis is with Loans & Advances Receivable or Accounts Payable None of the above
______________. Debtor Ledgers

_____________technique can be
used in IDEA to extract records
285 Stratification Ageing Direct Extraction Summarisation
where the credit limit of customers
is exceeding Rs.50,000.

The _____________ generates a

database and optionally a results
286 output, that we can analyze to Summarisation Gap Detection Benford's Law Direct Extraction
identify possible errors, potential
fraud, or other irregularities.

Fields and their properties can be

Field
287 changed using Field Statistics Field Properties Virtual Field
Manipulation
_________________ in IDEA.

In Financial audit,compliance with

tax rates can be found using Extract &
288 Join Filter All of the above
________________functions of Compare files
IDEA.

We can know about the ghost

289 employees of an organisation using Summarization Join Summarization All of the above
which techniques of IDEA?
Details of Dormant accounts can be
known Join, Relation, Identify Gaps, Aging, MIS, date Date difference,
290
by_______________techniques in Filter, Statistics date difference difference Aging, Filter
IDEA.

The Information Technology (IT)

291 2007 2005 2006 2008
Act 2000 Amended in year ______.
CAATs provide a mechanism to
292 gain access and to __________ as sorting data data technique analyze data organize data
per audit objective.
CAATs can be used to perform
routine functions or activities
293 Smart Pones Calculator PDA computers
which can be done using
_________.
CAATs Improving the efficiency and
294 Audit process Computer process System process None of the above
effectiveness of the __________.
CAATs support the features of Frequency
295 Sampling Stratification All of the above
___________. analysis
 What is the shortcut key for
296 Alt+F7 Ctrl+F7 F7 Shift+F7
finding word with similar meaning
__________is not an option of the
297 Drop Cap Margins Size Columns
Page setup group.
A __________ setting adds extra
298 space to the side or top margin of Mirror margin Left margin Gutter margin Right margin
a document for binding
______option of the Mailings tab is
used to correlate fields from a data
299 source to fields in a main FindFields Select Recipient Match Fields None of the above
document having different field
names

__________ can help to separate

300 sections of a document and make Columns Orientation Watermark Theme
them look interesting to read
Watermark option is in
301 __________group of Pagelayout Pagesetup Page Background Theme None of the above
tab
To combines a document with a list
of names and addresses to produce
302 Mail merge Main document Data source Merge field
individualized documents name as
____________.

We use _________ when we want

to create a set of documents, such
303 Smart art Mail merge macros End notes
as a form letter that is sent to
multiple recipients.

304 Shortcut key for Printlayout is ALT+W+L ALT+W+P ALT+W+U ALT+W+O

Portable
Printable Portable Portable
305 PDF stands for _____________. Documented
Document Format Documents Form Document Format
Format
Which button on the Mailings tab
is used to correlate fields from a
Auto Check for
306 data source to fields in a main Compare Fields Find Recipient Match Fields
Errors
document that have different field
names?
Which of the following is not a
307 default document type for a mail Memos Letters Envelopes Directory
merge?
How is the information in a data
308 Table Chart Matrix Paragraphs
source organized?
What is the name of the column
309 heading for each category in a data Field name Data field Field Record
source?
By Default,When a field name has
a space in its title, such as Last
310 Name, how is the merge field Last_Name LastName Last-Name Last\Name
displayed in the mail merge
document?
 Which key should be pressed to
311 start a new paragraph in MS Word Shift + Enter Down Cursor Key Enter Key Ctrl +Shift+ Enter
2010?
) In MS Word 2010, the extension Reversible Text Return Text
312 Return Text File Rich Text Format
"rtf" stands for ___________. Format format

________ option in Ms-Word 2010

313 shows paragraph marks and other Clipboard Show/Hide Enable/Disable Styles
hidden formatting symbols?
In H2O the figure 2 is appeared
314 lowered. Which effect has been Subscript Superscript Lowered Laid down
applied?
Which of the following shortcut
315 Alt+F7 Ctrl+F7 F7 Shift+F7
key is used to check spelling?

In Word 2010, ____________ is a

preset document layout with a
316 collection of styles which are saved Style Template Screenshot Agenda
to a file and can be applied to
other documents
In Word 2010, ____ option
automatically resizes the table to Fixed column AutoFit to
317 AutoFit to window None of the above
fit in a Web browser window when Width contents
window size is changed.

To adjust a list in single page we

318 column break section break continous break next page break
use
The extension file name for the list
319 .accdb .mdb .rtf .swp
of mail merge is
Orientation modes in Word2010 horizantal and
320 wide and narrow top and bottom none
are vetical
321 Monarch is an example of both a and b printing option envelop option none
322 Behind text is an option of format text wrap text word art text box
We would use a ____break if we
even or odd next page section previos page
323 wanted different kinds of continous break
section break section break
formatting on the same page
A utility of word2010 is used when
we need to refer to specfic lines in
324 both count numbers line numbers none
a document such as script or legal
contract

An _____ has an installed

functionality that adds custom
325 meta-ins add ins plug-ins none
commands and new features in
office 2010 programs

326 Add-ins run without notification true false

 A __________ is a visual display of
the most important information
needed to achieve one or more
327 objectives; consolidated and DBMS Dashboard Spreadsheet None of These
arranged on a single screen so the
information can be monitored at a
glance.―

Dashboards can be categorized Operational Strategic Analytical

328 All of These
based on ___________. Dashboards Dashboards Dashboards

___________ comes handy for the

top-level management in decision
Operational Strategic Analytical Informational
329 making and to determining and
Dashboards Dashboards Dashboards Dashboards
aligning with strategic targets
within the organization.

Strategic dashboards require to

330 have periodic and static snapshots Annually Daily Weekly All of These
of data that includes _________.
Finance Sales
Examples of analytical dashboards
331 Both A and B Management Management Nither A Nor B
include ___________.
dashboard dashboard
________ are mini charts. It can be
prepared either Row wise or
332 Column Pie Sparklines Diagrams
Column-wise and can be placed in
a single cell.

________ is an excellent feature

which is used for summarising
333 PivotTable Table Charts None of These
large data sets and help in quick
analysis of data.
Excel has several built-in chart that
334 Bar Column Scatter All of These
includes __________.
Compare data
335 Line chart is used for __________. Distribution Trends over time All of These
values
Which feature is added In Excel
Recommended Reconnected
336 2013 and Excel 2016 related to Reinstalled Charts None of These
Charts Charts
Charts?
__________option is selected,
then the changes will be reflected
Defer Layout
337 only if we manually click on Update Row Filters Both A and B
Update
button on Right hand bottom side
of PivotTable Field list.

Save the Excel

E-mail the Excel dashboard
Dashboard is ready to share, we Share the
338 dashboard workbook on a All of These
can __________. dashboard online.
workbook. shared network
drive.
What is the shortcut key to Put
339 Ctrl+D Ctrl+T Ctrl+L Both A and B
Your Data in an Excel Table?
__________ work like a filter
340 Filters Table Slicers Sorting
without going to dropdown.
 Multiple
341 Slicers is used for ________. Both A and B Pivot Tables Nither A Nor B
PivotTables
Options>Tools>Fie Options>Calculati
Options>Tools>Fo
How to Add a Simple Calculated lds,Items & ons>Fields,Items
342 rmulas>Calculated None of These
Field in PivotTable ? Sets>Calculated & Sets>Calculated
Fields
Fields Fields

In Excel if we have rows more than

5 lacs rows then system start
This type of
working slow and get hanged or
343 Both A and B Pivot Tables PowerPivot problem not
“Not Responding to handle this
arised
situation Microsoft introduced
_______feature.
Text files delimiters includes
344 Both A and B Tab Comma Nither A Nor B
___________.
According to Text import Wizard
345 Text qualifier includes Both A and B " ' Nither A Nor B
___________.
Single File Web Page format
346 Both A and B .mht .mhl Nither A Nor B
includes ____________.

______ allow us to query data from

a specific World Wide Web,
347 Internet, or intranet site and Web Engine Web queries Web Browser Web Casting
retrieve the information directly
into a Microsoft Excel worksheet

PivotTable report is an interactive

348 way to quickly summarize New Small Large Quick
________ amounts of data.
PivotTable Field List pane includes
349 Values Report Filter Column Labels All of These
_________.
Choose where you want the pivot
Current Existing
350 table report to be placed includes New Worksheet Both A and B
Worksheet Worksheet
________.

Pivot gives us the facility to

351 __________ fields upto any Level Conclusion Group & subgroup Summary None
by adding to Rows or Columns.
To Expand all our categories: Select Options> Active Options>Tools>Ac
Options>Tools>Ex
352 PivotTable tools from Ribbon go to field>Expand tive>Expand None
pand entire Field
____________. entire Field entire Field

PivotTable Tools > PivotTable Tools > PivotTable Tools >

Slicer can be accessed from
353 Options>Insert Options>Activity>I Options>Sort & None
____________
Slicer nsert Slicer Filter>Insert Slicer

________group that enables us to

add subtotals and grand totals to
354 Options Layout Design Pivot Table
the pivot table and modifyits basic
layout.
 Apart from sum PivotTable gives us
the several other options for
355 StdDat Design Sum Product
summarisation that includes
__________.
Smallest to
356 Sorting could be from________. Both A and B Left to Right Nither A Nor B
Largest
_____are also used to indicate
357 progress or decline or to indicate Shapes Icons Colors None
good or poor results.
Filtering filter condition includes
358 Both A and B Equal to Top 10 Nither A Nor B
___________.
IS PivotTable also gives us the
359 possibility of presenting data with Not Say's True FALSE None
conditional formatting?

Instead of a table full of numbers, a

360 PivotChart can use Pie Columns Bars All of These
_________illustrate the numbers.
Normal Charts not includes but
Collapse or
361 Pivot Charts Includes Summary Sort data Both A and B
Expand
__________fields.
After we insert a pivot
362 3 1 2 4
chart_____new tabs are available.
Is Tool Tab is a part of Pivot Charts
363 Not Say's True FALSE None
Tabs?

_______operater is used if value is

364 Is Null Between Not Between Is Not Null
not missing from the field.
In like operater * Any series of
365 Both A and B Single character Nither A Nor B
means__________. characters
Reports provide the most flexible
Summarized General
366 way of viewing and printing Deep information All of These
information information
___________.

For information
that needs to be
Report Header section is as a
367 communicated Cover page Cover letter All of These
________.
only once to the
user of the report.

_________controls in the Page

Character or Number or
368 Header section normally print at Text or text box Date or date box
character box number box
the top of every page.
In Access, Page Footer section
369 Both A and B Page numbers Control totals. Nither A Nor B
usually contains __________.
Most Unique Monetary Unit Money Unit
370 MUS stands for _______. All of the above
Sample Sampling Sample

__________ are tools for drawing

inferences and gathering relevant Business Re-
371 Data Warehouse CAATs None of the above
and reliable evidence as per engineering
requirements of the assignment.
 CAATs can be applied even by
372 using commonly used software MS PowerPoint MS Excel MS Access MS Word
such as ________.
Different types of files such as
373 ___________can be accessed in a Excel files. Database Text formats All of the above
CAAT software.
___________functions of CAAT File
374 Data Selection Arithmetic Statistical
enable intelligent analysis of data. Reorganization

Which functions of CAATs enable

File
375 performing re-computations and re- Arithmetic Data Selection Statistical
Reorganization
performance of results?
CAATS can be used effectively to
376 Exceptions Frauds Errors All of the above
detect_______.
Computer
knowledge,
Which is not a factor to be Fees to be given
377 Time constraints expertise, and Level of audit risk
considered while using CAATs? to the auditor
experience of the
IS auditor
Audit is primarily said to be the
process of collecting and
378 Data Information Audit evidence All of the above
evaluating ___________ as per
audit objectives.

Auditor can gather the audit Inquiry and

379 Inspection Observation All of the above
evidence based on_____________. confirmation

The CAAT documentation must Planning Execution Auditor

380 Both A & B
necessarily include ______. documentation documentation Information
Audit findings & Audit conclusions
Planning Execution Audit Evidence
381 are a part of the ___________ None of the above
documentation documentation documentation
documentation.

382 Audit Sampling can be ________. Both A & B Statistical Non-statistical Only A

Which kind of Statistical sampling

Judgemental Systematic Haphazard
383 ensures that each sampling unit in Random Sampling
Sampling Sampling Sampling
a population has an equal chance?
In ___________sampling, the IS
Judgemental Haphazard Systematic
384 auditor places a bias on the Random Sampling
Sampling Sampling Sampling
sample.
IDEA facilitates user to import
external files in different formats
385 DBase MS Access MS Excel All of the above
like ________________ formats
into IDEA database.
In order to find the total sales of
transactions by Cust-no. so as to
produce a list of outstanding Sales
386 Summarization Sampling Sorting Stratification
customer-
wise______________technique
can be used.
 In IDEA, Quick Summarisation can Unique Keys are Unique Keys are Unique Keys are Unique Keys are
387
be used if, more than 4000 upto 1000 upto 4000 only 100
CAATs can be used for compliance
388 White box test Substantive tests Black box test Gray box test
or __________.
Compliance tests Compliance tests
CAATs may be used in performing
389 of application Analytical review of general All of the above
various audit procedures.
controls controls
_________ is primarily said to be
the process of collecting and
390 Observation Recalculation Audit None of the above
evaluating audit evidence as per
audit objectives.
Auditor can obtain the audit
391 Observation Recalculation Inspection All of the above
evidence by _______.
_______ sampling, Involves
selecting sampling units using a
392 fixed interval between selections, Haphazard Systematic Random Judgmental
the first interval having a random
start.
________ sampling, Ensures that
all combinations of sampling units
393 Haphazard Systematic Random Judgmental
in the population have an equal
chance of selection.

The probability-based sampling

394 Stratified Random Random Systematic All of the above
techniques are ________.
The statistical sampling techniques Monetary Unit
395 Attribute Classical Variable All of the above
are __________. sampling
Systematic Record Samplings a
method to extract a number of
396 TRUE FALSE
records from a database at equal
intervals to a separate database.
_________ ar the some examples
Statistical Identify
397 of tests which can be performed Identify errors All of the above
sampling exceptions
using CAATs.
SA stands for ______________ in Standard on Standard on Section on Schedule on
398
CAATs. Account Auditing Auditing Auditing
_________ enable auditors to use Contact
eSecretary
399 computers as a tool to audit CAATs Audit Management
software
electronic data. software
CAATs Documentation required the
400 Execution Work papers Planning All of the above
following steps_________.

There are _____ commonly used

401 5 2 4 3
sampling methods in CAATs.

Non-statistical sampling methods

402 Both A & B Haphazard Judgmental None of the above
are _______ & _____________.
 Interactive
Internet Data Interactive Data Interactive Data
IDEA stands for Database
403 Extraction and Extraction and Example and
____________________. Extraction and
Analysis Analysis Analysis
Analysis

Data should be in row and coloumn

404 TRUE FALSE
format to import in IDEA.
_______ file format was not
405 ODBC Excel XML JPEG
supported by IDEA.
_____________ ensures that all
combinations of sampling units in Judgmental Haphazard
406 Random sampling None of the above
the population have an equal sampling sampling
chance of selection in CAATs.
Which of the following option is
Duplicate Key
407 not available under options under Direct Indexed Sorting
Detection
Extract Group of IDEA?
_______ function is used to extract
records by writing one more Duplicate Key
408 Direct Indexed Key Value
criteria's and allows to save result Detection
in new database.
______to extract specified number
of top or bottom records for each
409 Top Records Direct Indexed Key Value
value of key in a separate
database.
The ______ task is used to identify Duplicate Key
410 Indexed Key Value All of the above
duplicate items in a database. Detection
Duplicate Key Detection can also
411 be used to identify non-duplicate TRUE FALSE
keys.

______ task identifies "missing" Duplicate Key

412 Indexed Gap Detection Key Value
information in a database. Detection
Which of the following search
413 Character Date Numeric Field All of the above
option is provided by IDEA?
Benford's Law, also called the
414 Last-digit law First-digit law IT LAW All of the above
_________.
_____has been used to detect
Duplicate Key
415 unusual patterns that are often the Gap Detection Benford's law None of the above
Detection
result of errors or, worse, fraud.

IDEA only tests positive numbers

416 TRUE FALSE
10 and over in the data file
_______ Function returns the
417 absolute value of a numeric @value @age @abs All of the above
expression.
______ function Returns the day of
418 @dow @date @week None of the above
the week.
_______ Function Returns the
419 @itr @num @int @fr
integer portion of a numeric value.
 _______ function Returns a string
420 with all the numeric characters @justchar @justnumber @justletters @letter
removed.
Which software has been designed
421 to meet the needs of the banking Accounting CBS ERP Graphics
industry?
The CBS Software resides in the Central
422 Database Proxy Antivirus
________________ server. Application
Application
423 CBS is a combination of, Both A & B Network devices None of the above
software
In CBS, the networking devices,
firewalls and other related
424 Database Data Repository Data Centre Server Room
equipments are all housed in the
__________
The servers in the data centre are
425 segregated using the concept of LAN VLAN WAN MAN
__________

Data of all the branches of a bank

426 Proxy Central Database Application Web
are stored in the ________server.

The core banking applications like

427 Finacle, Flexcube, Iflex etc. reside Mail Application Proxy Antivirus
on the __________server.
The bank has the
428 _________version of the banking Client Beta Alpha Final
software.

In CBS, the database server can be Can't be accessed Only through

429 Directly Accessed via WAN
accessed by the other servers, at all VLAN
The IBDS server is located in the Demilitarized
430 LAN Firewall Zone None of the above
_______________ Zone
Which of the following is not a
431 component of the Internet banking ATM Server IBAS IBDS Middleware
system?

Each branch performs the branch

432 operations in totality at the CBS TBA ALPMS All of the above
respective branch itself in _______
How many servers are hosted in
433 7 8 9 6
the data centre?
______________server provides
network security by preventing
434 Antivirus ATM Proxy Firewall
malicious data from entering the
network.
In CBS, the role of the Domain Control access to Prevent entry of Control access to
435 Manage websites
Controller is to, a set of servers malicious code websites

Deciding the access rules to data

Netwok Security System Database
436 and other it resources is the sole
administrator administrator administrator administrator
responsibility of ___________
 In the CBS system, who has the
Security Netwok Database System
437 power to create, modify and delete
administrator administrator administrator administrator
the users in accessing the system.
In the CBS system, who ensures the
Database System Netwok
438 recoverability of data in case of Librarian
administrator administrator administrator
system failure?
Ensuring the strategic placement of
Security Netwok Database
439 IPS and IDS in the network is the Librarian
administrator administrator administrator
pivotal job of ____________
In the CBS
system_____________arranges for Database Netwok Security
440 Librarian
vulnerability assessment and administrator administrator administrator
penetration tests.
All the versions of the CBS
Security System Database
441 application program are Librarian
administrator administrator administrator
maintained by the _________
In the _________version of testing,
442 the overall aspects of a program Beta Alpha Gama Test
are tested.
Which of the following tests are
443 conducted in the development Integration Test Unit Test System Test All of the above
environment?
When the
librarian after
necessary When the
When users start When the users
documentation software is in the
444 User Acceptance Test is, using the accept the
transfers the production
software software
program into environment
production
environment

In the core banking environment,

Central Report
445 the reports are stored in the Database Antivirus
Application Generation
__________server.
In CBS, to ensure security and to
ensure there is no unauthorised
446 usage, a session is allowed to be 20 10 15 5
active for not more
than______minutes.

A normal A switch with a

447 An ATM switch is, An ATM Machine None of the above
networking switch server attached
The value of the Natural PIN is
448 always __________from the pin Multiplied Added Deducted Divided
value.
ATM doesn't perform the following Changing of PIN Withdrawal of
449 Balance Enquiry Depositing Cash
function, number Cash
The encryption of the PIN in the
450 Either A or B HSM SSM None of the above
ATM machine is done by the ,
Cash dispensing at the ATM is
451 Both A & B Cash Journal ATM log Cash Book
recorded in,
 There should The PIN mailer
Card and PIN
Which of the following is not a reconciliation in PIN mailer must and the card
generation should
452 control used in Card and PIN the number of have card and should be
be handled by
generation? cards and PIN account number delivered
separate staff
mailers produced together
There should be PIN mailer must
ATM card should
While evaluating controls in the proper records of be dispatched
453 be dispatched Both A & B
dispatch of ATM cards, the delivered from the Central
from th Branch
cards Office
While evaluatng controls over
454 ATMs, the bank staff should duly Cash remaining Cash inserted Cash dispensed All of the above
reconcile,
The soft copy of the ATM journal is
455 ATM journal Electronic journal Cash journal None of the above
known as
Who forwards the customer details
Central
456 to the internet banking applictions Database server Web server Antivirus server
Application server
server?

___________converts the data to

457 Middleware IBAS Web server Database server
suit the requirements of the IBDS.
Which of the following is not a Lack of Routers
Unauthorised Inadequate
458 security concern in Internet segregation of improperly
access to PIN network security
Banking? duties positioned
The Internet Banking Security
459 Both A & B Firewall policy Access policy Network policy
Policy must include,

The various access points to the Front end

460 User System Web server All of the above
Internet Banking System are, application

In CBS, any attempt that is made to Intrusion Intrusion

461 penetrate the network must be Routers Prevention Detection Both A & B
proactively detected by , Systems Systems
In __________kind of funds
transfer, the money transfer takes
462 NEFT IMPS RTGS None of the above
place in the books of the Reserve
Bank of India

Which of the following is not Name of the PAN of the Account number
Name of the
463 needed to initiate the funds beneficiary beneficiary of the beneficiary
beneficiary bank
transfer? customer customer customer

The member institutions software

Cash
system and RTGS software talk to Straight through
464 Internet Banking Management ATM transactions
each other through defined processing
System
interfaces in_________

Every Straight Through

465 Processing(STP) generates a unique UTR SN PIN None of the above
number known as,
To monitor collections and
466 payments across the country, the CBS IMPS CMS Internet Banking
banks have developed the,
 The various parameters in the CMS
467 Interest Clearing Cycle Credit Limit All of the above
include,
The various controls to be adhered Operational Management Organizational
468 All of the above
to in CBS are, controls controls controls
Organisation structure of the IT
Operational Organizational Management
469 department and IT strategies are None of the above
controls controls controls
handled by,
Banks collect demand deposits and
470 term deposits, out of this they Both A & B SLR CRR None of the above
maintain
How can the adequacy of controls
By doing bank By performing
471 be checked in the CBS By validations All of the above
visits audit
environment?
Review of
Policy dealing with the proper Business
Systems Review of system
472 maintenenace of the organizational Security Policy Continuity
Development logs
assets is a part of _____________ Planning
Procedures
__________is not a part of the
Communications and Operations Firewall security
473 Media Handling E-mail policy Internet policy
management under the Security policy
Policy
A bank ensures the maintenance Business
Disaster
474 and recovery of operations through Systems audit Continuity None of the above
Management
the process of _________ Planning
A plan made to recover from the
Business
impact of any disaster, so as to Disaster Recovery
475 Continuity Systems audit Internet Banking
restore normalcy is known as the Planning
Planning
__________
_________refers to the process of
developing software which Systems
476 Media Handling Audit Review None of the above
produce the required output from Development
the input provided.
If the programs tested result in
inadequacies and deficiencies, then
477 they are sent back to the Testing Audit Programming Design
_______________team for
correction.

Who is responsible of moving a

completely tested program from
478 Designer Programmer Librarian Analyst
the development department to
the production department?

In CBS, vulnerability assessment is

479 Slow Discrete Continuous On-going
a kind of a __________process.

____________are solutions for

dealing with the vulnerabilities
480 Patches Packs Traps All of the above
discovered during vulnerability
assessment.
 ___________is responsible for
Database System Netwok
481 continuously applying patches in Librarian
administrator administrator administrator
the network.
The authorisation done with
another user ID and password in a Maker checker
482 Maker concept Checker concept None of the above
dual control system is known as concept
the,
Reports generated by the system
483 automatically are known as Logs Reviews Messages Alerts
_________
Which of the following is not a log
484 Application Operating system Network Data Base
generated by the system in cbs?
In banks, application logs ar Pre-closure of Loan
485 Limit creation All of the above
egenerated for, deposits authorisation
In the ATMs, cash disposal is
486 ATM Server ATM switch ATM log None of the above
facilitated by the __________.
ATM card of one
ATM card of one
bank can be
bank can be
processed at the
processed at the
ATM card of one ATM kiosk of ATM card of one
ATM kiosk of
bank can be another bank bank cannot be
Which of the following statement another bank only
487 processed only at without any processed at the
is true? because of the
the ATM kiosk of mutual ATM kiosk of
agreement
any one bank. understanding another bank.
between the two
between
banks to allow
customer and
this.
bank.
Natural PIN represents the
________ digits of the decimalised
488 First four First two Last four Middle four
encrypted value of the card
number.

There should be strict security Stock of live cards Stock of blank Access to the
489 All of the above
procedures for, and PIN mailers cards building
To place controls over cash,the
490 bank staff should duly Cash dispensed Miffed noted Cash inserted All of the above
reconcile_______________
Which of the following is not Account balance Details of hot ATM PIN of the Details of
491
stored at the ATM switch? of customers listed cards customers surrendered cards
The information received from the
web server is verified with the data Central database
492 Middleware IBAS IBDS
of the customer held in the server
______________.
___________________is not a Inadequacy of
Stock of blank User Inadequate
493 security concern in Internet security of web
cards authentication network security
Banking. server.

MIS Reports generated during

494 XML Excel PDF All of the above
RTGS are in the ________ formats.
 To overcome the problems arising
out of high volume of
495 NEFT RTGS CMS None of the above
disbursements,______________wa
s developed.
Bbasic documents used in the
Financial Accounting System where
496 Ledger Voucher Journal All
transactions are entered first is
__________
__________ report gives the
Profit & Loss
497 consolidated list of various Balance Sheet Trial Balance None
Report
Accounts and their balances.
Balance Sheet shows the financial
Profit & Loss
498 status of the business as at a Balance Sheet Trial Balance None
Report
particular date.
The Trial Balance has ____ number
499 4 2 3 6
of columns.
In Accounting system, the closing
500 stock can be valued by any method Weighted Average LIFO FIFO All
__________.
Accounts Receivable, also known
501 Bills Remain Bills Receivable Bills Payable None
as ___________
_____________ gives the details of
502 Bills Remain Bills Receivable Bills Payable None
the dues from the Customers.
_________ gives details of your
503 Bills Remain Bills Receivable Bills Payable None
dues to suppliers.
In Accounting system, When we
504 maintain a bank account, we Both A and B bank book Pass book None
prepare ________

_________ are the major

Multiple reports Arithmetical
505 advantages of accounting software Time saving All
on timely basis accuracy
over manual accounting.

As per any accounting software,

506 there are only ________ types of Both A and B debit balance credit balances None
ledger accounts.

All __________ ledger balances are income and

507 Liability Asset All
taken to Profit & Loss Account. expense
difference between income and
Profit & Loss
508 expenses is also taken to ______ Ratio Analysis Balance sheet None
Account
report.
________ is the end point in
Profit & Loss
509 accounting a mirror showing true Balance sheet bank book None
Account
and fair position of a concern.
__________ is that data which is
not expected to change frequently,
510 Relative data Master data Transaction data All
which remain relatively
permanent.
Voucher Type is _______ type of
511 Relative Master Transaction All
data.
 By default there are _______
512 32 24 28 22
voucher types in Tally.ERP 9.
Customer
Cash Relation Customer Relation
513 CRM stand for _______ Relationship None
Management Management
Management
Tally.ERP 9 is a Multilanguage
514 software offering a choice of 40 15 24 60
__________ languages.
The name of the auto backup file
515 TallyBackup.900 TBK.900 ABK.900 None
shall be __________.
In Tally, _________ is a system of
516 Tally Vault Security Control Set Password All
encrypting data.
default, security levels exist in
517 Tally.Net Auditor Data Entry Tally.Net User All
tally.ERP9 _______
Language use for Tally
518 TDL C C++ None
Programming __________
Tally Definition Tally Define Tally Detection
519 TDL stand for ______ None
Language Language Language
______ Key Board shortcut use to
520 F9 Alt +f9 Ctrl + F9 None
select Purchase Voucher
______ Key Board shortcut use to
521 F6 F4 F5 F9
select Contra Voucher
In Tally.ERP 9, we can create
___________ Vouchers for
adjustments with respect to debit
522 Contra Receipt Payment Journal
and credit amounts without
involving the cash or bank
accounts.

______ Key Board shortcut use to

523 ALT+F7 F5 F7 None
select Stock Journal Voucher
Gateway of Tally > Gateway of Tally >
To view the Trial Balance _______ Gateway of Tally >
524 Display > Trial day book > Trial None
is path. Trial Balance.
Balance. Balance.

Gateway of Tally Gateway of

To view Stock Summary ______ is Gateway of Tally >
525 >Vouchers> Stock Tally>Display > None
path Stock Summary
Summary Stock Summary
Tally.ERP 9 facilitates generation of
Outstanding
526 ___________ reports for Ageing Analysis Ratio Analysis None
Report
Outstandings.
___________ is analytical reports
527 Ratio Analysis Balance sheet Profit & loss None
in Tally.ERP 9

Tally.ERP 9 facilitates generation of

__________, which displays the Daily Cash Flow Cash Flow Fund Flow
528 None
sources of the Funds and their Statement Statement Statement
applications.
__________ is an indicator of the
529 operating performance of a Ratio Analysis Balance sheet Profit & loss None
business.
 In Tally.ERP 9, we can view
___________ Report which
530 provides infor-mation on the Budget Analysis Variance Analysis Ratio Analysis None
difference between the actual vs
the budgeted figures.
Profit & Loss
531 Default Ledgr exist in tally _______ Sales Purchase None
Account
For filing of income tax return of a
practicing chartered accountant,
532 ITR-III ITR-I ITR-II ITR-IV
the appropriate return form is
__________ .
To file Incometax return online, www.Incometax.c www.incometaxin www.taxreturnInd
533 None
site is _____________ o.in dia.gov.in, ia.co.in
ITR-1 Filled by person having Income/Loss from Income from Income/Loss from
534 None
income from __________ House Property Salary/Pension Other Sources

_________ ITR form filled by

535 person if Income from Proprietary ITR-III ITR-I ITR-II ITR-IV
Business/Profession

536 ITR-5 Filled by __________ Trusts AOP Companies None

______ ITR will not be available for
537 ITR-6 ITR-4 ITR-5 ITR-7
e-Filing
Return Form can be used by a
538 ITR-4 ITR-2 ITR-3 ITR-5
person being a BOI
To register for the first time on
539 Income Tax Return site, does not BIRTH PLACE PAN NAME MAIL ID
required information like _______
Services offered by e-filing website Check CPC Refund
540 View Form 26AS Check ITR-V status All
_______ Status
Digital signatures are commonly ON-Line Income software financial
541 All
used for ______________. Tax Return distribution transactions

Technically, a digital signature is

a________________ scheme for
542 Mathmatical Physical Logical All
demonstrating the authenticity of a
digital message or document.

Digital Signature Certificates (DSC)

are the digital equivalent (that is
543 Mathmatical physical Logical All
electronic format) of __________
certificates.

digital signature issues by the

licensed Certifying Department of Director of Digital
544 ___________licensed Certifying Both A & B
Authority Electronics Signature
Authority (CA)
CA stand for(in reference of digital Certifying Chartered
545 Contact Authority None
signature) _______ Authority Accountant
RA stand for(in reference of digital Regulation Registration
546 Rule Authority None
signature) _______ Authority Authority
Digital Signature issue by the
547 e-Mudhra TCS NIC All
______
 Digital Signature is mandatory for
Tax Payers
548 __________ as per Income Tax Act Both A and B Companies None
audited u/s 44AB
1961
e-File without
549 ITR-V Filled by _____ AOP Individual BOI
Digital Signature

Download the Income Tax Return

550 MS-Excel 2010 MS-Word 6.0 MS-Excel 6.0 Power Point 2010
(ITR) form in __________ software
In which format Income Tax
551 Return(ITR) file upload return on XLS XBRL XML None
the web site ______
ITR-V should be send to Central
Processing Centre within
552 90 30 60 120
___________ days of uploading
the return.
There is no need of sending ITR-V
acknowledgement to CPC, Chartered
553 Third Party Director Digital Signature
Bengaluru as the return is signed Accountant
by the _________.

Tax Authority Transaction Tax Deduction

554 TAN stand for ____ None
Number Account Number Account Number

Service tax e-filing is taken care by www.Servicetax.g www.incometaxin

555 www.aces.gov.in None
_________ ov.in dia.gov.in,
Autofilling of Automation of Automatic of
556 ACES stands for __________. Central Excise and Central Excise and Central Excise and None
Service Tax Service Tax Service Tax

www.mca.gov.in, Site is use for

557 Service Tax Income Tax Excise None
___________ of return filling
In company law filling, necessary
558 documents as attachments in PDF XML XBRL DOC
________
VFO stand for (In reference of Verification Front Virtual Front
559 Value Front Office None
return filling) _____ Office Office

Sequential Service Request Serial Request

560 SRN stand for ________ None
Request Number Number Number
Form 23AC to be filed by all Compliance Profit & Loss
561 Balance-Sheet Annual Return
Companies for ________ Certificate Account

Form 66 to be filed by Companies

Compliance Profit & Loss
562 having paid up capital of Rs.10 lakh Balance-Sheet Annual Return
Certificate Account
to Rs. 5 crore for __________
Form 23ACA to be filed by all Compliance Profit & Loss
563 Balance-Sheet Annual Return
Companies for __________ Certificate Account

Extensible Mark Xtensible Markup Extensible

564 XML stand for _________ None
Language Language Markup Language
XBRL tags are defined and
565 organized using categorization taxonomies Tag Dictionery None
schemes called ________.
 _______ Form for filing XBRL
document in respect of balance
566 23ACB-XBRL 23AC-XBRL 23ACA-XBRL None
sheet and other documents with
the Registrar