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 211 :
When you insert an Excel file into a Word document, the data are

  1. Hyperlinked
  2. Placed in a word table
  3. Linked
  4. Embedded
  

Question 212 :
Rounding errors can occur

  1. When you use multiplication, division, or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places that the calculated results
  

Question 213 :
The default and maxium number of sheets for a new workbook in Excel 2003 is

  1. 3 and 255
  2. 3 and 256
  3. 1 and 255
  4. 1 and 256
  

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

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

Question 215 :
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 216 :
B7:B9 indicates:

  1. Cells B7 and cell B9 only.
  2. Cells B7 through B9.
  3. Cell BSonly.
  4. None of the a bove.
  

Question 217 :
Pounding errors can occur

  1. When you use multiplication, division, or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places that the calculated results
  

Question 218 :
Comments can be added to cells using

  1. Edit > Comments
  2. Insert > Comments
  3. File > Comments
  4. View > Comments
  

Question 219 :
To make a number In cell Cl 10% smaller than the number In C3 you enter

  1. -03*1.10
  2. +C3*110
  3. -C3%10
  4. -C3*.90
  

Question 220 :
You can edit existing Excel data by pressing the

  1. Flkey
  2. F2key
  3. F3key
  4. F4key
  

Question 221 :
When you print preview a worksheet

  1. the entire worksheet is displayed
  2. the selected range is displayed
  3. the active portion of the worksheet is displayed
  4. a, b and c
  

Question 222 :
What symbol is used before a number to make it a label?

  1. (quote)
  2. = (equal)
  3. _ (underscore)
  4. * (apostrophe)
  

Question 223 :
Which of the cell pointer indicate that you can move the content to other cell?

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

Question 224 :
Which of the following is an absolute cell reference?

  1. !A!1
  2. SA$1
  3. #a#l
  4. Al
  

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

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

Question 226 :
The spelling dialog box can be involved by choosing spelling from ___ menu.

  1. insert
  2. file
  3. tools
  4. view
  

Question 227 :
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 228 :
When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

  1. Auto Complete
  2. AutoFormat
  3. Custom List
  4. Calculation Automatic
  

Question 229 :
When a row of data is to be converted into columns

  1. Copy the cells in row, select the same number of cells in row and paste
  2. Copy the cells in column then choose Edit > > Paste Special, then click Transpose and OK
  3. Copy the cells then go to Format > > Cells then on Alignment tab click Transpose check box and click OK
  4. Select the cells then place the cell pointer on new cell and choose Edit ? Paste Special, mark Transpose check box and click OK.
  

Question 230 :
Which of the following you can paste selectively using Paste Special command?

  1. Validation
  2. Formats
  3. Formulas
  4. All of above
  

Question 231 :
Which setting you must modify to print a worksheet using letterhead?

  1. Paper
  2. Margin
  3. Layout
  4. Orientation
  

Question 232 :
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify ac: curacy. How do you activate this feature?

  1. Point to speech on the tools menu, and then click show text to speech toolbar.
  2. Click validation on the data menu
  3. Point to speech on the tools menu, and then click speech recognition
  4. All of above
  

Question 233 :
Charts tips can

  1. Show the formatting of a data label
  2. Show the name of a data series
  3. Show the value of data point
  4. b and c
  

Question 234 :
How do you insert a row?

  1. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
  2. Select the row heading where you want to insert the new row and select Edit > Row from the menu
  3. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
  4. All of the above
  

Question 235 :
Which area In an Excel window allows entering values and formulas?

  1. Title Bar
  2. Menu Bar
  3. Formula Bar
  4. Standard Tool Bar
  

Question 236 :
Right clicking something in Excel:

  1. Deletes the object
  2. Nothing the right mouse button is there for left handed people
  3. Opens a shortcut menu listing everything you can do to the object
  4. Selects object
  

Question 237 :
What does COUNTA ( ) function do?

  1. counts cells having alphabets
  2. counts empty eel Is
  3. counts cells having number
  4. counts non-empty cells
  

Question 238 :
Which of the following action removes a sheet from workbook?

  1. Select the sheet, then choose Edit > > Delete Sheet
  2. Select the sheet then choose Format ? Sheet ? Hide
  3. Press Insert
  4. All of above
  

Question 239 :
The default font size in Excel worksheet is

  1. 10 points
  2. 12 points
  3. 14 points
  4. None of above .
  

Question 240 :
You can quickly change the appearance of your work by choosing Auto Format from the .... Menu

  1. Edit
  2. View
  3. Format
  4. Tools
  
Pages