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 361 :
Except for the .......function, a formula with a logical function shows the word TRUE or FALSE as a result

  1. IF
  2. AND
  3. OR
  4. NOT
  

Question 362 :
Comments can be added to cells using.....

  1. Edlt-> Comments
  2. Insert ?> Comment
  3. Fl I e-> Qomments
  4. Vlew-> Comments
  

Question 363 :
Using the Fl 1 shortcut key to create a chart on chart sheet creates

  1. A default chart
  2. A 2-dimensional column chart
  3. A 2-dimensional bar chart
  4. A 3-dimensional line chart
  

Question 364 :
A circular reference is

  1. Geometric modeling tool
  2. A cell that points to a drawing object
  3. A formula that either directly or indirectly depends on itself
  4. Always erroneous
  

Question 365 :
Microsoft Excel Is a powerful...........

  1. Word processing package
  2. Spreadsheet package
  3. Communication S/W Package ,
  4. DBMS package
  

Question 366 :
On an excel sheet the active cell In Indicated by...

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

Question 367 :
A worksheet range is a

  1. A command used for data modeling
  2. A range of values such as from 23 to 234
  3. A group of cells
  4. A group of worksheets
  

Question 368 :
This type of software is similar to an accountant's worksheet

  1. Word processing
  2. Database
  3. Spreadsheets
  4. Graphics
  

Question 369 :
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 370 :
You can select a single range of cells by

  1. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
  2. Pressing the Ctrl key while dragging over the desired cells
  3. Pressing the Shift key and an arrow key
  4. Dragging over the desired cells Correct
  

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

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

Question 372 :
Which of the following is not a valid Zoom

  1. 10
  2. 100
  3. 300
  4. 500
  

Question 373 :
It is acceptable to let long text flow into adjacent cells on a worksheet when

  1. data will be entered in the adjecent cells
  2. no data will be entered in the adjacent cells
  3. there is no suitable abbrevition for the text
  4. there is not time to format the text
  

Question 374 :
To view a cell comment

  1. click the edit comment command on the insert menu
  2. click the display comment command on the window menu
  3. position the mouse pointer over the cell
  4. click the comment command on the view menu
  

Question 375 :
If you need a text to show vertically In a cell. How will you achieve this?

  1. Choose Vertical on Text alignment In Format Cells dialog box
  2. Choose 90 Degrees in Orientation of Format Cells dialog box
  3. Choose Distributed from the Vertical drop down list of Format Cells dialog box
  4. 'Choose Center Across Selection from Horizontal combo box In Format Cells dialog box
  

Question 376 :
What is the keyboard shortcut {button or buttons to be pressed) for creating a chart from the selected cells?

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

Question 377 :
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

  1. Scenario Summary report
  2. Goal Seek
  3. Forecasting
  4. Trend line
  

Question 378 :
How do you display current date only in MS Excel?

  1. date ( )
  2. Today ( )
  3. now( )
  4. time()
  

Question 379 :
The Delete key of keyboard is assigned to which command in Excel?

  1. Edit ? Clear? Contents
  2. Edit? Clear? All
  3. Edit? Delete
  4. All of above
  

Question 380 :
When a range is selected, how can you activate the previous cell?

  1. Press the Alt key
  2. Press Tab
  3. Press Enter
  4. All of above
  

Question 381 :
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 382 :
Which of the following is not a worksheet design criterion?

  1. Efficiency
  2. Auditabiiity
  3. Description
  4. Clarity
  

Question 383 :
You can activate a cell by

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of the above
  

Question 384 :
When a label is too long to fit within a worksheet cell, you typically must

  1. Shorten the label
  2. Increase the column width
  3. Decrease the column width
  4. Adjust the row height
  

Question 385 :
The Chart wizard term data categories refers to;

  1. A chart plot area
  2. A horizontal axis
  3. The organization of individual values with a chart's data series
  4. The data range that supply chart data
  

Question 386 :
Which of the following is not a valid data type in Excel?

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

Question 387 :
The cell reference fro a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

  1. DB1-G10
  2. B1.G10
  3. B1;G10
  4. B1:G10
  

Question 388 :
The autofill feature

  1. Extends a sequential series of data
  2. Automatically adds a range of cell values
  3. Applies a boarder around selected cells
  4. All of above
  

Question 389 :
When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as

  1. AutoFill
  2. AutoCorrect
  3. AutoComplete
  4. AutoFormat
  

Question 390 :
Where a row and a column meet, what do you call that?

  1. A eel I
  2. A block
  3. A box
  4. None of the above
  
Pages