sponsored links
Read Set 1 Here
Read Set 2 Here
a. Double
click any cell in the column
b. Drag from
the top cell in the column to the last cell in the column
c. Click the
column heading
d. Click the
column label
e. None of
the above
Documentations should include
a.
Destination and users of the output data
b. Source of
input data
c.
Information on the purpose of the workbook
d. All of
above
e. None of
the above
What function
displays row data in a column or column data in a row?
a. Hyperlink
b. Index
c. Transpose
d. Rows
e. None of
the above
When you insert an Excel file into a Word document,
the data are
a.
Hyperlinked
b. Placed in
a word table
c. Linked
d. Embedded
e. None of
the above
Except for the …… function, a formula with a logical
function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
e. None of
the above
Macros are “run” or executed from the ….. menu.
a. Insert
b. Frmat
c. Tools
d. Data
e. None of
the above
What does the VLOOKUP function do?
a. Looks up
text that contain ‘v’
b. Checks
whether text is the same in one cell as in the next
c. Finds
related records
d. All of
above
e. None of
the above
Which of the following is not an underline option in the format cells dialog box?
a. Double
b. Single
Engineering
c. Single
Accounting
d. Double
Accounting
e. None of
the above
Which function calculates depreciation at the same amount each year over an asset’s useful life?
a. DB
(fixed-declining balance)
b. SLN (straight
line)
c. DDB
(double-declining)
d. All of
above
e. None of
the above
To select an individual data marker or data label,
you must
a. Double
click the data series
b. Right
click selected marker
c. Click
once to select the series markers or labels and click the desired marker or
label again
d. Double
click the marker or label
e. None of
the above
To delete and embedded object, first
a. Double
click the object
b. Select
the object by clicking it
c. Press the
Shift + Delete keys
d. Select it
and then press Delete key
e. None of
the above
This type of software contains rows and columns.
a. Drawing
b.
Spreadsheet
c. Database
d. Word
processing
e. None of
the above
You can print only an embedded chart by
a. Moving
the chart to a chart sheet before you print.
b.
Formatting the chart before you print
c. Selecting
the chart before you print
d. a and c
e. None of
the above
A function inside another function is called a ….. function.
a. Nested
b. Round
c. Sum
d. Text
e. None of
the above
Which function calculates your monthly mortage
payment?
a. PMT
(payments)
b. NPER
(number of periods)
c. PV
(present value)
d. All of
above
e. None of
the above
If you are working in English (US), Chinese or
Japanese, Excel 2002 can speak data as you enter it, to help you verify
accuracy. How do you activate this feature?
a. Point to
speech on the tools menu, and then click show text to speech toolbar.
b. Click
validation on the data menu
c. Point to
speech on the tools menu, and then click speech recognition
d. All of
above
e. None of
the above
How should you print a selected area of a worksheet,
if you’ll want to print a different area next time?
a. On the
file menu, point to print area, and then click set print area.
b. On the
file menu, click print, and then click selection under print what
c. On the
view menu, click custom views, then click add
d. All of
above
e. None of
the above
Youar German supplier still invoices for parts in
deutsche marks. How can you have Excel convert those sums to Euros?
a. On the
Insert menu, click Symbol and from the currency symbols subset, select the Euro
sign.
b. On the
tools menu, click Add-Ins, and select the Euro Currency Tools check box
c. Apply a
selected background color
d. All of
above
e. None of
the above
Which of the following methods can not be used to
enter data in a cell?
a. Pressing
an arrow key
b. Pressing
the tab key
c. Pressing
the Esc key
d. Clicking
the enter button to the formula bar
e. None of
the above
You can activate a cell by
a. Pressing
the Tab key
b. Clicking
the cell
c. Pressing
an arrow key
d. All of
above
e. None of
the above
great job mam. Hats of u. Can u post some banking g.k for 22nd exam
ReplyDeleteThanku so much mam.. Plz upload ms-word questions.. My exam on 22dec
ReplyDeleteyea,pls provide some ms-word & banking awareness.
ReplyDeletein computers what topics I should learn for ibps online clerk exam
ReplyDeleteYou should prepare basic computer terminology and abbriviations Shoba. Concentrate more on MS Office (MS Word and Excel) as now a days IBPS is focusing more on this area. Have a look at the below link. It may help you.
DeleteComputer Knowledge for IBPS Clerks Online Exam
All The Best :)
plz like this only provide questions(in bits form) 4 banking awareness.........
ReplyDeletemam i have given my xam on 15th and now it is cancelled......but i have not received any msg on mobile or mail from ibps till now......what to do????........help me
ReplyDeleteThe link for downloading Admit Cards is activated now friend. Please do check below link
DeleteIBPS Re Exam Call Letter Download
All The Best
very very thanx sir ..................
ReplyDeletevery very thanx sir ...........
ReplyDelete