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]
Define Formula Bar?
A
I don’t know
B
I don’t care
C
Don’t miss this one!
D
An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.
Explanation: 

Detailed explanation-1: -What is a formula bar in Excel? Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.

Detailed explanation-2: -The Quick Access Toolbar (QAT) is a customizable toolbar containing a set of commands that are independent of the tab that is currently displayed. It can be located in one of two places: Upper-left corner above the ribbon (default location) Upper-left corner below the ribbon.

Detailed explanation-3: -Alternatively called a formula box, the formula bar is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and lets you create and view formulas.

Detailed explanation-4: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.

There is 1 question to complete.