Ms Excel - Study Mode

[#126] When you link data maintained in an excel workbook to a word document
Correct Answer

(B) The word document contains a reference to the original source application

Explanation

Solution: When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.

[#127] Which area in an excel window allows entering values and formulas
Correct Answer

(C) Formula bar

Explanation

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.

[#128] To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Correct Answer

(B) Freeze panes command on the window menu

Explanation

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.

[#129] To edit in an embedded excel worksheet object in a word document
Correct Answer

(A) Use the excel menu bar and toolbars inside the word application

Explanation

Solution: Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.

[#130] To create a formula, you can use:
Correct Answer

(D) Value and cell references

Explanation

Solution: To create a formula, we can use value and cell references both.