USING MICROSOFT EXCEL
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: -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-3: -To wrap the complex formulas or data into multiple lines, then point your selection where you want to break your data or formula, press Alt + Enter. The data or formula will be moved to the next line in the formula bar.
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. A spreadsheet formula is a mathematical equation that will calculate a result.
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.