Top 20 MCQ Questions On Microsoft Office Excel Set-3

This set of MCQ Questions on Microsoft Office Excel includes the collection of the top 20 multiple-choice questions on the fundamentals of Microsoft Excel. It includes objective questions on adding hyperlinks from an Excel Workbook, a shortcut key to create a chart, a shortcut key used to switch between sheet to sheet, a number of Rows in one worksheet, the auto-calculate feature of excel, and the 3-d reference in a formula.

1) You can hyperlinks from an Excel Workbook to
A. A web page on the company’s 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 shortcut key to create a chart on a chart sheet creates
A. A default chart
B. A 2-dimensional column chart
C. A 2-dimensional bar chart
D. A 3-dimensional line chart

4) 3-D reference in a formula…
A. Can not be modified
B. Only appears on the summary worksheet
C. Limits the formatting options
D. Spans worksheets

5) You can select a single range of cells 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 worksheets at one time
D. Both B and C

7) In which shortcut 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 occur
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 the 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 in 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 an 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 is 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 areas 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 formats 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-dimensional 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 an 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