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




Question 1 :
The default font size in Excel worksheet is

  1. 10 points
  2. 12 points
  3. 14 points
  4. None of above .
  

Question 2 :
Which of the following action removes a sheet from workbook?

  1. Select the sheet, then choose Edit > > Delete Sheet
  2. Select the sheet then choose Format ? Sheet ? Hide
  3. Press Insert
  4. All of above
  

Question 3 :
You can quickly change the appearance of your work by choosing Auto Format from the .... Menu

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

Question 4 :
Which area In an Excel window allows entering values and formulas?

  1. Title Bar
  2. Menu Bar
  3. Formula Bar
  4. Standard Tool Bar
  

Question 5 :
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify ac: curacy. How do you activate this feature?

  1. Point to speech on the tools menu, and then click show text to speech toolbar.
  2. Click validation on the data menu
  3. Point to speech on the tools menu, and then click speech recognition
  4. All of above
  

Question 6 :
Which of the following you can paste selectively using Paste Special command?

  1. Validation
  2. Formats
  3. Formulas
  4. All of above
  

Question 7 :
Charts tips can

  1. Show the formatting of a data label
  2. Show the name of a data series
  3. Show the value of data point
  4. b and c
  

Question 8 :
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 9 :
Rounding 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 10 :
Multiple calculations can be made In a single formula using....

  1. Standard Formulas
  2. Array Formula
  3. Complex Formulas
  4. Smart Formula
  

Question 11 :
In Excel, the Fill Color button on the Formatting toolbar is used for what?

  1. To insert a background.
  2. To add borders.
  3. To select a distribution of figures.
  4. To add shading or color to a cell range.
  

Question 12 :
You can not link Excel worksheet data to a Word document

  1. With the right drag method
  2. With a hyperlink
  3. With the copy and paste -special commands
  4. With the copy and paste buttons on the standard toolbar
  

Question 13 :
Right clicking something in Excel:

  1. Deletes the object
  2. Nothing the right mouse button is there for left handed people
  3. Opens a shortcut menu listing everything you can do to the object
  4. Selects object
  

Question 14 :
How do you insert a row?

  1. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
  2. Select the row heading where you want to insert the new row and select Edit > Row from the menu
  3. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
  4. All of the above
  

Question 15 :
Which setting you must modify to print a worksheet using letterhead?

  1. Paper
  2. Margin
  3. Layout
  4. Orientation
  

Question 16 :
What does COUNTA ( ) function do?

  1. counts cells having alphabets
  2. counts empty eel Is
  3. counts cells having number
  4. counts non-empty cells
  

Question 17 :
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

  1. Square
  2. Percentage
  3. Goal Seek
  4. Divide
  

Question 18 :
To open the Format Cells dialog box, press

  1. Alt* 1
  2. Ctrl + 1
  3. Ctrl + Shift + 1
  4. Fl
  

Question 19 :
Which function Is used to calculate depreciation, rates of return, future values and loan payment amounts?

  1. Logical
  2. Math - Trigonometry
  3. Statistical
  4. Financial
  

Question 20 :
Hyperlinks cannot be

  1. Special shapes like stars and banners
  2. Drawing objects like rectangles ovals
  3. Pictures
  4. All can be hyperlinks
  

Question 21 :
Which area in an Excel window allows entering values and formulas

  1. Title Bar
  2. Menu Bar
  3. Formula Bar
  4. Standard Tool Bar
  

Question 22 :
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 23 :
Excel files have a default extension of

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

Question 24 :
When you are typing an equation into a cell the first thing that must be entered is

  1. the first cell referenced
  2. parenthesis
  3. quotation marks
  4. an equal sign
  

Question 25 :
What do you mean by a Workspace?

  1. Group of Col umns
  2. Group of Worksheets
  3. Group of Rows
  4. Group of Workbooks
  

Question 26 :
What Is the symbol for dividing?

  1. /
  2. =%
  3. -
  4. fl
  

Question 27 :
Which function calculates your monthly mortage payment?

  1. PMT (payments)
  2. NPER (number of periods)
  3. PV (present value)
  4. All of above
  

Question 28 :
If you press...... the cell accepts your typing as its contents.

  1. Enter
  2. Ctrl+Enter
  3. Tab
  4. Insert
  

Question 29 :
A typical worksheet has .... Number of columns

  1. 128
  2. 256
  3. 512
  4. 1024
  

Question 30 :
Which of the following is not an option in the spelling dialog box?

  1. Edit
  2. Ignore
  3. Ignore all
  4. Change
  
Pages