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 331 :
Bookl is an example of how ?... are numbered and named during each work session

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

Question 332 :
While Finding and Replacing some data in Excel, which of the following statement is valid?

  1. You can Find and Replace within the sheet or workbook
  2. Excel does not have option to match case for find
  3. Excel cannot replace
  4. None are valid
  

Question 333 :
You want to set such that when you type Baishakh and drag the fill .handle. Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

  1. Fill Across Worksheet
  2. Custom List
  3. Auto Fill Options
  4. Fill Series
  

Question 334 :
You can use the format painter multiple times before you turn it off by

  1. You can use the format painter button on ly 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 the Alt key and clicking the format painter button
  

Question 335 :
Which of the following series type is not valid for Fill Series dialog box?

  1. Linear
  2. Growth
  3. Autofill
  4. Time
  

Question 336 :
You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?

  1. New
  2. Save As
  3. Edit
  4. Save
  

Question 337 :
You can not link excel worksheet data to a word document

  1. With the right drag method
  2. With a hyperlink
  3. With the copy and paste special commands
  4. With the copy and paste buttons on the standard toolbar.
  

Question 338 :
What happens if you remove the check mark from Row - Column headers on Options dialog box?

  1. This will remove row headings and column headings of your data
  2. This will remove the column headings (A, B, C,
  3. This will remove row and column heading of chart
  4. This will remove row and column heading of table
  

Question 339 :
To copy formatting from one area in a worksheet and apply it to another area you would use :

  1. The Edit > Copy Format and Edit>Paste Format commands form the menu.
  2. The Copy and Apply Formatting dialog box, located under the Formats Copy and Apply menu.
  3. There is no way to copy and apply formatting in Excel You have to do it manually
  4. The Format Painter button on the standard toolbar
  

Question 340 :
You can use the formula pallette to

  1. format cells containing numbers
  2. create and edit formula containing functions
  3. enter assumptions data
  4. copy a range of cells
  

Question 341 :
Files created with Lotus 1-2-3 have an extension

  1. DOC
  2. XLS
  3. 123
  4. WK1
  

Question 342 :
Which of the cell pointer indicates that you can fill series?

  1. Doctor's symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. All of above
  

Question 343 :
Which is used to perform what if analysis?

  1. Solver
  2. Goal seek
  3. Scenario Manager
  4. Allof above
  

Question 344 :
Which of the following is invalid statement?

  1. Sheet tabs can be colored
  2. Some picture can be applied as a background of a sheet
  3. You can set the column width automatically fit the amount of text
  4. The width of a row and be specified manually or fit automatically
  

Question 345 :
How are data organised in a spreadsheet?

  1. Lines and spaces
  2. Layers and planes
  3. . Height and width
  4. Rows and columns
  

Question 346 :
Except for the ...... function, a formula with a logical function shows the word TRUE or FALSE as a result

  1. IF
  2. AND
  3. OR
  4. NOT
  

Question 347 :
An excel workbook is a collection of

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

Question 348 :
Long text can be broken down into many lines within a cell. You can do this through We have 83

  1. Wrap Text in Format > > Cells guests online
  2. Justify in Edit > > Cells
  3. Text Wraping in Format ? Cells, Layout tab
  4. All of above
  

Question 349 :
How should you print a selected area of a worksheet, if you'll want to print a different area next time?

  1. On the file menu, point to print area, and then click set print area.
  2. On the file menu, click print, and then click selection under print what
  3. On the view menu, click custom views, then click add
  4. All of above
  

Question 350 :
Got functions? No? You need the insert function dialog box. How do you get it?

  1. Right click a cell and then click insert
  2. Click the insert menu and then click function
  3. Type - in a cell
  4. All of the above
  

Question 351 :
How do you change column width to fit the contents?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above
  

Question 352 :
A numeric value can be treated as label value If...... precedes It.

  1. Apostrophe (')
  2. Exclamation (I)
  3. Hash (#)
  4. Tilde(~)
  

Question 353 :
Which of the following Excel screen components can NOT be turned on or off ?

  1. Formula Bar
  2. Status Bar
  3. Tool Bar
  4. None of these
  

Question 354 :
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

  1. Use Ctr! to select all three cells, then click the paste button on the standard toolbar
  2. Copy the selected cell, then elect the other two cells, click style on the Format menu, then click Modify
  3. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
  4. All of above
  

Question 355 :
Which of the following will not set text in selected cells to italics?

  1. Pressing Ctrl + I on the keyboard
  2. Using the Tools - Wizard -Web Form menu item
  3. Using the Format - Cells -Font menu item
  4. All of the above
  

Question 356 :
You can use the formula palette to

  1. Format cells containing numbers
  2. Create and edit formulas containing functions
  3. Enter assumptions data
  4. Copy a range of cells
  

Question 357 :
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

  1. Press the Erase key
  2. Press Esc
  3. Press the Enter button
  4. Press the Edit Formula button
  

Question 358 :
Which of the following is not information you can specify using the solver?

  1. Input cells
  2. Constraints
  3. Target cell
  4. Changing cells
  

Question 359 :
You can merge the main document with data source in Excel. In mail merge operation, Word is usually

  1. server
  2. source
  3. client
  4. none
  

Question 360 :
How should you print a selected area of a worksheet, if you'll want to print a different area next time?

  1. On the file menu, point to print area, and then click set print are
  2. On the file menu, click print, j and then click selection | under print what
  3. On the view menu, click custom views, then click add
  4. All of above
  
Pages