Solved MCQ On Microsoft Excel In Ms Office Set-1

Here you can find Solved MCQ on Microsoft Excel in Ms Office includes objective questions on MS excel worksheet data and chart, integrating MS word and excel, comments put in cells, getting data from a cell located in a different sheet, graphic object on a chart, concatenation of text and inserting a blank embedded MS excel object in a word document.

1) You can convert existing Ms Excel Worksheet data and chart to on HTML document by using the ..
A. FTP Wizard
B. Internet Assistant Wizard
C. Internet Wizard
D. Import Wizard

2) Which of the following methods cannot be used to edit the contents of a cell?
A. Pressing an arrow key
B. Clicking the formula bar
C. Pressing the F2 key
D. Clicking on the formula bar

3) A typical worksheet has ………. number of columns.
A. 128
B. 256
C. 512
D. 1024

4) When integrating Ms Word and Excel Word is usually the ..
A. Server
B. Source
C. Client
D. None of the above

5) Comments put in cells are called ..
A. Smart tip
B. Cell tip
C. Web tip
D. Soft tip

6) You can use the horizontal and vertical scroll bars to ..
A. Split a worksheet into two panes
B. View different rows and columns edit the contents of a cell
C. Edit the contents of a cell
D. View different worksheets

7) Hyperlink cannot be
A. Special shapes like stars and banners
B. Drawing objects like rectangles or ovals
C. Pictures
D. All of the above

8) When the formula bar is activated, you can see ..
A. The edit formula button
B. The cancel button
C. The enter button
D. All of the above

9) Getting data from a cell located in a different sheet is called …
A. Accessing
B. Referencing
C. Updating
D. Functioning

10) To delete an embedded object, first ..
A. Double click the object
B. Select the object by clicking it
C. Press the shift+Delete keys
D. Select it and then press the delete keys
11) Workbook is a collection of ..
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts

12) Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time

13) When you want to insert a blank embedded Ms Excel object in a Word document you can ..
A. Click the object command on the insert menu
B. Click the office links buttons on the standard toolbar
C. Click the create worksheet button on the formatting toolbar
D. Click the import Excel command on the file menu

14) Which elements of a worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of the above

15) Status indicators are located on ..
A. Vertical scroll-bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar

16) Graphic object on a chart are used to ..
A. Add emphasis to chart data
B. Add interest to a chart
C. Help explain the chart data
D. All of the above

17) You can activate a cell by ..
A. Pressing the tab key
B. Clicking the cell
C. Pressing an arrow key
D. All of the above

18) Concatenation of text can be done using
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)

19) When you use the fill effects in the format data series dialog box, you can not ..
A. Rotate text on the chart
B. Select a foreground color
C. Select a pattern
D. Select a background color

20) Each excel file is called a workbook because …
A. It can contain text and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it

Answers:

1) B. Internet Assistant Wizard
2) A. Pressing an arrow key
3) B. 256
4) C. Client
5) B. Cell tip
6) B. View different rows and columns edit the contents of a cell
7) D. All of the above
8) D. All of the above
9) B. Referencing
10) D. Select it and then press the delete keys
11) D. Worksheets and charts
12) B. Character
13) A. Click the object command on the insert menu
14) D. All of the above
15) C. Formula bar
16) D. All of the above
17) D. All of the above
18) D. Ampersand (&)
19) A. Rotate text on the chart
20) C. It can contain many sheets including worksheets and chart sheets