Search your Topic HERE....

December 19, 2012

MS Excel MCQs for Bank and other Competitive Exams - Set 2

28 comments

sponsored links

Read complete study Material of Computer Knowledge Here. All The Best :)

To open an existing workbook, you can click the Open button on the …… toolbar.
a.   Drawing
b.   Formatting
c.   Forms
d.   Standard
e.  None of the above


What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
a.   F3
b.   F5
c.   F7
d.   F11
e.  None of the above


“Qtr 1, Qtr 2, Qtr 3” is an example of a
a.   Formula
b.   Function
c.   Series
d.   Syntax
e.  None of the above


You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
a.   Edit
b.   Insert
c.   Format
d.   Tools
e.  None of the above


Which of the following is not a worksheet design criterion?
a.   Efficiency
b.   Auditability
c.   Description
d.   Clarity 
e.  None of the above


To copy cell contents using drag and drop, press the
a.   End key
b.   Shift key
c.   Esc key
d.   None of above
e.   None of the above


If you press …., the cell accepts your typing as its contents.
a.   Enter
b.   Ctrl + Enter
c.   TAB
d.   Insert
e.   None of the above


The autofill feature
a.   Automatically repeat values that already are found in the column
b.  Use the fill handle to fill data
c.  Fill data into adjacent cells by using the Fill command
d.   All the above
e.   None of the above


You can create only a horizontal page break by first selecting
a.   A row below the row where you want the page break to occure
b.   A cell in row 1
c.   A cell in column A
d.   a and c
e.  None of the above


You can create hyperlinks from the Excel workbook to
a.   A webpage on company internet
b.   A web page on the internet
c.   Other Office 97 application documents
d.   All
e.  None of the above



If you press ……, the cell accepts your typing as its contents.
a.   Enter
b.   Ctrl+Enter
c.   Tab
d.   Insert
e.  None of the above


Which of the following special function keys allow the content in cell
a.   esc
b.   shift
c.   return
d.   Tab
e.  None of the above


The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……
a.   B1-G10
b.   B1.G10
c.   B1;G10
d.   B1:G10
e.  None of the above


Which of the following is not an option in the spelling dialog box?
a.   Edit
b.   Ignore
c.   Ignore all
d.   Change
e.  None of the above


You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
a.   Edit
b.   View
c.   Format
d.   Tools
e.  None of the above


To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
a.   Edit
b.   Format
c.   Tools
d.   Data
e.  None of the above


The advantage of using a spreadsheet is:
a.   calculations can be done automatically.
b.   changing data automatically updates calculations
c.   more flexibility
d.   all of the above
e.  None of the above


The intersection of a row and column is called :
a.   data
b.   a field.
c.   a cell
d.   an equation.
e.  None of the above


There are three types of data found in a spreadsheet.
a.   data, words, numbers
b.   equations, data, numbers
c.   words, numbers, labels
d.   numbers formulas, labels
e.  None of the above


To 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


Read Set 1 Here.

Read Set 3 Here


MS Excel Bits for Bank PO Exams

28 comments:

  1. Thanks mam. Waiting for more sets

    ReplyDelete
  2. Thanks for your support...

    ReplyDelete
  3. very usefull mam...... thanks.........

    ReplyDelete
  4. can u please provide MS Word bits..my exam is on 22 nd..

    ReplyDelete
    Replies
    1. We will try to post by tomorrow's evening Anu...

      All The Best

      Delete
    2. mam plz upload MS Word bits my exam is on 22nd mrng session

      Delete
    3. Sure Reddy.. YOu can get complete sets by tomorrow's morning

      All The Best

      Delete
  5. can u plz post Ms word bits..my exam is on 22 nd..you are doing a gr8 job ALL THE BEST

    ReplyDelete
  6. Reduction in the value of a currency, usually expressed in terms of another currency, is called_______________.Pls Ans

    ReplyDelete
    Replies
    1. The price of one country's currency expressed in another country's currency is called Exchange Rate Ricky kumar. Not sure about the reduction, may be "floating exchange rate".

      Delete
  7. Reduction in the value of a currency, usually expressed in terms of another currency, is called_______________.Pls Ans this and also I have exam on 22nd.So pls advice me what gk and banking awareness I have go through based on 15 and 16th exams.

    ReplyDelete
    Replies
    1. Just go through the banking terminology and functions of banks. For GA concentrate more on Ministers (after re shuffle), important events occured in last 6 months. Thats enough

      All THe Best

      Delete
  8. hai mam this is santhi its my first exam on 23 dec so pls tell me how many needed for safe zone i mean to qualify in ibps clerk exam

    ReplyDelete
    Replies
    1. Getting only pass marks is of no use Prasanthi... Try to give your best. Try to get 20 marks at least in every section

      All The Best

      Delete
  9. hai mam pls provide some more material in ms office basics

    ReplyDelete
    Replies
    1. Sure Prasanthi... We're presently working on them... YOu can get complete set by this evening.

      Delete
  10. thank u mam....i will try my level best

    ReplyDelete
  11. hai mam is there is any chances repetetion questions from exam on 15, 16 and 22 to 23...my exam is on 23

    ReplyDelete
    Replies
    1. No friend. IBPS will be more cautious this time. There wont be repetitive questions...

      Delete
  12. Replies
    1. Your visit and access your locker on all working days during banking hours Atchut.

      Delete

Related Posts Plugin for WordPress, Blogger...