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




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

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

Question 122 :
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 123 :
You can open the consolidate dialog box byt choosing Consolidate from the..... menu.

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

Question 124 :
Which of the following is not What IF analysis tool in Excel?

  1. Goal Seek
  2. Scenarios
  3. Macros
  4. All of above
  

Question 125 :
Can you set 0,5 Inch left Indentation for a cell in Excel?

  1. Excel does not have 1 ^Indentation feature
  2. You can specify Indentation only If you turn the rulers on
  3. Indentation can be set from Format Cells dialog box
  4. The Indentation can be specified only when printing
  

Question 126 :
You can create only a horizontal page break by first selecting

  1. A row below the row where you want the page break to occure
  2. A cell in row 1
  3. A cell in column A
  4. a and c
  

Question 127 :
Which of the following methods can not be used to edit the contents of a cell?

  1. Press the Alt key
  2. Clicking the formula bar
  3. Pressing the F2 key
  4. Double clicking the cell
  

Question 128 :
Which of the following is not a term of MS-Excel?

  1. Cells
  2. Rows
  3. Columns
  4. Document
  

Question 129 :
The cell labeled 23. 54 the cell labeled F5 refers to

  1. row F column 5
  2. column F row 5
  3. function available in cells
  4. function key F4
  

Question 130 :
Which of the following methods cannot be used to edit the content of cell?

  1. Pressing the Alt key
  2. Clicking the formula bar
  3. Pressing F2
  4. Double clicking the cell
  

Question 131 :
The cell reference for a range of cells that starts in cell Bl and goes over to column G and down to row 10 is ....

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

Question 132 :
Documentation should include

  1. Destination and users of the output data
  2. Source of input data
  3. Information on the purpose of the workbook
  4. All the above
  

Question 133 :
Which of the following is not an example of a value?

  1. 350
  2. May 10,2001
  3. 57%
  4. Serial Number 50771
  

Question 134 :
MS-EXCEL can be used to automate

  1. Financial statements. Business forecasting
  2. Transaction registers, inventory control
  3. Accounts receivable, accounts payable
  4. Any of the above
  

Question 135 :
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 the above
  

Question 136 :
Which of the following is not true about Find and Replace in Excel

  1. You can search for bold and replace with italics
  2. You can decide whether to look for the whole word or not
  3. You can search in formula too
  4. You can search by rows or columns or sheets
  

Question 137 :
How do you wrap the text in a cell?

  1. Format, cells, font
  2. Format, cells, protection
  3. format, cells, number
  4. Format cells, alignment
  

Question 138 :
Which of the following is a correct 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 these
  

Question 139 :
The box on the chart that contains the name of each Individual record Is called the__.

  1. cell
  2. title
  3. axis
  4. legend
  

Question 140 :
What are the tabs that appear at the bottom of each workbook called?

  1. Reference tabs
  2. Position tabs
  3. Location tabs
  4. Sheet tabs
  

Question 141 :
What Is the short cut key to highlight the entire column?

  1. Ctrl+C
  2. Ctrl+Enter
  3. Ctrl+PageUp
  4. Ctrl+SpaceBar
  

Question 142 :
which of the following special function keys allow the content in cell

  1. esc
  2. shift
  3. return
  4. Tab
  

Question 143 :
When you want to insert a blank imbedded excel object in a word document you can

  1. Click the object command on the insert menu
  2. Click the office links button on the standard toolbar
  3. Click the create worksheet button on the formatting toolbar
  4. Click the import excel command on the file menu
  

Question 144 :
Graphics objects on a chart are used to

  1. Add emphasis to chart data
  2. Add interest to a chart
  3. Help explain the chart data
  4. a, b, and c
  

Question 145 :
The advantage of using a spreadsheet is :

  1. calculations can be done automatically
  2. changing data automatically updates calculations
  3. more flexibility
  4. all of the above
  

Question 146 :
To apply Goal Seek command your cell pointer must be in

  1. The Changing cell whose value you need to find
  2. The Result Cell where formula is entered
  3. The cell where your targeted value is entered
  4. All of above
  

Question 147 :
Which of the following options i not available to remove arrows of Formula Auditing?

  1. Remove all preceden arrows
  2. Remove all dependent arrows
  3. Remove all arrows
  4. Remove all arrows for this cell
  

Question 148 :
Excel displays the current cell address In the..........

  1. Formula bar
  2. Status Bar
  3. Name Box
  4. Title Bar
  

Question 149 :
Which of the following setup options can not be set in the page setup dialog box?

  1. Printer selection
  2. Vertical or horizontal placement
  3. Orientation
  4. Row and column titles
  

Question 150 :
When the formula bar is activated, you can see

  1. The Edit Formula button
  2. The Cancel button
  3. The Enter button
  4. All of above
  
Pages