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




Question 91 :
You can group noncontiguous worksheets with

  1. The group button on the standard toolbar
  2. The shift key and the mouse
  3. The Ctrl key and mouse
  4. The alt+enter key
  

Question 92 :
Each excel file is called a work-book 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 93 :
MS-EXCEL is based on .-.....-?

  1. WINDOWS
  2. DOS
  3. UNIX
  4. OS/2
  

Question 94 :
Status indicators are located on the

  1. Vertical scroll bar
  2. Horizontal scroll bar
  3. Formula bar
  4. Standard toolbar
  

Question 95 :
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence ofsgyents that will do this?

  1. Go to File-Save As - Save As Type - Excel worksheet
  2. Right click on the spreadsheet tab and setect DELETE
  3. Right click on the spreadsheet and select Insert ? Entire Column
  4. None of above
  

Question 96 :
Youar German supplier still in-voices 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 97 :
Which of the following is the oldest spreadsheet package?

  1. VisiCalc
  2. Lotus 1-2-3
  3. Excel
  4. StarCalc
  

Question 98 :
lt is acceptable of let long text flow into adjacent cells on a worksheet when

  1. Data will be entered in the adjacent cells
  2. No data will be entered in the adjacent cells
  3. There is not suitable abbreviation of the text
  4. There is not time to format the next
  

Question 99 :
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:

  1. word processing
  2. spreadsheet
  3. database
  4. graphics
  

Question 100 :
Macros are run or executed from the...... menu.

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

Question 101 :
A function inside another function is called a.....function.

  1. Nested
  2. Round
  3. Sum
  4. Text
  

Question 102 :
What is an expression that tells how the numbers in a determined set of cells are to be calculated?

  1. Formula
  2. Field
  3. Data
  4. Query
  

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

  1. End key
  2. Shift key
  3. Ctrl key
  4. Esc key
  

Question 104 :
Which of the following will not cut information?

  1. Pressing Ctrl + C
  2. Selecting Edit >Cut from the menu
  3. Clicking the Cut button on the standard
  4. Pressing Ctrl + X
  

Question 105 :
You can zoom a worksheet

  1. With the mouse pointer in Print Preview
  2. With the zoom button on the Print Preview toolbar
  3. With the Zoom command on the view menu
  4. All of the above
  

Question 106 :
Tab scroll buttons are place on Excel screen

  1. towards the bottom right corner
  2. towards the bottom left corner
  3. towards the top right corner
  4. towards the top left corner
  

Question 107 :
When you insert an excel file into a word document. The data are

  1. Hyperlinked placed in a word table
  2. Linked
  3. Embedded
  4. Use the word menu bar and toolbars
  

Question 108 :
You can convert existing excel worksheet data an charts to an HTML document by using

  1. Internet assistant wizard
  2. FTP wizard
  3. Intranet wizard
  4. Import wizard
  

Question 109 :
Which function will you use to enter current time In a woksheet cell?

  1. .=today( )
  2. .-now ( )
  3. .-time ( )
  4. .=CurrentTime ( )
  

Question 110 :
To select a column the easiest method is to........

  1. Double click any cell in the column
  2. Drag from the top cell in the column to the last cell in the column
  3. click the column heading
  4. click the column label
  

Question 111 :
A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......

  1. nothing will print because some cells with data have been omitted
  2. only the cells with gray back-ground will print
  3. the whole sheet will print
  4. only the cells with white background will print
  

Question 112 :
The default font used In Excel is

  1. Arlal
  2. Algerial
  3. Times New Roman
  4. Preetl
  

Question 113 :
To copy formatting from one area in a worksheet and apply it to another area you would use:

  1. The Edit>Copy Format and Edit>Paste Format commands form the menu.
  2. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
  3. There is no way to copy and apply formatting in Excel - You have to do it manually
  4. The Format Painter button on the standard toolbar
  

Question 114 :
What function displays row data in a column or column data in a row?

  1. Hyperlink
  2. Index
  3. Transpose
  4. Rows
  

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

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

Question 116 :
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 117 :
To edit in an embedded excel worksheet object in a word document

  1. Use the excel menu bar and toolbars inside the word application
  2. Edit the hyperlink
  3. Edit the data in a excel source application
  4. Use the word menu bar and toolbars
  

Question 118 :
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

  1. Workday
  2. Date
  3. Networkdays
  4. All of the above
  

Question 119 :
You can use the horizontal and vertical scroll bars to

  1. Split a, worksheet into two panes
  2. View different rows and columns edit the contents of a cell
  3. Edit the contents of a cell
  4. view different worksheets
  

Question 120 :
To protect a worksheet, you can choose Protection and the Protect Sheet from the..... menu

  1. Edit
  2. Format
  3. Tools
  4. Data
  
Pages