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 31 :
How can you delete a record?

  1. Delete the column from the worksheet
  2. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
  3. Select Data > Delete Record from the menu
  4. Click the Delete button on the Standard toolbar
  

Question 32 :
MS-EXCEL can be used to automate

  1. Financial statements. Business forecasting
  2. Transaction registers, inventory control
  3. Accounts receivable, accounts payable
  4. Any of the above
  

Question 33 :
Which menu option can be used to split windows into two

  1. View > window > split
  2. Format > window
  3. Window > split
  4. View > split
  

Question 34 :
Can you set 0,5 Inch left Indentation for a cell in Excel?

  1. Excel does not have 1 ^Indentation feature
  2. You can specify Indentation only If you turn the rulers on
  3. Indentation can be set from Format Cells dialog box
  4. The Indentation can be specified only when printing
  

Question 35 :
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 36 :
What term refers to a specific set of values saved with the workbook?

  1. Range
  2. 00000000
  3. Trend line
  4. What-if analysis
  

Question 37 :
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from

  1. from Fromat ? Cells
  2. from Format > > Auto format
  3. from Table > > Auto format
  4. All of above
  

Question 38 :
How do you display current date and time In MS Excel?

  1. date( )
  2. Today ( )
  3. now( )
  4. time( )
  

Question 39 :
When working in the page break preview, you can

  1. view exactly where each page break occurs
  2. add or remove page breaks
  3. change the print area
  4. all of above
  

Question 40 :
You can activate a cell by

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of above
  

Question 41 :
Which of the following options is not located in the Page Setup dialog box?

  1. Page Break Preview.
  2. Page Orientation
  3. Margins
  4. Headers and Footers
  

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

  1. Formula
  2. Field
  3. Data
  4. Query
  

Question 43 :
When creating a vertical page break

  1. The active cell must be Al
  2. The active cell can be anywhere in the worksheet
  3. The active cell must be in row 1
  4. The active cell must be in column A
  

Question 44 :
Documentation should include

  1. Destination and users of the output data
  2. Source of input data
  3. Information on the purpose of the workbook
  4. All the above
  

Question 45 :
Excel files have a default extension of

  1. Xls
  2. Xlw
  3. Wkl
  4. 123
  

Question 46 :
__ cells involves creating a single cell by combining two or more selected cells.

  1. Formatting
  2. Merging
  3. Embedding
  4. Splitting
  

Question 47 :
To copy cell contents using drag and drop, press the

  1. End key
  2. Shift key
  3. Esc key
  4. None of these
  

Question 48 :
You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.

  1. Standard
  2. Formatting
  3. Drawing
  4. Picture
  

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

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

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

  1. HTML
  2. Pivot Table Field List
  3. Pivot Table List
  4. Pivot Table Report
  

Question 51 :
When you link data maintained in an excel workbook to a word document

  1. The word document can not be edit
  2. The word document contains a reference to the original source application
  3. The word document must contain a hyperlink
  4. The word document contains a copy of the actual data
  

Question 52 :
Formatting a cell In Currency, you can specify

  1. Decimal Places
  2. Currency Symbol
  3. Both of above
  4. None of above
  

Question 53 :
All formula In Excel start with

  1. .>
  2. +
  3. =
  4. -
  

Question 54 :
Which of the following setup options can not be set in the page setup dialog box?

  1. Printer selection
  2. Vertical or horizontal placement
  3. Orientation
  4. Row and column titles
  

Question 55 :
The cell reference for a range of cells that starts in cell Bl and goes over to column G and down to row 10 is ....

  1. G1-G10
  2. B1.G10
  3. B1;G10
  4. B1:G10
  

Question 56 :
Which of the following is not an example of a value?

  1. 350
  2. May 10,2001
  3. 57%
  4. Serial Number 50771
  

Question 57 :
You can copy data or formulas

  1. With the copy, paste and cut commands on the edit menu
  2. With commands on ta shortcut menu
  3. With buttgns on the standard toolbars
  4. All of the above
  

Question 58 :
Which of the following options i not available to remove arrows of Formula Auditing?

  1. Remove all preceden arrows
  2. Remove all dependent arrows
  3. Remove all arrows
  4. Remove all arrows for this cell
  

Question 59 :
To activate the previous cell in a pre selected range, press

  1. The Alt key
  2. The Tab key
  3. The Enter key
  4. None of the above
  

Question 60 :
Which of the following is not true about Find and Replace in Excel

  1. You can search for bold and replace with italics
  2. You can decide whether to look for the whole word or not
  3. You can search in formula too
  4. You can search by rows or columns or sheets
  
Pages