DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Edit Formula button
|
|
|
The Cancel button
|
|
|
The Enter button
|
|
|
All of above
|
Detailed explanation-1: -Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.
Detailed explanation-2: -The Formula Bar is where data or formulas you 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. What is this? The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
Detailed explanation-3: -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-4: -The formula bar displays the content of the active cell in MS Excel. The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.
Detailed explanation-5: -The formula bar shows the formula. That’s what it’s there for. You can edit the formula, select the whole contents of the formula bar and then hit F9. That will evaluate the formula in the formula bar and you will see the result of the formula there.