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




Question 151 :
Gridlines

  1. May be turned off for display but turned on for printing
  2. May be turned on or off for printing
  3. The be turned off for display and printing
  4. a, b and c
  

Question 152 :
You can copy data or formulas

  1. With the copy, paste and cut commands on the edit menu
  2. With commands on ta shortcut menu
  3. With buttgns on the standard toolbars
  4. All of the above
  

Question 153 :
All formula In Excel start with

  1. .>
  2. +
  3. =
  4. -
  

Question 154 :
Formatting a cell In Currency, you can specify

  1. Decimal Places
  2. Currency Symbol
  3. Both of above
  4. None of above
  

Question 155 :
Which of the following is not a basic step in creating a worksheet?

  1. Save the workbook
  2. Modify the worksheet
  3. Enter text and data
  4. Copy the worksheet
  

Question 156 :
__ cells involves creating a single cell by combining two or more selected cells.

  1. Formatting
  2. Merging
  3. Embedding
  4. Splitting
  

Question 157 :
When creating a vertical page break

  1. The active cell must be Al
  2. The active cell can be anywhere in the worksheet
  3. The active cell must be in row 1
  4. The active cell must be in column A
  

Question 158 :
How can you delete a record?

  1. Delete the column from the worksheet
  2. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
  3. Select Data > Delete Record from the menu
  4. Click the Delete button on the Standard toolbar
  

Question 159 :
Which Is not tha function of Edit, Clear command?

  1. Delete contents
  2. Del ete notes
  3. Delete eel Is
  4. Del ete formats
  

Question 160 :
Which of following is Not one of Excel's what-if function?

  1. Goal seek
  2. Solver
  3. Scenario manager
  4. Auto Outline
  

Question 161 :
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

  1. HTML
  2. Pivot Table Field List
  3. Pivot Table List
  4. Pivot Table Report
  

Question 162 :
You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.

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

Question 163 :
To copy cell contents using drag and drop, press the

  1. End key
  2. Shift key
  3. Esc key
  4. None of these
  

Question 164 :
When you link data maintained in an excel workbook to a word document

  1. The word document can not be edit
  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 165 :
You can activate a cell by

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

Question 166 :
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 167 :
What term refers to a specific set of values saved with the workbook?

  1. Range
  2. 00000000
  3. Trend line
  4. What-if analysis
  

Question 168 :
Getting data from a cell located in a different sheet is called

  1. Accessing
  2. Referencing
  3. Updating
  4. Functioning
  

Question 169 :
Auto Calculate will quickly add selected cells if you.......

  1. right click on the status bar and select Sum
  2. click the AutoCalculate but-ton on the toolbar
  3. use the key combination Ctrl+$
  4. Double click the selection
  

Question 170 :
Which of the following format you can decide to apply or not In AutoFormat dialog box?

  1. Number format
  2. Border format
  3. Font format
  4. All of above
  

Question 171 :
When you use the fill effects in the format data series dialog box, you can not

  1. rotate text on the chart
  2. select a fore ground color
  3. select a pattern
  4. select a background color
  

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

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

Question 173 :
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from

  1. from Fromat ? Cells
  2. from Format > > Auto format
  3. from Table > > Auto format
  4. All of above
  

Question 174 :
Which types of charts can excel produce?

  1. Line graphs and pie charts only
  2. Only line graphs
  3. Bar charts, line graphs and pie charts
  4. Bar charts and line graphs only
  

Question 175 :
Which menu option can be used to split windows into two

  1. View > window > split
  2. Format > window
  3. Window > split
  4. View > split
  

Question 176 :
How do you display current date and time In MS Excel?

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

Question 177 :
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............

  1. ascending order
  2. descending order
  3. alphabetical order
  4. random order
  

Question 178 :
You can print only an embedded chart by

  1. Moving the chart to a chart sheet before you print.
  2. Formatting the chart before you print
  3. Selecting the chart before you print
  4. a and c
  

Question 179 :
To move to the previous worksheet, press

  1. Alt + PgUp
  2. Ctrl + PgUp
  3. Ctrl + PgDn
  4. Shift + Tab
  

Question 180 :
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

  1. Pie chart
  2. Row chart
  3. Line chart
  4. Column chart
  
Pages