MS-EXCEL Question & Answers Quiz for Banking, RRB,RBI,IBPS PO, IBPS Clerk, Bank PO.Exam ,IBPS, RRB, RBI, SBI, NABARD examinations MCQ's




Question 121 :
The minimum and maximum value you can set for Save AutoRecovery Info in Excel are

  1. 1 and 120 minutes
  2. O and 120 minutes
  3. 2 and 60 minutes
  4. 1 and 10 minutes
  

Question 122 :
Which of the following is not a basic step in creating a worksheet?

  1. Save workbook
  2. Modifiy the worksheet
  3. Enter text and data
  4. Copy the worksheet
  

Question 123 :
The horizontal and vertical lines on a worksheet are called

  1. cells
  2. sheets
  3. blocklines
  4. gridlines
  

Question 124 :
Each excel file is called a work-book because

  1. It can contain text and data
  2. It can be modified
  3. It can contain many sheets including worksheets and chart sheets
  4. You have to work hard to create it
  

Question 125 :
In a worksheet you can select

  1. The entire worksheet
  2. Rows
  3. Columns
  4. All of the above
  

Question 126 :
Getting data from a cell located in a different sheet is called.

  1. Accessing
  2. Referencing
  3. Updating
  4. Functioning
  

Question 127 :
Which button do you click to add up a series of numbers?

  1. The autosum button
  2. The Formula button
  3. The quicktotal button
  4. The total button
  

Question 128 :
Which types of charts can excel produce?

  1. Line graphs and pie charts only
  2. Only line graphs
  3. Bar charts, line graphs and pie charts
  4. Bar charts and line graphs only
  

Question 129 :
Hyperlinks can be

  1. Text
  2. Drawing objects
  3. Pictures
  4. All of above
  

Question 130 :
Data can be arranged in a worksheet in a easy to understand manner using

  1. auto formatting
  2. applying styles
  3. changing fonts
  4. all of above
  

Question 131 :
What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

  1. Select both cells, and then drag the fill handle over the range you- want, for instance 18 more rows
  2. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
  3. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
  4. All of above
  

Question 132 :
To copy formatting from one area in a worksheet and apply it to another area you would use:

  1. The Edit>Copy Format and Edit>Paste Format commands form the menu.
  2. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
  3. There is no way to copy and apply formatting in Excel - You have to do it manually
  4. The Format Painter button on the standard toolbar
  

Question 133 :
What function displays row data in a column or column data in a row?

  1. Hyperlink
  2. Index
  3. Transpose
  4. Rows
  

Question 134 :
What happens when you press Ctrl + X after selecting some cells in Excel?

  1. The cell content of selected cells disappear from cell and stored in clipboard
  2. The cells selected are marked for cutting
  3. The selected cells are deleted and the ceils are shifted left
  4. The selected cells are deleted and cells are shifted up
  

Question 135 :
How do you tell one cell from another?

  1. By numbers
  2. By letters
  3. By its address
  4. by color
  

Question 136 :
Which of the following is a popular DOS based spreadsheet package?

  1. Word
  2. Smart cell
  3. Excel
  4. Lotus 1-2-3
  

Question 137 :
How can you remove borders applied In cells?

  1. Choose None on Border , tab of Format cells
  2. Open the list on Border tool in Formatting toolbar then choose first tool (no border)
  3. Both of above
  4. None of above
  

Question 138 :
What does SUMIF function do?

  1. Adds up cell values based on a condition
  2. Adds all the numbers in a range of cells
  3. Returns a subtotal in a list or database
  4. All of above
  

Question 139 :
Tab scrolling button

  1. Allow you to view a different worksheet
  2. Allow you to view additional worksheet rows down
  3. Allow you to view additional worksheet columns to the right
  4. Allow you to view additional sheets tabs
  

Question 140 :
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

  1. F8
  2. F9
  3. F10
  4. F11
  

Question 141 :
To delete an incorrect character in a document, __ to erase to the right of the insertion point.

  1. press the left mouse key
  2. double click the right mouse key
  3. press the BACKSPACE key
  4. press DELETE key
  

Question 142 :
Which of the following is not the correct method of editing the cell content?

  1. Press the Alt key
  2. Press the F2 key
  3. Click the formula bar
  4. Double click the cell
  

Question 143 :
In Excel, a Data Series is defined as what?

  1. A type of chart.
  2. A eel I reference.
  3. A collection of related data
  4. Adivision of results
  

Question 144 :
How do you delete a column?

  1. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
  2. Select the column heading you want to delete and select Insert Delete from the menu
  3. Select the row heading you want to delete and select Edit>Delete from the menu
  4. Right click the column heading you want to delet and select delete from .the shortcut menu
  

Question 145 :
To protect a worksheet, you can choose Protection and the Protect Sheet from the..... menu

  1. Edit
  2. Format
  3. Tools
  4. Data
  

Question 146 :
In MS Access-,-a table can have__ primary key /keys.

  1. One
  2. Two
  3. Three
  4. Four
  

Question 147 :
The view that puts a blue a blue line around each page that would be printed is the......

  1. Print Preview
  2. Normal View
  3. Page Break Preview
  4. Split View
  

Question 148 :
L Edit? Delete command

  1. Deletes the content of a cell
  2. Deletes Formats of cell
  3. Deletes the comment of cell
  4. Deletes selected cells
  

Question 149 :
The Name box

  1. Shows the location of the previously active cell
  2. Appears t the left of the formula bar
  3. Appears below the status bar
  4. Appears below the menu bar
  

Question 150 :
Which of the following describes how to select all the cells in a single column?

  1. Right click on column and select Pick from list
  2. Use data - text to columns menu item
  3. Left click on the gray column title button
  4. Pressing Ctrl + A on the keyboard
  
Pages