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]
The ____ is where any calculations or formulas you write will appear.
A
Formula Bar
B
Spreadsheet Grid
C
Either A or B
D
None of the above
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: -To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U.

Detailed explanation-3: -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.

Detailed explanation-4: -The correct answer is There is no formula bar in MS Word. There is no formula bar present in the MS Word 2010. The section of Formula Bar is present in Microsoft Excel. The Formula bar shows the contents of the current cell and allows you to create and view formulas.

Detailed explanation-5: -The three types of data in Excel are numbers, text, and dates/times. 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.