Search your Topic HERE....

December 20, 2012

MS Excel Bits for Bank Exams - Set 5


sponsored links

Friends, here is your 5th set of MS Excel MCQs which are useful for upcoming SBI PO and other exams. All The Best :)

Read Set 1 Here
Read Set 2 Here
Read Set 3 Here
Read Set 4 Here

computer knowledge bits for SBI PO 2013To select a column the easiest method is to …
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

important computer topics for SBI PO exams


  1. great job mam. Hats of u. Can u post some banking g.k for 22nd exam

  2. Thanku so much mam.. Plz upload ms-word questions.. My exam on 22dec

  3. yea,pls provide some ms-word & banking awareness.

  4. in computers what topics I should learn for ibps online clerk exam

    1. You 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.
      Computer Knowledge for IBPS Clerks Online Exam

      All The Best :)

  5. plz like this only provide questions(in bits form) 4 banking awareness.........

  6. mam 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???? me

    1. The link for downloading Admit Cards is activated now friend. Please do check below link

      IBPS Re Exam Call Letter Download

      All The Best

  7. very very thanx sir ..................


Related Posts Plugin for WordPress, Blogger...