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

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

• Read Set 2 Here
• Read Set 3 here
• Read Set 4 Here
• Read Set 5 Here

sponsored links