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 91 :
Which is an example of a function?

  1. =add(AI:A2)
  2. =A1+A2
  3. ?SUM(A1:A2)
  4. A1+A2
  

Question 92 :
What does the VLOOKUP function do?

  1. Looks up text that contain V
  2. Checks whether text is the same in one cell as in the next
  3. Finds related records
  4. All of above
  

Question 93 :
To record a sequence of keystrokes and mouse actions to play back later we use:

  1. Media player
  2. Sound Recorder
  3. Calculator
  4. Macro Recorder
  

Question 94 :
To select an entire column in MS-EXCEL, press?

  1. CTRL + C
  2. CTRL + Arrow key
  3. CTRL + S
  4. All of the above
  

Question 95 :
How do you select an entire column?

  1. Select Edit > Select > Column from the menu
  2. Click the column heading letter
  3. Hold down the shift key as you click anywhere in the column,
  4. Hold down the Ctrl key as you click anywhere in the column
  

Question 96 :
when working in the page break preview, you can

  1. view exactly where each page break occurs
  2. add or remove page breaks
  3. change the print area
  4. all of above
  

Question 97 :
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

  1. Right click on Sheet Tab of third sheet and choose Delete from the context menu
  2. Click on Sheet 3 and from Edit menu choose Delete
  3. Click on Sheet 3 and from Edit menu choose Insert
  4. None of above
  

Question 98 :
Concatenation of text can be done using

  1. Apostrophe (')
  2. Exclamation (I)
  3. Hash(#)
  4. Ampersand (-)
  

Question 99 :
Hounding errors can occur

  1. When you use multiplication, division or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because Excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places' than the calculated results
  

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

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

Question 101 :
What la the symbol for multiplying?

  1. >
  2. /
  3. !
  4. *
  

Question 102 :
The active cell:

  1. is defined by a bold border around the ceil.
  2. Receives the data the user enters.
  3. It is the formula bar.
  4. Only A and B
  

Question 103 :
Status indicators are located on the

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

Question 104 :
You can not link excel worksheet data to a word document

  1. With the right drag method
  2. With a hyperlink
  3. With the copy and paste special commands
  4. With the copy and paste buttons on the standard toolbar.
  

Question 105 :
If you want all of the white cats grouped together In the database, you need to sort by__.

  1. Color, then Gender
  2. Pet Type, then Col or
  3. Pet Type, then Gender
  4. Color, then Pet Name
  

Question 106 :
Which function calculates your monthly mortage payment?

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

Question 107 :
What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

  1. 5,430.00
  2. 5,436.80.
  3. 5,436.8
  4. 6.8
  

Question 108 :
To select a column the easiest method is to........

  1. Double click any cell in the column
  2. Drag from the top cell in the column to the last cell in the column
  3. click the column heading
  4. click the column label
  

Question 109 :
You can open the consolidate dialog box byt choosing Consolidate from the..... menu.

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

Question 110 :
NOT, AND, OR and XOR are

  1. Logical Operators
  2. Arithmetic operators
  3. Relational operators
  4. None of the above
  

Question 111 :
You can automatically adjust the ! size of text in a cell if they do not fit in width by

  1. Double clicking on the right border of column header
  2. From Format choose Columns and then Autofit Selection
  3. From Format Cells dialog box mark Shrink to fit check box
  4. All of above
  

Question 112 :
To select several cells or ranges that are not touching each other, you would ... while selecting

  1. hold down the Ctrl key
  2. hold down the Shift key
  3. hold down the Alt key
  4. hold down Ctrl + Shin key
  

Question 113 :
When you see a cell with a red triangle in the top right corner, what does this signify?

  1. There is an error in the cell .
  2. There is a comment associated with the cell
  3. The font color for text in the cell is red
  4. A formula cannot be entered into the cell
  

Question 114 :
what term describes a background that appears as a grainy, non smooth surface

  1. gradient
  2. pattern
  3. solid
  4. texture
  

Question 115 :
How many characters can be typed in a single cell in Excel?

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

Question 116 :
The multiplication arithmetic operator Is represented by which of the following symbols?

  1. a
  2. *
  3. /
  4. X
  

Question 117 :
When you link data maintained in Excel workbook to a Word document

  1. The Word document cannot be edited
  2. The Word document contains a reference to the original source application
  3. The word document must contain a hyperlink
  4. The word document contains a copy of the actual data
  

Question 118 :
Which is not an advantage of using computerized spread sheets?

  1. flexibility of moving entries
  2. speed of calculation
  3. ability of generate tables
  4. cost of initial setup
  

Question 119 :
You can use the format painter multiple times before you turn it off by

  1. You can use the format painter button only one time when you click it
  2. Double clicking the format painter button
  3. Pressing the Ctrl key and clicking the format painter button
  4. Pressing the Alt key and clicking the format painter button
  

Question 120 :
When you group worksheets

  1. You can enter variable data on multiple worksheets at one time
  2. You can print more than*one worksheet at a time
  3. You can enter common data, formats, and formulas on multiple worksheets at one time
  4. b, and c
  
Pages