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 181 :
Status indicators are located on the

  1. Vertical scroll bar
  2. Horizontal scroll bar
  3. Formula bar
  4. Standard toolbar
  

Question 182 :
MS-EXCEL is based on .-.....-?

  1. WINDOWS
  2. DOS
  3. UNIX
  4. OS/2
  

Question 183 :
Which of the following is a correct order of precedence in formula palcuiation?

  1. Multiplication and division exponentiation positive and negative values
  2. Multiplication and division, positive and negative values, addition and subtraction
  3. Addition and subtraction, positive and negative values, exponentiation
  4. All of above
  

Question 184 :
You can use the format painter , multiple times before you turn it offby

  1. You can use the format painter button only one time when you click it
  2. Double clicking the format painter button
  3. Pressing the Ctrl key and clicking the format painter button
  4. Pressing Alt key and clicking the format painter button
  

Question 185 :
To edit data in an embedded Excel worksheet object in a Word document

  1. Use the Excel menu bar and toolbars insjde the word application
  2. Edit the hyperlink
  3. Edit the data in a Excel source application
  4. Use the Word menu bar and toolbars
  

Question 186 :
What is represented by the small, black square in the lower-right corner of an active cell or range?

  1. Copy handle
  2. Fill handle
  3. Insert handle
  4. Border
  

Question 187 :
How do you rearrange the data In ascending or descending order?

  1. Data, Sort
  2. Data, Form
  3. Data, Table
  4. Data Subtotals
  

Question 188 :
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 189 :
What is the short cut key to replace a data with another in sheet?

  1. Ctrl + R
  2. Ctrl + Shift + R
  3. Ctrl + H
  4. Ctrl + F
  

Question 190 :
You accidentally erased a record In the sheet, What command can be used to restore It Immediately?

  1. Insert
  2. Copy
  3. Undo
  4. Replace
  

Question 191 :
When the formula bar is active, you can see

  1. The edit formula button
  2. The cancel button
  3. The enter button
  4. All of the above
  

Question 192 :
The command Edit ?Fill Across Worksheet is active only when

  1. One sheet is selected
  2. When many sheets are selected
  3. When no sheet is selected
  4. All of above
  

Question 193 :
Using the AutoSum button will replace in the selected cell......

  1. the sum of values jn the cell's column.
  2. . nothing until'ybu select a range of cells
  3. the sum of the cell's row unless you change the range
  4. None of these
  

Question 194 :
All macro keyboard shortcuts include the...... key

  1. Alt
  2. Ctrl
  3. F11
  4. Shift
  

Question 195 :
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

  1. Unfreeze panes command on the window menu
  2. Freeze panes command on the window menu
  3. Hold titles command on the edit menu
  4. Split command on the window menu
  

Question 196 :
When the formula bar is active, you can see

  1. The edit formula button
  2. The cancel button
  3. The enter button
  4. All of the above
  

Question 197 :
You can insert labels for

  1. All the data markers on a chart
  2. A data series
  3. A selected data marker
  4. All
  

Question 198 :
Which of the following is a cor-rect 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 above
  

Question 199 :
Excel is a good application for What IF analysis. Which of the following tool help you for this?

  1. Formul Auditing
  2. Research
  3. Track Change
  4. Goal Seek
  

Question 200 :
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 above
  

Question 201 :
The Trace Dependence in auditing shows

  1. Which cells are used in current formula
  2. In which formula the current cell is used
  3. Which cells are used in this formula and in which formula this cell is used
  4. All of above
  

Question 202 :
To drag a selected range of data to another worksheet in the same workbook, use the

  1. Tab key
  2. Alt key
  3. Shift key
  4. Ctrl key
  

Question 203 :
When integrating word and excel, word is usually the

  1. Server
  2. Destination
  3. Client
  4. Both b and c
  

Question 204 :
You can create hyperlinks from the Excel workbook to

  1. A webpage on company internet
  2. A web page on the internet
  3. Other Office 97 application documents
  4. All
  

Question 205 :
When you copy a formula

  1. Excel erases the original copy of the formula
  2. Excel edits cell references in the newly copied formula
  3. Excel adjusts absolute cell references
  4. Excel doesn't adjust relative cell references
  

Question 206 :
Which language is used to create macros in Excel?

  1. Visual Basic 4
  2. C
  3. Visual C++
  4. Java
  

Question 207 :
Which of the following is not true regarding Conditional Formatting?

  1. You can add more than one condition to check
  2. You can set condition to look for Bold and apply Italics on them.
  3. You can apply Font, border and pattern formats that meets the specified conditions
  4. You can delete any condition from Conditional Formatting dialog box if it is not requried
  

Question 208 :
Which of the following displays the contents of the active cell?

  1. Active cell
  2. Formula bar
  3. Menu bar
  4. Name box
  

Question 209 :
Hyperlinks can be

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

Question 210 :
Multiple calculations can be made In a single formula using....

  1. Standard Formulas
  2. Array Formula
  3. Complex Formulas
  4. Smart Formula
  
Pages