MCQ Questions on Microsoft Excel in Ms Office set-3

Get 1000's of Basic IT MCQs as pdf E-Book on Free Download Now

1) You can hyper-links from an Excel Workbook to

A. A web page on company Internet

B. A web page on the Internet

C. Other office application documents

D. All of the above


2) To activate the previous cell in a preselected range, press

A. The alt key

B. The tab key

C. The enter key

D. None of the above


3) Using the F11 short cut key to crate a chart on a chart sheet creates

A. A default chart

B. A 2-dimentional column chart

C. A 2-dimentional bar chart

D. A 3-dimentional line chart


4) 3-D reference in a formula ..

A. Can not be modified

B. Only appears on summary worksheet

C. Limits the formatting options

D. Spans worksheets


5) You can select single range of cell by

A. Clicking the upper left cell in a group of cells and then pressing the shift key while clicking the lower right cell in a group of cells.

B. Pressing the Ctrl key while dragging over the desired cells

C. Press the shift key and arrows key

D. Dragging over the desired cells


6) When you group worksheets

A. You can enter variable data on multiple worksheets at one time

B. You can print more than one worksheet at a time

C. You can enter common data, formats, and formulas on multiple worksheet at one time

D. Both B and C


7) In which short cut key used to switch between sheet to sheet

A. Ctrl+S

B. Ctrl+Page down

C. Ctrl+Page up

D. Both B and C


8) Rounding errors can occurs

A. When you use multiplication, division or exponentiation in a formula.

B. Because excel uses hidden decimal places in computation

C. When you use addition and subtraction in a formula

D. When you show the results of formula with different decimal places than the calculated results.


9) A 3-d reference in a formula

A. Cannot be modified

B. Only appears on summary worksheets

C. Limits the formatting options

D. Spans worksheets


10) The number of Rows are one worksheet is ...

A. 36500

B. 65536

C. 256

D. 64536

11) The auto calculate feature

A. Can only add values in a range of cells

B. Provides a quick way to view the results of a arithmetic operation on a range of cells

C. Automatically Creates formulas and adds them to a worksheet

D. Both A and C


12) Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A. Press Ctrl+Home

B. Press Home

C. Press Shift+Home

D. Press Alt + Home


13) The moving toolbar are also called ..

A. Long Toolbars

B. Active Toolbar

C. Floating Toolbar

D. All of the above


14) Which of the following is a correct order of precedence in formula calculation?

A. Multiplication and division, exponentiation, positive and negative values

B. Multiplication and division, positive and negative values, addition and subtraction

C. Addition and subtraction, positive and negative values, exponentiation

D. None of the above


15) Which button do you click to add up a series of numbers?

A. The auto sum button

B. The formula button

C. The quick total button

D. The total button


16) What are the major application area of electronic spread sheet's

A. Financial Modelling

B. Basic spreadsheet calculation

C. Scientific data processing

D. All of the above


17) In a Worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All


18) The paste special command lets you copy and paste

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula


19) The number of data format in excel is

A. Four type

B. Five Type

C. Two types

D. Six types


20) To view cell comment

A. Click the edit comment command on the insert menu

B. Click the display comment command on the window menu

C. Position the mouse pointer over the cell

D. Click the comment command on the view menu

Answers:

1) D. All of the above
2) D. None of the above
3) B. A 2-dimentional column chart
4) D. Spans worksheets
5) D. Dragging over the desired cells
6) D. Both B and C
7) D. Both B and C
8) A. When you use multiplication, division or exponentiation in a formula.
9) D. Spans worksheets
10) B. 65536
11) B. Provides a quick way to view the results of a arithmetic operation on a range of cells
12) A. Press Ctrl+Home
13) C. Floating Toolbar
14) D. None of the above
15) A. The auto sum button
16) D. All of the above
17) D. All
18) D. The resulting values of a formula instead of the actual formula
19) A. Four type
20) C. Position the mouse pointer over the cell