MS Excel Expected Questions for SBI and Other Bank Exams' Computer Knowledge Section - Set 4

sponsored links

Friends, here is the set 4 of Computer Knowledge bits for SBI PO bank exams. All The Best and happy reading :)

Read Set 1 Here

Read Set 2 Here

Read Set 3 Here

Excel is a__________________

a.   Graphic program

b.   None of these

c.   Word processor

d.   A spreadsheet

e. None of the above

To view a cell comment, you should

a.   click the edit comment commands on the Insert menu

b.   click the Display comment command on the window menu

c.   position the mouse pointer over the cell

d.   click the comment command on the view menu

e. None of the above

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

a.   Formula

b.   Field

c.   Data

d.   Query

e. None of the above

When you want to insert a blank embedded excel object in w word document you can

a.   Click the object command on the insert menu

b.   Click the office links button on the standard toolbar

c.   Click the create worksheet button on the formatting toolbar

d.   Click the import excel command on the file menu

e. None of the above

A value used in a formula that does not change is called a

a.   Cell address

b.   Constant

c.   Function

d.   Range

e. None of the above

How can you quickly apply professional formatting to your sales forecast worksheet?

a.   Apply special attributes using Format Painter

b.   Apply an Auto Format Style

c.   Apply a selected background color

d.   All of above

e. None of the above

What chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

a.   Category axis

b.   Data marker

c.   Data point

d.   Gridline

e. None of the above

Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page.

a.   Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

b.   Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

c.   Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.

d.   All of above

e. None of the above

A fast way to add up this column of number is to click in the cell below  the numbers and then:

a.   click subtotals on the data menu

b.   view the sum in the formula bar

c.   click the autosum button on the standard toolbar, then press enter

d.   all of above

e. None of the above

You can select a single range of cells by

a.   Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b.   Pressing the Ctrl key while dragging over the desired cells

c.   Pressing the Shift key and an arrow key

d.   Dragging over the desired cells

e. None of the above

You can use the formula palette to

a.   format cells containing numbers

b.   create and edit formulas containing functions

c.   entered assumptions data

d.   copy a range of cells

e. None of the above

What Pivot Table toolbar button updates the data ina Pivot Table or Pivot Chart report if the source data chas changed

a.   Format Report

b.   Pivot Table

c.   Refresh Data

d.   Show Detail

e. None of the above

You can convert existing Excel worksheet data and charts to HTML document by using the

a.   FTP Wizard

b.   Internet Assistant Wizard

c.   Intranet Wizard

d.   Import Wizard

e. None of the above

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

a.   G1-G10

b.   B1.G10

c.   B1;G10

d.   B1:G10

e. None of the above

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

a.   HTML

b.   Pivot Table Field List

c.   Pivot Table List

d.   Pivot Table Report

e. None of the above

You can select a single range of cells by

a.   Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b.   Pressing the Ctrl key while dragging over the desired cells

c.   Pressing the Shift key and an arrow key

d.   Dragging over the desired cells

e. None of the above

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

a.   Go to File-Save As – Save As Type – Excel worksheet

b.   Right click on the spreadsheet tab and select DELETE

c.   Right click on the spreadsheet and select Insert – Entire Column

d.   None of above

e. None of the above

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

a.   Goal Seek

b.   Scenario Summary report

c.   Forecasting

d.   Trend line

e. None of the above

What term describes a background that appears as a grainy, non smooth surface

a.   gradient

b.   pattern

c.   solid

d.   texture

e. None of the above

Which of these will not select all the cells in a document?

a.   Clicking three times with the right mouse button in the spreadsheet

b.   Using the Edit – Select All menu

c.   Pressing Ctrl + A on the keyboard

d.   Pressing Ctrl + A on the keyboard

e. None of the above

ms excel important questions for exams