Search your Topic HERE....

December 18, 2012

MS Excel Expected Questions for SBI Clerks and PO Exams - Set 1

29 comments

sponsored links

Friends, as you might have already be aware, in the Computer Knowledge section of all Competitive Exams like Bank PO, Clerk and other exams have mainly concentrating MS Office (especially on MS Excel). We have already updated short notes on MS Excel and MS Office (you can read them here). As this area is very important, Some of our readers requested us to update MCQs on this. So here you are. We're planning to update 5 sets of Expected MCQs on MS Excel. This is set 1 and you will get remaining sets soon. If time permits, we'll try to update MCQs on MS Word too... Hope it helps the aspirants who are going to write the SBI PO Exam tomorrow and the people who are going to write the exams SBI Clerks 2014. All The Best.


Which is not an advantage of using computerized spreadsheets?
a.   flexibility of moving entries
b.   speed of calculation
c.   ability of generate tables
d.   cost of initial setup
e. None of the above

All formula in Excel start with
a.   %
b.   +
c.   =
d.   –
e. None of the above

what is the AutoSummarize feature used for in Word 2000
a.   It creates a 250 word, 500 word or 1000 word summary of the document
b.   It adds Automatic headwers, bold and italic characters as well as automatic formatting of the document to give the look of a well summarized document
c.   it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs
d.   It identifies the key points in a document for your to share with others or quickly scan
e. None of the above

To select several cells or ranges that are not touching each other, you would … while selecting
a.   hold down the Ctrl key
b.   hold down the Shift key
c.   hold down the Alt key
d.   hold down Ctrl + Shift key
e. None of the above


A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button…..
a.   nothing will print because some cells with data have been omitted
b.   only the cells with gray background will print
c.   the whole sheet will print
d.   only the cells with white background will print
e. None of the above

The view that puts a blue a blue line around each page that would be printed is the …..
a.   Print Preview
b.   Normal View
c.   Page Break Preview
d.   Split View
e. None of the above

AutoCalculate will quickly add selected cells if you…..
a.   right click on the status bar and select Sum
b.   click the AutoCalculate button on the toolbar
c.   use the key combination Ctrl+$
d.   Double click the selection
e. None of the above


A constant is another name for this type of data:
a.   number
b.   equation
c.   formula
d.   description
e. None of the above


The cell labeled 23. 54 the cell labeled F5 refers to
a.   row F column 5
b.   column F row 5
c.   function available in cells
d.   function key F4
e. None of the above

When you are typing an equation into a cell the first thing that must be entered is
a.   the first cell referenced
b.   parenthesis
c.   quotation marks
d.   an equal sign
e. None of the above



Using the AutoSum button will replace in the selected cell….
a.   the sum of values  in the cell’s column
b.   nothing until you select a range of cells
c.   the sum of the cell’s row unless you change the range
d.   a formula which will add values in the range Excel guesses you want to add
e. None of the above


Book1 is an example of how … are numbered and named during each work session
a.   Active cell
b.   Formula bar
c.   Menu bar
d.   Name box
e. None of the above


Which of the following displays the contents of the active cell?
a.   Active cell
b.   Formula bar
c.   Menu bar
d.   Name box
e. None of the above


Graphics objects on a chart are used to
a.   Add emphasis to chart data
b.   Add interest to a chart
c.   Help explain the chart data
d.   a, b, and c
e. None of the above


What does SUMIF function do?
a.   Adds up cell values based on a condition
b.   Adds all the numbers in a range of cells
c.   Returns a subtotal in a list or database
d.   All of above
e. None of the above


You can insert labels for
a.   All the data markers on a chart
b.   A data series
c.   A selected data marker
d.   All
e. None of the above


Tab scrolling buttons
a.   Allow you to view a different worksheet
b.   Allow you to view additional worksheet row down
c.   Allow you to view additional worksheet columns to the right
d.   Allow you to view additional sheet tabs
e. None of the above


You can add a hyperlink to your worksheet by pressing
a.   Alt + K
b.   Ctrl + H
c.   Ctrl + K
d.   Ctrl + Shift + K
e. None of the above



All macro keyboard shortcuts include the ….. key
a.   Alt
b.   Ctrl
c.   F11
d.   Shift
e. None of the above


To open the Format Cells dialog box, press
a.   Alt + 1
b.   Ctrl + 1
c.   Ctrl + Shift + 1
d.   F1
e. None of the above


sponsored links

29 comments:

  1. Thanks 4 ur effort mam bt mam please provide ms-word questions. I have a exam on 22.

    ReplyDelete
  2. Thanks 4 ur effort mam bt mam please provide ms-word questions. I have a exam on 22.

    ReplyDelete
  3. Mam plz provide ms-word question

    ReplyDelete
  4. Great effort admin. I wrote my exam on 15th eve and unable to do well in computer section. Luckily my exam got cancelled and gonna held on 29th. This time i never gonna lose it again. Please try to post the remaining sets and some mcqs on ms word too as soon as possible. It will definitely help so many people. thanks in advance
    Sahi...

    ReplyDelete
  5. thanq shivaniji its a great effort frm ur team n hleping us a lot.

    ReplyDelete
  6. mam pls add if any extra questions based on ms-excel and ms-word becoz my exam is on 22nd mrng session

    ReplyDelete
    Replies
    1. Sure Friend. We're planning to update 5 sets of expected questions on MS Excel. You can get all sets by tomorrow's evening

      All The Best :)

      Delete
  7. plz upload 5 sets excel n 5 sets ms word before 22 dec.

    ReplyDelete
  8. Madam I ve not yet got any reply for the question asked.plz reply me madam.Awaiting youth answer.

    ReplyDelete
    Replies
    1. Sorry Srinivas. We dint get any question from you. There might have some problem with it.. Please do post again

      Good Day

      Delete
  9. thank you very much mam, you are doing gr8 job, plz also give us MS-WORD information and practice papers..

    thank you again..

    ReplyDelete
  10. Thank you very much mam..

    ReplyDelete
  11. good effort but i want more questions my exam is canceled and i have re exam on 29 or 30.... this time the level of questions is higher.. please post as much questions u can

    ReplyDelete
  12. Thanks a lot for the qns..

    ReplyDelete
  13. it's realy nice......and ur reply thouse who wants it...

    ReplyDelete
  14. please combine all the 5 sets in a single pdf and make it available for download so that we can download and study in our own computer.

    pls do the needful

    ReplyDelete
  15. great n very useful for the current pattern of IBPS.......

    ReplyDelete
  16. thanku for u r support sir u r brilliant

    ReplyDelete
  17. Hello Mam, thanks for uploading mcq's..i have a doubt for macros is it alt or ctrl button from keyboard..help

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...