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 151 :
You can set Page Border in Excel from

  1. From Border tab in Format Cells dialog box
  2. From Border tool in Formatting toolbar
  3. From Line Style tool in Drawing toolbar
  4. You can not set page border in Excel
  

Question 152 :
You can check the conditions against ___ when applying conditional formatting

  1. Cell value
  2. Formula
  3. Both of above
  4. writing
  

Question 153 :
You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?

  1. - (ampersand)
  2. = (equal sign)
  3. (space)
  4. All of the above
  

Question 154 :
Which of the following formulas is not entered correctly?

  1. =10+50
  2. =B7*B1
  3. =B7+14
  4. 10+50
  

Question 155 :
What function cJtsplays row data in a column or column data in a row?

  1. Hypertink
  2. Index
  3. Transpose
  4. Rows
  

Question 156 :
Which function will you use to enter current time In a woksheet cell?

  1. .=today( )
  2. .-now ( )
  3. .-time ( )
  4. .=CurrentTime ( )
  

Question 157 :
You can use the horizontal and vertical scroll bars to

  1. Split a, worksheet into two panes
  2. View different rows and columns edit the contents of a cell
  3. Edit the contents of a cell
  4. view different worksheets
  

Question 158 :
You can convert existing excel worksheet data an charts to an HTML document by using

  1. Internet assistant wizard
  2. FTP wizard
  3. Intranet wizard
  4. Import wizard
  

Question 159 :
A worksheet can have a maximum of.... Number of rows

  1. 256
  2. 1024
  3. 32,000
  4. 65,535
  

Question 160 :
Youar German supplier still in-voices for parts in deutsche marks. How can you .have Excel convert those sums to Euros?

  1. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
  2. On the tools menu, click Add-lns, and select the Euro Currency Tools check box
  3. Apply a selected background color
  4. All of above
  

Question 161 :
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

  1. Workday
  2. Date
  3. Networkdays
  4. All of the above
  

Question 162 :
To edit in an embedded excel worksheet object in a word document

  1. Use the excel menu bar and toolbars inside the word application
  2. Edit the hyperlink
  3. Edit the data in a excel source application
  4. Use the word menu bar and toolbars
  

Question 163 :
Which Chart can be created in Excel?

  1. Area
  2. Line
  3. Pie
  4. All of the above
  

Question 164 :
When you insert an excel file into a word document. The data are

  1. Hyperlinked placed in a word table
  2. Linked
  3. Embedded
  4. Use the word menu bar and toolbars
  

Question 165 :
Tab scroll buttons are place on Excel screen

  1. towards the bottom right corner
  2. towards the bottom left corner
  3. towards the top right corner
  4. towards the top left corner
  

Question 166 :
In Excel, the Fill Color button on the Formatting toolbar is used for what?

  1. To insert a background.
  2. To add borders.
  3. To select a distribution of figures.
  4. To add shading or color to a cell range.
  

Question 167 :
You can zoom a worksheet

  1. With the mouse pointer in Print Preview
  2. With the zoom button on the Print Preview toolbar
  3. With the Zoom command on the view menu
  4. All of the above
  

Question 168 :
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence ofsgyents that will do this?

  1. Go to File-Save As - Save As Type - Excel worksheet
  2. Right click on the spreadsheet tab and setect DELETE
  3. Right click on the spreadsheet and select Insert ? Entire Column
  4. None of above
  

Question 169 :
A function inside another function is called a.....function.

  1. Nested
  2. Round
  3. Sum
  4. Text
  

Question 170 :
you can use the formula palette to

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

Question 171 :
lt is acceptable of let long text flow into adjacent cells on a worksheet when

  1. Data will be entered in the adjacent cells
  2. No data will be entered in the adjacent cells
  3. There is not suitable abbreviation of the text
  4. There is not time to format the next
  

Question 172 :
Which of the following will not cut information?

  1. Pressing Ctrl + C
  2. Selecting Edit >Cut from the menu
  3. Clicking the Cut button on the standard
  4. Pressing Ctrl + X
  

Question 173 :
To copy cell contents using drag and drop press the

  1. End key
  2. Shift key
  3. Ctrl key
  4. Esc key
  

Question 174 :
Which of the following is the oldest spreadsheet package?

  1. VisiCalc
  2. Lotus 1-2-3
  3. Excel
  4. StarCalc
  

Question 175 :
Macros are run or executed from the...... menu.

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

Question 176 :
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

  1. word processing
  2. spreadsheet
  3. database
  4. graphics
  

Question 177 :
You can group noncontiguous worksheets with

  1. The group button on the standard toolbar
  2. The shift key and the mouse
  3. The Ctrl key and mouse
  4. The alt+enter key
  

Question 178 :
Which menu option can be used to split windows Into two?

  1. Format ?> Widow
  2. VI ew ?> Widow=> Split
  3. Wlndow->Spllt
  4. Vlew->Spllt
  

Question 179 :
To edit in an embedded excel worksheet object in a word document

  1. Use the excel menu bar and toolbars inside the word application
  2. Edit the hyperlink
  3. Edit the data in a excel source application
  4. Use the word menu bar and toolbars
  

Question 180 :
To centre a paragraph using shortcut keys, press __.

  1. CTRL + C
  2. CTRL + E
  3. CTRL + L
  4. CTRL + R
  
Pages