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




Question 391 :
Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the

  1. cell's column label
  2. cell's column label and worksheet tab name
  3. cell's row label
  4. cell's row and column la-bels
  

Question 392 :
You can copy data or formulas

  1. With the copy, paste and cut commands on the edit menu
  2. With commands on a shortcut menu
  3. With buttons on the standard toolbar
  4. All of the above
  

Question 393 :
A ______is a grid with labeled columns and rows.

  1. Dialog box
  2. Worksheet
  3. Clipboard
  4. Toolbar
  

Question 394 :
Excel worksheet cells work very similarly to what common element of the windows graphical user interface

  1. Option buttons
  2. List boxes
  3. Text boxes
  4. Combo boxes
  

Question 395 :
Which of the following methods can not be used to enter data in a cell?

  1. Pressing an arrow key
  2. Pressing the tab key
  3. Pressing the Esc key
  4. Qlicking the enter button to the formula bar
  

Question 396 :
Excel is a

  1. Graphic program
  2. None of these
  3. Word processor
  4. A spreadsheet
  

Question 397 :
To center worksheet titles across a range of cell, you must

  1. Select the cells containing the title text and use the fill handle to center the text across a range of cells
  2. Widen the columns
  3. Select the cells containing the title text and use the fill handle to center the text across a range of cells
  4. Widen the column
  

Question 398 :
In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

  1. calendar
  2. photograph of rainfall
  3. chart showing rainfall amounts
  4. data base of rainfall
  

Question 399 :
What happens when dollar signs (S) are entered In a cell address?

  1. An absolute eel I address is created.
  2. Cell address will change when it is copied to another cell.
  3. The sheet tab is changed.
  4. The status bar does not display the eel I address.
  

Question 400 :
The Trace Precedence on 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. None of above
  

Question 401 :
Each excel file is called a workbook because

  1. It can contain text and data
  2. It can be modified
  3. It can contain many sheets including worksheets and chart sheets
  4. You have to work hard to create it
  

Question 402 :
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 these
  

Question 403 :
Merge cells option can be applied from

  1. Format Cells dialog box Alignment Tab
  2. Formatting toolbar
  3. Both of above
  4. All of above
  

Question 404 :
You can open the Sort dialog box by choosing Sort from the .... menu

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

Question 405 :
Which of the following is the latest version of Excel?

  1. Excel 2000
  2. Excel 20.02
  3. Excel ME
  4. Excel XP
  

Question 406 :
To return the remainder after a number Is divided by a divisor In EXCEL we use the function?

  1. ROUND ( )
  2. FACTQ
  3. MODQ
  4. DIV()
  

Question 407 :
To insert three columns between columns D and E you would

  1. Select column D
  2. Select column E
  3. Select columns E, F and G
  4. Select columns D, E, and F
  

Question 408 :
Tab scrolling buttons

  1. Allow you.to view a different worksheet
  2. Allow you to view additional worksheet row down
  3. Allow you to view additional worksheet columns to the right
  4. Allow you to view additional sheet tabs
  

Question 409 :
The name box

  1. Shows the location of the previously active cell
  2. Appears to the left of the formula bar
  3. Appears below the status bar
  4. Appears below the menu bar
  

Question 410 :
Which would you choose to create a bar diagram?

  1. Edit, Chart
  2. Insert, Chart
  3. Tools, Chart
  4. Format, Chart
  

Question 411 :
To remove the content of selected cells you must issue _____ command

  1. Edit? Delete
  2. Edit ? Clear ? Contents
  3. Edit ?> Clear? All
  4. Data ? Delete
  

Question 412 :
Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?

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

Question 413 :
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

  1. worksheet
  2. chart sheet
  3. module sheet
  4. data sheet
  

Question 414 :
Formatting a cell In Number format you can't set

  1. Decimal Places
  2. Use 1000 separator
  3. Negative numbers
  4. Currency Symbol
  

Question 415 :
The default header for a worksheet is

  1. Your name
  2. The date and time
  3. None
  4. The sheet tab name
  

Question 416 :
Comments put in cells are called

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

Question 417 :
Where can you change automatic or manual calculation mode in Excel?

  1. Double CAL indicator on status bar
  2. Go to Tools > > Options > > Calculation and mark the corresponding radio button
  3. Both of above
  4. Press F7
  

Question 418 :
Which symbol must ail formula begin with?

  1. =
  2. +
  3. (
  4. e
  

Question 419 :
Special category of Number tab in Format Cells dialog box can be used to apply formats like

  1. Zip Code
  2. Phone Number
  3. Both of above
  4. None of above
  

Question 420 :
Text formulas:

  1. Replace cell references
  2. Return ASCII values of characters
  3. Concatenate and manipulate text
  4. Show formula error value
  
Pages