FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Where can you find the Insert Function button in Microsoft Excel?
A
Formula bar
B
Status bar
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Go to the Formulas ribbon – choose either the Insert Function icon to bring up the Insert Function dialog box (same dialog box you would get with the first method), or click the arrow next to the correct category in the Function Library Group, and then choose the desired function.

Detailed explanation-2: -On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the selected sheet tabs, and then click Insert.

Detailed explanation-3: -The Insert Function button is located on the Formula bar.

Detailed explanation-4: -The correct answer is Shift + F3. When you click the Insert Function button, Excel displays the Insert Function dialog box.

Detailed explanation-5: -The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.

There is 1 question to complete.