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 241 :
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 242 :
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 243 :
When you are typing an equation into a cell the first thing that must be entered is

  1. the first cell referenced
  2. parenthesis
  3. quotation marks
  4. an equal sign
  

Question 244 :
Excel files have a default extension of

  1. Xls
  2. Xlw
  3. Wkl
  4. 123
  

Question 245 :
Which function Is used to calculate depreciation, rates of return, future values and loan payment amounts?

  1. Logical
  2. Math - Trigonometry
  3. Statistical
  4. Financial
  

Question 246 :
To open the Format Cells dialog box, press

  1. Alt* 1
  2. Ctrl + 1
  3. Ctrl + Shift + 1
  4. Fl
  

Question 247 :
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

  1. Square
  2. Percentage
  3. Goal Seek
  4. Divide
  

Question 248 :
Hyperlinks cannot be

  1. Special shapes like stars and banners
  2. Drawing objects like rectangles ovals
  3. Pictures
  4. All can be hyperlinks
  

Question 249 :
You can open the scenario Manager dialog box by choosing scenarios from the ..... menu.

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

Question 250 :
What do we call a computer pro gram that orga-nizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

  1. Spreadsheet program
  2. Database program
  3. Word processor program
  4. Desktop publisher program
  

Question 251 :
Which of the following is not an option in the spelling dialog box?

  1. Edit
  2. Ignore
  3. Ignore all
  4. Change
  

Question 252 :
A typical worksheet has .... Number of columns

  1. 128
  2. 256
  3. 512
  4. 1024
  

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

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

Question 254 :
What Is the symbol for dividing?

  1. /
  2. =%
  3. -
  4. fl
  

Question 255 :
What do you mean by a Workspace?

  1. Group of Col umns
  2. Group of Worksheets
  3. Group of Rows
  4. Group of Workbooks
  

Question 256 :
Which function calculates your monthly mortage payment?

  1. PMT (payments)
  2. NPER (number of periods)
  3. PV (present value)
  4. All of above
  

Question 257 :
Be default, Excel positions text in a cell ___.

  1. left-aligned
  2. right-aligned
  3. centered
  4. justified
  

Question 258 :
You can use the drag and drop method to

  1. Copy cell contents
  2. Move cell contents
  3. Add cell contents
  4. a and b
  

Question 259 :
Which symbol must ail formula begin with?

  1. =
  2. +
  3. (
  4. e
  

Question 260 :
Which of the following types of tables constraints will prevent the entry of duplicate rows?

  1. Primary key
  2. Unique
  3. Null
  4. Foreign key
  

Question 261 :
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. 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 262 :
Tab scrolling buttons

  1. Allow you.to view a different worksheet
  2. Allow you to view additional worksheet row down
  3. Allow you to view additional worksheet columns to the right
  4. Allow you to view additional sheet tabs
  

Question 263 :
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

  1. Re-format the spreadsheet
  2. Insert a row
  3. Increase the column width
  4. Use the spacebar
  

Question 264 :
By default the cell pointer moves down when you press Enter. From where can you change this setting?

  1. Tools > > Options ? View tab
  2. Tools ? Options ? Calculation tab
  3. Tools ? Options ? Edit tab
  4. Tools ? Options ? Transition tab
  

Question 265 :
Where can you change automatic or manual calculation mode in Excel?

  1. Double CAL indicator on status bar
  2. Go to Tools > > Options > > Calculation and mark the corresponding radio button
  3. Both of above
  4. Press F7
  

Question 266 :
Text formulas:

  1. Replace cell references
  2. Return ASCII values of characters
  3. Concatenate and manipulate text
  4. Show formula error value
  

Question 267 :
Special category of Number tab in Format Cells dialog box can be used to apply formats like

  1. Zip Code
  2. Phone Number
  3. Both of above
  4. None of above
  

Question 268 :
Status indicators are located on the

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

Question 269 :
To insert three columns between columns D and E you would

  1. Select column D
  2. Select column E
  3. Select columns E, F and G
  4. Select columns D, E, and F
  

Question 270 :
To return the remainder after a number Is divided by a divisor In EXCEL we use the function?

  1. ROUND ( )
  2. FACTQ
  3. MODQ
  4. DIV()
  
Pages