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 1 :
Weight refers to

  1. The print density of characters
  2. The height of the printed character
  3. Upright or Santed shape
  4. The sign and appearance f characters
  

Question 2 :
You can copy data or formulas

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

Question 3 :
You can use drag-and-drop to embed excel worksheet data in a word document

  1. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
  2. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
  3. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
  4. None of above
  

Question 4 :
How can you find specific information in a list?

  1. Select Tools > Finder from the menu
  2. Click the Find button on the standard toolbar
  3. Select Insert > Find from the menu
  4. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
  

Question 5 :
You can open the consolidate dialog box byt choosing' Consolidate from the...... menu.

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

Question 6 :
Which of the following is not a term of MS-Excel?

  1. Cells
  2. Rows
  3. Columns
  4. Document
  

Question 7 :
Ctrl +p shortcut key in Excel will

  1. Open the font dialog box
  2. Apply double underline for the active cell
  3. Fill down in the selection
  4. All of above
  

Question 8 :
How many worksheets can a workbook have?

  1. 3
  2. 8
  3. 255
  4. All of above
  

Question 9 :
Comments put in cells are called.....

  1. Smart Tip
  2. Cell Tip
  3. Web Tip
  4. Soft Tip
  

Question 10 :
Excel probably considers the cell entry January 1, 2000 to be a

  1. Label
  2. Value
  3. Formula
  4. Text string
  

Question 11 :
Which Is not tha function of Edit, Clear command?

  1. Delete contents
  2. Del ete notes
  3. Delete eel Is
  4. Del ete formats
  

Question 12 :
Which of following is Not one of Excel's what-if function?

  1. Goal seek
  2. Solver
  3. Scenario manager
  4. Auto Outline
  

Question 13 :
What does the VLOOKUP function do?

  1. Looks up text that contain V
  2. Checks whether text is the same in one cell as in the next
  3. Finds related records
  4. All of above
  

Question 14 :
Which area in an excel window allows entering values and formulas

  1. Title bar
  2. Menu bar
  3. Formula bar
  4. Standard toolbar
  

Question 15 :
To create a formula, you first:

  1. Select the cell you want to place the formula into
  2. Type the equals sign (-) to tell Excel that you're about to enter a formula
  3. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
  4. Choose the new command from the file menu
  

Question 16 :
Which of the following methods can not be used to enter data in a cell

  1. Pressing an arrow key
  2. Pressing the Tab key
  3. Pressing the Esc key
  4. Clicking on the formula bar
  

Question 17 :
You can create only a horizontal page break by first selecting

  1. A row below the row where you want the page break to occure
  2. A cell in row 1
  3. A cell in column A
  4. a and c
  

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

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

Question 19 :
If you press ..... the cell accepts your typing as its contents.

  1. Enter
  2. Ctrl + Enter
  3. TAB
  4. Insert
  

Question 20 :
Excel displays the current cell address In the..........

  1. Formula bar
  2. Status Bar
  3. Name Box
  4. Title Bar
  

Question 21 :
In a worksheet you can select

  1. Entire worksheet
  2. Rows
  3. Columns
  4. a, b, and c
  

Question 22 :
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

  1. Pie chart
  2. Row chart
  3. Line chart
  4. Column chart
  

Question 23 :
To move to the previous worksheet, press

  1. Alt + PgUp
  2. Ctrl + PgUp
  3. Ctrl + PgDn
  4. Shift + Tab
  

Question 24 :
Gridlines

  1. May be turned off for display but turned on for printing
  2. May be turned on or off for printing
  3. The be turned off for display and printing
  4. a, b and c
  

Question 25 :
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 26 :
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............

  1. ascending order
  2. descending order
  3. alphabetical order
  4. random order
  

Question 27 :
Which of the following format you can decide to apply or not In AutoFormat dialog box?

  1. Number format
  2. Border format
  3. Font format
  4. All of above
  

Question 28 :
When you use the fill effects in the format data series dialog box, you can not

  1. rotate text on the chart
  2. select a fore ground color
  3. select a pattern
  4. select a background color
  

Question 29 :
Auto Calculate will quickly add selected cells if you.......

  1. right click on the status bar and select Sum
  2. click the AutoCalculate but-ton on the toolbar
  3. use the key combination Ctrl+$
  4. Double click the selection
  

Question 30 :
When the formula bar is activated, you can see

  1. The Edit Formula button
  2. The Cancel button
  3. The Enter button
  4. All of above
  
Pages