DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Portrait Orientation
|
|
|
Formula Bar
|
|
|
Fill Handle
|
|
|
Cell Reference
|
Detailed explanation-1: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.
Detailed explanation-2: -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-3: -In Microsoft Excel, the Name Box displays the cell that is currently selected in the spreadsheet. It is located to the left of the formula bar. If a name is defined for a cell that is selected, the Name Box displays the name of the cell.
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.