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 61 :
To apply Goal Seek command your cell pointer must be in

  1. The Changing cell whose value you need to find
  2. The Result Cell where formula is entered
  3. The cell where your targeted value is entered
  4. All of above
  

Question 62 :
The advantage of using a spreadsheet is :

  1. calculations can be done automatically
  2. changing data automatically updates calculations
  3. more flexibility
  4. all of the above
  

Question 63 :
Which of the following methods can not be used to edit the contents of a cell?

  1. Press the Alt key
  2. Clicking the formula bar
  3. Pressing the F2 key
  4. Double clicking the cell
  

Question 64 :
Which of the following methods cannot be used to edit the content of cell?

  1. Pressing the Alt key
  2. Clicking the formula bar
  3. Pressing F2
  4. Double clicking the cell
  

Question 65 :
The cell labeled 23. 54 the cell labeled F5 refers to

  1. row F column 5
  2. column F row 5
  3. function available in cells
  4. function key F4
  

Question 66 :
What are the tabs that appear at the bottom of each workbook called?

  1. Reference tabs
  2. Position tabs
  3. Location tabs
  4. Sheet tabs
  

Question 67 :
Graphics objects on a chart are used to

  1. Add emphasis to chart data
  2. Add interest to a chart
  3. Help explain the chart data
  4. a, b, and c
  

Question 68 :
which of the following special function keys allow the content in cell

  1. esc
  2. shift
  3. return
  4. Tab
  

Question 69 :
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 70 :
What Is the short cut key to highlight the entire column?

  1. Ctrl+C
  2. Ctrl+Enter
  3. Ctrl+PageUp
  4. Ctrl+SpaceBar
  

Question 71 :
When you want to insert a blank imbedded excel object in a word document you can

  1. Click the object command on the insert menu
  2. Click the office links button on the standard toolbar
  3. Click the create worksheet button on the formatting toolbar
  4. Click the import excel command on the file menu
  

Question 72 :
The box on the chart that contains the name of each Individual record Is called the__.

  1. cell
  2. title
  3. axis
  4. legend
  

Question 73 :
Which of the following is a correct order of precedence in a formula calculation?

  1. Multiplication and division, exponential positive and negative value
  2. Multiplication and division, positive and negative values, addition and subtraction
  3. Addition and subtraction, positive and negative values, exponentiation
  4. None of these
  

Question 74 :
How do you wrap the text in a cell?

  1. Format, cells, font
  2. Format, cells, protection
  3. format, cells, number
  4. Format cells, alignment
  

Question 75 :
You can auto fit the width of column by

  1. double clicking on the column name orr-column header
  2. Double click on the cell pointer in worksheet
  3. Double clicking on column right border on column header
  4. Double clicking on the column left border of column header
  

Question 76 :
You can print

  1. A range of cells by range name
  2. An entire worksheet
  3. A single worksheet
  4. All of the above
  

Question 77 :
You can print only an embedded chart by

  1. Moving the chart to a chart sheet before you print.
  2. Formatting the chart before you print
  3. Selecting the chart before you print
  4. a and c
  

Question 78 :
In the formula, which symbol specifies the fixed columns or rows?

  1. A.S
  2. *
  3. -
  

Question 79 :
Give me an example of a cell address.

  1. 1125
  2. 911
  3. 41A
  4. A21
  

Question 80 :
You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.

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

Question 81 :
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......

  1. nothing will print because some cells with data have been omitted
  2. only the cells with gray back-ground will print
  3. the whole sheet will print
  4. only the cells with white background will print
  

Question 82 :
Which of the following is not What IF analysis tool in Excel?

  1. Goal Seek
  2. Scenarios
  3. Macros
  4. All of above
  

Question 83 :
The Cancel and Enter buttons appear In the:

  1. Title bar
  2. Formula bar
  3. Menu bar
  4. Sheet tabs
  

Question 84 :
All worksheet formula

  1. Manipulate values
  2. Manipulate labels
  3. Return a formula result
  4. Use the addition operator
  

Question 85 :
Data marker on a chart are linked to data points in a . worksheet therefore,

  1. You can automatically apply formatting to a data series
  2. You can change the position of a data marker and automatically change the data point value in the worksheet
  3. You can change a data print value and automatically are draw the chart
  4. a and b
  

Question 86 :
To center 'worksheet titles across a range of cells, you must

  1. Select the cells containing the title text plus the range over which the title text is to be centered
  2. Widen the columns
  3. Select the cells containing the title text plus the range over which the title text is to be enfettered
  4. Format the cells with the comma style
  

Question 87 :
The default font used In Excel is

  1. Arlal
  2. Algerial
  3. Times New Roman
  4. Preetl
  

Question 88 :
To delete an embedded objects, first

  1. Double click the object
  2. Select the object by clicking it
  3. Press the Shift + Delete ' keys
  4. Select it and then press the delete key
  

Question 89 :
An Excel Workbook is a collection of.......

  1. Workbooks
  2. Worksheets
  3. Charts
  4. Worksheets and Charts
  

Question 90 :
Which of the cell pointer indicates you that you can make selection?

  1. Doctor's symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. Press F3 + Ctrl
  
Pages