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 391 :
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

  1. XY Chart
  2. Line Chart
  3. Pie Chart
  4. Column Chart
  

Question 392 :
Youar German supplier still invoices 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 393 :
The Paste Special command lets you copy and paste:

  1. Multiply the selection by a copied value
  2. Cell comments
  3. Formatting options
  4. The resulting values of a formula instead of the actual formula
  

Question 394 :
Which of the following option is not available in Paste Speciat dialog box?

  1. Add
  2. Subtract
  3. Divide
  4. SORT
  

Question 395 :
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

  1. Rows and columns
  2. Headings
  3. Speed
  4. All of above
  

Question 396 :
An excel workbook is a collection of

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

Question 397 :
Which tool you will use to join some cells and place the content at the middle of joined cell?

  1. From Format Cells dialog box click on Merge Cells check box
  2. From Format Cells dialog box select the Centered alignment
  3. -From Format Cells dialog box choose Merge and Center check box
  4. Click on Merge and Center tool on formatting toolbar
  

Question 398 :
What Is entered by the function ?today ()

  1. The date value for the day according to system clock
  2. The time value according to system clock
  3. Today's date as Text format
  4. none of above
  

Question 399 :
Which key do you press to check spelling?

  1. F3
  2. F5
  3. F7
  4. F9
  

Question 400 :
Which of the following is a popular DOS based spreadsheet package?

  1. Word
  2. Smart cell
  3. Excel
  4. Lotus 1-2-3
  

Question 401 :
You can move a sheet from one workbook into new book by

  1. From Edit menu choose Move or Copy sheet mark the Create a copy and Click OK
  2. From Edit menu choose Move of Copy then choose {Move to end) and click OK
  3. From Edit menu choose Move or Copy then select {new book) from To Book list and click OK
  4. All of above
  

Question 402 :
A data map is helpful

  1. When you have too much data to chart
  2. To show a geographic distribution of data
  3. To compare data points
  4. To show changes in data over time
  

Question 403 :
Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?

  1. Press Ctrl +Home
  2. Press Home
  3. Press Shift + Home
  4. Press Alt + Home
  

Question 404 :
Qtr 1, Qtr 2, Qtr 3 is an example of a

  1. Formula
  2. Function
  3. Series
  4. Syntax
  

Question 405 :
In a worksheet you can select

  1. The entire worksheet
  2. Rows
  3. Columns
  4. All of the above
  

Question 406 :
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

  1. AutoFill
  2. Auto correct
  3. Auto sum
  4. Auto format
  

Question 407 :
What is the AutoSummarize feature used for in Word 2000

  1. It creates a 250 word, 500 word or 1000 word summary of the document
  2. It adds Automatic headwers, bold and italic characters as well as' automatic formatting of the document to give the look of a well summarized document
  3. it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs
  4. It identifies the key points in a document for your to share with others or quickly scan
  

Question 408 :
You can edit a cell by

  1. Clicking the formula button
  2. Double clicking the cell to edit it in-place
  3. Selecting Edit > Edit Cell from the menu
  4. None of above
  

Question 409 :
Which of the following is not a valid data type in excel

  1. Number
  2. Character
  3. Label
  4. Date/time
  

Question 410 :
The spelling tool Is placed on _toolbar

  1. Standard
  2. Formatting
  3. Drawing
  4. Reviewing
  

Question 411 :
The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the corurol field change.

  1. ADD
  2. SUM
  3. TOTAL
  4. LIST
  

Question 412 :
Which of the following is not a way to complete a cell entry?

  1. Pressing enter
  2. Pressing any arrow key on the keyboard
  3. Clicking the Enter button on the Formula bar
  4. Pressing spacebar
  

Question 413 :
To add two cells (Al and A(2) together you use the following formula

  1. =A1 + A2
  2. =Add(AI+A(2)
  3. together (A 1:A(2)
  4. AlplusA2
  

Question 414 :
Which of the following formulas will Excel Not be able to calculate?

  1. =SUM(Sales)-A3
  2. =SUM(A1:A5)*.5
  3. =SUM(A1:A5)/(10-10)
  4. =SUM(A1:A5)-10
  

Question 415 :
You can enter which types of data into worksheet cells?

  1. Labels, values, and formulas
  2. Labe31s and values but not formulas
  3. Values and formulas but not labels
  4. Formulas only
  

Question 416 :
The first cell in EXCEL worksheet is labeled as

  1. A
  2. A1
  3. Aa
  4. AO
  

Question 417 :
The divide symbol is

  1. /
  2. D
  3. )
  

Question 418 :
To hold row and column titles in places 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 419 :
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

  1. From Edit menu choose Clear and then Formats
  2. From Edit menu choose Delete
  3. Click on Remove Formatting tool on Standard Toolbar
  4. Double click the Format Painter and then press Esc key in keyboard
  

Question 420 :
The intersection of a row and column is called :

  1. data
  2. afield
  3. a cell
  4. an equation
  
Pages