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 271 :
The default header for a worksheet is

  1. Your name
  2. The date and time
  3. None
  4. The sheet tab name
  

Question 272 :
To remove the content of selected cells you must issue _____ command

  1. Edit? Delete
  2. Edit ? Clear ? Contents
  3. Edit ?> Clear? All
  4. Data ? Delete
  

Question 273 :
What happens when dollar signs (S) are entered In a cell address?

  1. An absolute eel I address is created.
  2. Cell address will change when it is copied to another cell.
  3. The sheet tab is changed.
  4. The status bar does not display the eel I address.
  

Question 274 :
A data map is helpful

  1. When you have too much data to chart
  2. To show a geographic distri-bution of data
  3. To compare data points
  4. To show changes in data over-time
  

Question 275 :
You can copy data or formulas

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

Question 276 :
We can save and protect 1he workbook by

  1. Write Reservation Password
  2. Protection Password
  3. Read-only Recommended
  4. Any of the above
  

Question 277 :
In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

  1. calendar
  2. photograph of rainfall
  3. chart showing rainfall amounts
  4. data base of rainfall
  

Question 278 :
Formatting a cell In Number format you can't set

  1. Decimal Places
  2. Use 1000 separator
  3. Negative numbers
  4. Currency Symbol
  

Question 279 :
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

  1. worksheet
  2. chart sheet
  3. module sheet
  4. data sheet
  

Question 280 :
Comments put in cells are called

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

Question 281 :
Which of the following is the latest version of Excel?

  1. Excel 2000
  2. Excel 20.02
  3. Excel ME
  4. Excel XP
  

Question 282 :
Merge cells option can be applied from

  1. Format Cells dialog box Alignment Tab
  2. Formatting toolbar
  3. Both of above
  4. All of above
  

Question 283 :
Which would you choose to create a bar diagram?

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

Question 284 :
The name box

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

Question 285 :
Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?

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

Question 286 :
Each excel file is called a workbook 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 287 :
To center worksheet titles across a range of cell, you must

  1. Select the cells containing the title text and use the fill handle to center the text across a range of cells
  2. Widen the columns
  3. Select the cells containing the title text and use the fill handle to center the text across a range of cells
  4. Widen the column
  

Question 288 :
Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the

  1. cell's column label
  2. cell's column label and worksheet tab name
  3. cell's row label
  4. cell's row and column la-bels
  

Question 289 :
Which command will you choose to convert a column of data into row?

  1. Cut and Paste
  2. Edit ? Paste Special ? Transpose
  3. Both of above
  4. Press F7
  

Question 290 :
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 these
  

Question 291 :
Excel uniquely identifies cells within a worksheet with a cell name

  1. Cell names
  2. Column numbers and row letters
  3. Column letters and row numbers
  4. Cell locator coordinates
  

Question 292 :
The chart wizard term data series refers to

  1. A chart legend
  2. A collection of chart data markers
  3. A set of values you plot in a chart
  4. A data label
  

Question 293 :
You can open the Sort dialog box by choosing Sort from the .... menu

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

Question 294 :
The Trace Precedence on 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. None of above
  

Question 295 :
Excel is a

  1. Graphic program
  2. None of these
  3. Word processor
  4. A spreadsheet
  

Question 296 :
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. Qlicking the enter button to the formula bar
  

Question 297 :
Which Is an example of a formula?

  1. =A1+A2
  2. =add(AI:A2)
  3. A1+A2
  4. SUM{A1:A2)
  

Question 298 :
Excel worksheet cells work very similarly to what common element of the windows graphical user interface

  1. Option buttons
  2. List boxes
  3. Text boxes
  4. Combo boxes
  

Question 299 :
A ______is a grid with labeled columns and rows.

  1. Dialog box
  2. Worksheet
  3. Clipboard
  4. Toolbar
  

Question 300 :
Which of the following is not a worksheet design criterion?

  1. Efficiency
  2. Aditibility
  3. Description
  4. Clarity
  
Pages