DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Formula Bar is only used to create formulas by pressing the fx located to the left of the box.
|
|
|
The Formula Bar contains the contents of the cell you have selected.
|
|
|
You can type numbers or text directly into the formula bar.
|
|
|
You can edit words or numbers contained in selected cells in the Formula Bar.
|
Detailed explanation-1: -The Formula Bar is the block located above the grid in a worksheet and preceded by the letters fx. Which of the following comments about the Formula Bar is NOT correct: a) The Formula Bar is only used to create formulas by pressing the fx located to the left of the box.
Detailed explanation-2: -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-3: -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. A spreadsheet formula is a mathematical equation that will calculate a result.
Detailed explanation-4: -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-5: -8) The correct answer is d. 9) Which of the following functions is NOT associated with the Review Tab on the Ribbon? a) The spelling checker.