Microsoft Excel (Basic-Advance Knowledge|Govt Exams/Competitive exam) MCQ's




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

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

Question 62 :
Which Chart can be created in Excel?

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

Question 63 :
You can use drag-and-drop to embed excel worksheet data in a word document

  1. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
  2. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
  3. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
  4. None of above
  

Question 64 :
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 65 :
Using the AutoSum button will replace in the selected cell......

  1. the sum of values jn the cell's column.
  2. . nothing until'ybu select a range of cells
  3. the sum of the cell's row unless you change the range
  4. None of these
  

Question 66 :
When you copy a formula

  1. Excel erases the original copy of the formula
  2. Excel edits cell references in the newly copied formula
  3. Excel adjusts absolute cell references
  4. Excel doesn't adjust relative cell references
  

Question 67 :
You can create hyperlinks from the Excel workbook to

  1. A webpage on company internet
  2. A web page on the internet
  3. Other Office 97 application documents
  4. All
  

Question 68 :
Which language is used to create macros in Excel?

  1. Visual Basic 4
  2. C
  3. Visual C++
  4. Java
  

Question 69 :
When integrating word and excel, word is usually the

  1. Server
  2. Destination
  3. Client
  4. Both b and c
  

Question 70 :
To drag a selected range of data to another worksheet in the same workbook, use the

  1. Tab key
  2. Alt key
  3. Shift key
  4. Ctrl key
  

Question 71 :
The Trace Dependence in auditing shows

  1. Which cells are used in current formula
  2. In which formula the current cell is used
  3. Which cells are used in this formula and in which formula this cell is used
  4. All of above
  

Question 72 :
To activate the previous cell in a pre-selected range press

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

Question 73 :
What is represented by the small, black square in the lower-right corner of an active cell or range?

  1. Copy handle
  2. Fill handle
  3. Insert handle
  4. Border
  

Question 74 :
How do you delete a column?

  1. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
  2. Select the column heading you want to delete and select Insert Delete from the menu
  3. Select the row heading you want to delete and select Edit>Delete from the menu
  4. Right click the column heading you want to delet and select delete from .the shortcut menu
  

Question 75 :
To delete an incorrect character in a document, __ to erase to the right of the insertion point.

  1. press the left mouse key
  2. double click the right mouse key
  3. press the BACKSPACE key
  4. press DELETE key
  

Question 76 :
Comments put in cells are called.....

  1. Smart Tip
  2. Cell Tip
  3. Web Tip
  4. Soft Tip
  

Question 77 :
Which of the following is a cor-rect order of precedence in a formula calculation?

  1. Multiplication and division, exponential positive and negative value
  2. Multiplication and division, positive and negative values, addition and subtraction
  3. Addition and subtraction, positive and negative values, exponentiation
  4. None of above
  

Question 78 :
You can insert labels for

  1. All the data markers on a chart
  2. A data series
  3. A selected data marker
  4. All
  

Question 79 :
When the formula bar is active, you can see

  1. The edit formula button
  2. The cancel button
  3. The enter button
  4. All of the above
  

Question 80 :
Excel is a good application for What IF analysis. Which of the following tool help you for this?

  1. Formul Auditing
  2. Research
  3. Track Change
  4. Goal Seek
  

Question 81 :
Which button do you click to add up a series of numbers?

  1. The autosum button
  2. The Formula button
  3. The quicktotal button
  4. The total button
  

Question 82 :
To edit data in an embedded Excel worksheet object in a Word document

  1. Use the Excel menu bar and toolbars insjde 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 83 :
You can use the format painter , multiple times before you turn it offby

  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 Alt key and clicking the format painter button
  

Question 84 :
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 85 :
The command Edit ?Fill Across Worksheet is active only when

  1. One sheet is selected
  2. When many sheets are selected
  3. When no sheet is selected
  4. All of above
  

Question 86 :
You accidentally erased a record In the sheet, What command can be used to restore It Immediately?

  1. Insert
  2. Copy
  3. Undo
  4. Replace
  

Question 87 :
What is the short cut key to replace a data with another in sheet?

  1. Ctrl + R
  2. Ctrl + Shift + R
  3. Ctrl + H
  4. Ctrl + F
  

Question 88 :
All macro keyboard shortcuts include the...... key

  1. Alt
  2. Ctrl
  3. F11
  4. Shift
  

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

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

Question 90 :
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
  
Pages