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 301 :
Which elements of a worksheet can be protected from accidental modification?

  1. Contents
  2. Objects
  3. Scenarios
  4. All of the above
  

Question 302 :
To save a workbook, you:

  1. Click the save button on the standard toolbar from the menu
  2. Press Ctrl+F5
  3. Click Save on the Windows Start button
  4. Select Edit>Save
  

Question 303 :
Which of the following can not be hidden from Tools > > Options then View tab?

  1. Startup Task Pane
  2. Formula bar
  3. Status bar
  4. Scroll Bar
  

Question 304 :
The arrows created by Auditing can be removed by

  1. Click on the arrow and press Delete '
  2. Click on Remove All arrows on Formula Auditing toolbar
  3. Both of above
  4. Press insert
  

Question 305 :
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 306 :
Which of the following is invalid regarding the Protection in Excel?

  1. Protect Sheet
  2. Protect Workbook
  3. Protect Workspace
  4. All of above are valid
  

Question 307 :
How are data organized in a spreadsheet?

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

Question 308 :
Which function Is not available In the Consolidate dialog box?

  1. Pmt
  2. Average
  3. Max
  4. Sum
  

Question 309 :
The autofill feature

  1. extends a sequential series of data
  2. automatically adds range of cell values
  3. applies a boarder around the selected cells
  4. none of the above j
  

Question 310 :
To create a formula, you can use:

  1. Values but not cell references
  2. Cell references but not values
  3. Values or cell references although not both at the same time
  4. Value and cell references
  

Question 311 :
A function incite another function is called a .....function.

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

Question 312 :
How are data organized in a spreadsheet?

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

Question 313 :
The short cut key Ctrl +R is used in Excel to

  1. Right align the content of cell
  2. Remove the cell contents of selected cells
  3. Fill the selection with active t cells to the right
  4. All of above
  

Question 314 :
In order to perform a calculation in a spreadsheet, you need to use a:

  1. table
  2. formula
  3. field
  4. variable
  

Question 315 :
You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

  1. F9
  2. F5
  3. F8
  4. F11
  

Question 316 :
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

  1. Format Report
  2. Pivot Table
  3. ,'Refresh Data
  4. Show Detail
  

Question 317 :
Two common wildcard characters that Excel recognizes are

  1. * and?
  2. < and >
  3. * and /
  4. + and ?
  

Question 318 :
How can you show or hide the gridlines in Excel Worksheet?

  1. Go to Tools >> Options > > View tab and mark or remove the check box named Gridline
  2. Click Gridline tool on Forms toolbar
  3. Both of above
  4. Press F7
  

Question 319 :
The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

  1. Click the Currency Style button on the formatting toolbar
  2. You have to retype everything and manually add the dollar signs, commas, and decimals.
  3. Select Format > Money from the menu
  4. All the above
  

Question 320 :
When integrating Ms-Word and Excel, Word is usually the

  1. Server
  2. Source
  3. Client
  4. None
  

Question 321 :
The Name box on to the left of formula bar

  1. shows the name of workbook currently working on
  2. shows tne name of worksheet currently working on
  3. shows the name of cell or range currently working on
  4. All of above
  

Question 322 :
What Is the correct way to refer the cell AID on sheets from sheetl?

  1. sheet3IA10
  2. sheetllAlO
  3. Sheets-A10
  4. A10
  

Question 323 :
Which of the following is the latest version of Excel

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

Question 324 :
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply t

  1. Use -ifO function to format the required numbers red
  2. Apply Conditional Formatting command on Format menu
  3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  4. All of above
  

Question 325 :
You can add a hyperlink to your worksheet by pressing

  1. Alt + K
  2. Ctrl + H
  3. Ctrl + K
  4. Ctrl + Shift + K
  

Question 326 :
On an Excel sheet the active cell in indicated by

  1. A dark wide border
  2. A dotted border
  3. A blinking border
  4. None of above
  

Question 327 :
Where can you set the shedding color for a range of cells in Excel?

  1. Choose required color form Patterns tab of Format Cells dialog box
  2. Choose required color on Fill Color tool in Formatting toolbar
  3. Choose required color on Fill Color tool in Drawing toolbar
  4. All of above
  

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

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

Question 329 :
When you work with large worksheets, you may need to

  1. size the worksheet to fit on the specific number of pages
  2. add and remove page breaks
  3. specify only certain print areas
  4. all of above
  

Question 330 :
Which elements of worksheet can be protected from accidental modification

  1. Contents
  2. Objects
  3. Scenarios
  4. All of above
  
Pages