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




Question 31 :
You can open the scenario Manager dialog box by choosing scenarios from the ..... menu.

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

Question 32 :
What do we call a computer pro gram that orga-nizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

  1. Spreadsheet program
  2. Database program
  3. Word processor program
  4. Desktop publisher program
  

Question 33 :
When a row of data is to be converted into columns

  1. Copy the cells in row, select the same number of cells in row and paste
  2. Copy the cells in column then choose Edit > > Paste Special, then click Transpose and OK
  3. Copy the cells then go to Format > > Cells then on Alignment tab click Transpose check box and click OK
  4. Select the cells then place the cell pointer on new cell and choose Edit ? Paste Special, mark Transpose check box and click OK.
  

Question 34 :
When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

  1. Auto Complete
  2. AutoFormat
  3. Custom List
  4. Calculation Automatic
  

Question 35 :
When you print preview a worksheet

  1. the entire worksheet is displayed
  2. the selected range is displayed
  3. the active portion of the worksheet is displayed
  4. a, b and c
  

Question 36 :
Which of the following options is not located in the Page Setup dialog box?

  1. Page Break Preview.
  2. Page Orientation
  3. Margins
  4. Headers and Footers
  

Question 37 :
The spelling dialog box can be involved by choosing spelling from ___ menu.

  1. insert
  2. file
  3. tools
  4. view
  

Question 38 :
Which of the following is an absolute cell reference?

  1. !A!1
  2. SA$1
  3. #a#l
  4. Al
  

Question 39 :
Which of the cell pointer indicate that you can move the content to other cell?

  1. Doctor's symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. All of above
  

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

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

Question 41 :
What symbol is used before a number to make it a label?

  1. (quote)
  2. = (equal)
  3. _ (underscore)
  4. * (apostrophe)
  

Question 42 :
You can edit existing Excel data by pressing the

  1. Flkey
  2. F2key
  3. F3key
  4. F4key
  

Question 43 :
To make a number In cell Cl 10% smaller than the number In C3 you enter

  1. -03*1.10
  2. +C3*110
  3. -C3%10
  4. -C3*.90
  

Question 44 :
Comments can be added to cells using

  1. Edit > Comments
  2. Insert > Comments
  3. File > Comments
  4. View > Comments
  

Question 45 :
Pounding errors can occur

  1. When you use multiplication, division, or exponentiation in a formula
  2. When you use addition and subtraction in a formula
  3. Because excel uses hidden decimal places in computation
  4. When you show the results of formulas with different decimal places that the calculated results
  

Question 46 :
Hyperlinks can be

  1. Text
  2. Drawing objects
  3. Pictures
  4. All of above
  

Question 47 :
What la the symbol for multiplying?

  1. >
  2. /
  3. !
  4. *
  

Question 48 :
B7:B9 indicates:

  1. Cells B7 and cell B9 only.
  2. Cells B7 through B9.
  3. Cell BSonly.
  4. None of the a bove.
  

Question 49 :
Which of the following displays the contents of the active cell?

  1. Active cell
  2. Formula bar
  3. Menu bar
  4. Name box
  

Question 50 :
Which area in an excel window allows entering values and formulas

  1. Title bar
  2. Menu bar
  3. Formula bar
  4. Standard toolbar
  

Question 51 :
To hold row and column titles in place 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 52 :
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 53 :
The default and maxium number of sheets for a new workbook in Excel 2003 is

  1. 3 and 255
  2. 3 and 256
  3. 1 and 255
  4. 1 and 256
  

Question 54 :
How do you rearrange the data In ascending or descending order?

  1. Data, Sort
  2. Data, Form
  3. Data, Table
  4. Data Subtotals
  

Question 55 :
Which of the following is not true regarding Conditional Formatting?

  1. You can add more than one condition to check
  2. You can set condition to look for Bold and apply Italics on them.
  3. You can apply Font, border and pattern formats that meets the specified conditions
  4. You can delete any condition from Conditional Formatting dialog box if it is not requried
  

Question 56 :
To select several cells or ranges that are not touching each other, you would ... while selecting

  1. hold down the Ctrl key
  2. hold down the Shift key
  3. hold down the Alt key
  4. hold down Ctrl + Shin key
  

Question 57 :
To delete an embedded objects, first

  1. Double click the object
  2. Select the object by clicking it
  3. Press the Shift + Delete ' keys
  4. Select it and then press the delete key
  

Question 58 :
Excel files have a default extension of

  1. Xls
  2. Xlw
  3. Wkl
  4. 123
  

Question 59 :
Which of the following is a correct order of precedence in formula palcuiation?

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

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