DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Title Bar
|
|
QAT
|
|
Scroll Bar
|
|
Formula Bar
|
Detailed explanation-1: -The correct answer is the Formula bar. 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-2: -Click File (or the Office button in earlier Excel versions). Go to Options. Click Advanced in the left pane. Scroll down to the Display section and select the Show Formula bar option.
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.
Detailed explanation-4: -Excel Formula Bar is a thin bar below the ribbon that displays the selected cell’s content and displays the cell address of the selected cell on the left side.
Detailed explanation-5: -Name Box: The name box appears to the left of the formula bar and displays the name of the current cell.