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




Question 331 :
To add two cells (Al and A(2) together you use the following formula

  1. =A1 + A2
  2. =Add(AI+A(2)
  3. together (A 1:A(2)
  4. AlplusA2
  

Question 332 :
What is the AutoSummarize feature used for in Word 2000

  1. It creates a 250 word, 500 word or 1000 word summary of the document
  2. It adds Automatic headwers, bold and italic characters as well as' automatic formatting of the document to give the look of a well summarized document
  3. it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs
  4. It identifies the key points in a document for your to share with others or quickly scan
  

Question 333 :
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

  1. Unfreeze panes command on the window menu
  2. Freeze panes command on the window menu
  3. Hold titles command on the edit menu
  4. Split command on the window menu
  

Question 334 :
The first cell in EXCEL worksheet is labeled as

  1. A
  2. A1
  3. Aa
  4. AO
  

Question 335 :
You can enter which types of data into worksheet cells?

  1. Labels, values, and formulas
  2. Labe31s and values but not formulas
  3. Values and formulas but not labels
  4. Formulas only
  

Question 336 :
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 337 :
The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the corurol field change.

  1. ADD
  2. SUM
  3. TOTAL
  4. LIST
  

Question 338 :
Which of the following is not a valid data type in excel

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

Question 339 :
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

  1. AutoFill
  2. Auto correct
  3. Auto sum
  4. Auto format
  

Question 340 :
The spelling tool Is placed on _toolbar

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

Question 341 :
In a worksheet you can select

  1. The entire worksheet
  2. Rows
  3. Columns
  4. All of the above
  

Question 342 :
Qtr 1, Qtr 2, Qtr 3 is an example of a

  1. Formula
  2. Function
  3. Series
  4. Syntax
  

Question 343 :
You can edit a cell by

  1. Clicking the formula button
  2. Double clicking the cell to edit it in-place
  3. Selecting Edit > Edit Cell from the menu
  4. None of above
  

Question 344 :
Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?

  1. Press Ctrl +Home
  2. Press Home
  3. Press Shift + Home
  4. Press Alt + Home
  

Question 345 :
A data map is helpful

  1. When you have too much data to chart
  2. To show a geographic distribution of data
  3. To compare data points
  4. To show changes in data over time
  

Question 346 :
You can move a sheet from one workbook into new book by

  1. From Edit menu choose Move or Copy sheet mark the Create a copy and Click OK
  2. From Edit menu choose Move of Copy then choose {Move to end) and click OK
  3. From Edit menu choose Move or Copy then select {new book) from To Book list and click OK
  4. All of above
  

Question 347 :
Which tool you will use to join some cells and place the content at the middle of joined cell?

  1. From Format Cells dialog box click on Merge Cells check box
  2. From Format Cells dialog box select the Centered alignment
  3. -From Format Cells dialog box choose Merge and Center check box
  4. Click on Merge and Center tool on formatting toolbar
  

Question 348 :
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 349 :
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

  1. Rows and columns
  2. Headings
  3. Speed
  4. All of above
  

Question 350 :
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
  

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

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

Question 352 :
Which of the following is a popular DOS based spreadsheet package?

  1. Word
  2. Smart cell
  3. Excel
  4. Lotus 1-2-3
  

Question 353 :
Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

  1. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign,
  2. On the tools menu, click Add-lns, and select the Euro Currency Tools check box
  3. Apply a selected background color
  4. All of above
  

Question 354 :
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 355 :
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 356 :
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

  1. XY Chart
  2. Line Chart
  3. Pie Chart
  4. Column Chart
  

Question 357 :
An excel workbook is a collection of

  1. Workbooks
  2. Worksheets
  3. Charts
  4. Worksheets and charts
  

Question 358 :
What Is entered by the function ?today ()

  1. The date value for the day according to system clock
  2. The time value according to system clock
  3. Today's date as Text format
  4. none of above
  

Question 359 :
Which of the following option is not available in Paste Speciat dialog box?

  1. Add
  2. Subtract
  3. Divide
  4. SORT
  

Question 360 :
The Paste Special command lets you copy and paste:

  1. Multiply the selection by a copied value
  2. Cell comments
  3. Formatting options
  4. The resulting values of a formula instead of the actual formula
  
Pages