([Link]
com/) Login
([Link]
/login
/?url=https
%3A%2F
%[Link].c
fundamentals%2Fprac
mcq-question-
on-ms-
excel%2F
%3Fsection%3D2%26
Home ([Link] Aptitude ([Link]
English ([Link]
Reasoning ([Link]
DI ([Link]
GK ([Link]
Current Affairs ([Link] Interview ([Link] Computer
Programming Engineering More Ask Question ([Link]
Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental
Home ([Link] / Computer Fundamentals ([Link] / MS Excel
Section 1 ([Link]
Section 2 ([Link]
Section 3 ([Link]
56. When you link data maintained in an excel workbook to a word document
A. The word document cannot be edit
B. The word document contains a reference to the original source application
C. The word document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option B
Solution:
When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.
57. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option C
Solution:
Formula Bar is where data or formulas we enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or
formula in the active cell.
58. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click
the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
Answer & Solution
Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option B
Solution:
When we want to scroll down the worksheet, and lock the heading rows in place, so it is always visible, we can use one of the Freeze Panes
commands.
59. To edit in an embedded excel worksheet object in a word document
A. Use the excel menu bar and toolbars inside the word application
B. Edit the hyperlink
C. Edit the data in a excel source application
D. Use the word menu bar and toolbars
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option A
Solution:
Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.
60. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option D
Solution:
To create a formula, we can use value and cell references both.
([Link]
excel/?section=2&page=11)
1 ([Link]
excel/?section=2)
2 ([Link]
excel/?section=2&page=2)
3 ([Link]
excel/?section=2&page=3)
4 ([Link]
excel/?section=2&page=4)
5 ([Link]
excel/?section=2&page=5)
6 ([Link]
excel/?section=2&page=6)
7 ([Link]
excel/?section=2&page=7)
8 ([Link]
excel/?section=2&page=8)
9 ([Link]
excel/?section=2&page=9)
10 ([Link]
excel/?section=2&page=10)
11 ([Link]
excel/?section=2&page=11)
12