DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
On the Formulas tab
|
|
|
In the Status bar
|
|
|
In the Title bar
|
|
|
Underneath the ribbon
|
Detailed explanation-1: -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-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 Quick Access Toolbar (QAT) is a customizable toolbar containing a set of commands that are independent of the tab that is currently displayed. It can be located in one of two places: Upper-left corner above the ribbon (default location) Upper-left corner below the ribbon.
Detailed explanation-4: -The formula bar is a toolbar that appears at the top of our worksheet, below the Ribbon in our workbook.
Detailed explanation-5: -The formula bar is found at the bottom of the Excel window. Use the fill handle to create a natural series, such as the months of the year. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.