Option “B” is correct. Comments put in cells are called Cell Tip
22.
Which is used to perform what if analysis?
a.
Solver
b.
c.
d.
Option “D” is correct. Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.
23.
You can use the horizontal and vertical scroll bars to-
a.
Split a worksheet into two panes
b.
c.
d.
Option “B” is correct. You can use the horizontal and vertical scroll bars to view different rows and columns edit the contents of a cell.
24.
Multiple calculations can be made in a single formula using-
a.
b.
c.
d.
Option “B” is correct. An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
25.
Hyperlinks can be-
a.
Text
b.
c.
Pictures
d.
Option “D” is correct. Hyperlinks can be a text or drawing objects or pictures. A hyperlink is a word, phrase, or image that we can click on to jump to a new file or a new section within the current file.
26.
When you link data maintained in an excel workbook to a word document-
a.
b.
c.
d.
Option “B” is correct. When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.
27.
Which area in an excel window allows entering values and formulas-
a.
b.
c.
d.
Option “C” is correct. 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.
28.
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
a.
b.
c.
d.
Option “B” is correct. 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.
29.
To edit in an embedded excel worksheet object in a word document
a.
b.
c.
d.
Option “A” is correct. Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.
30.
To create a formula, you can use:
a.
b.
c.
d.
Option “D” is correct. To create a formula, we can use value and cell references both.
Appcation is a great of humanlife
Very interesting details you have noted, thank you for posting.Raise blog range