DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
View Formula bar
|
|
|
View Toolbars Standard
|
|
|
View Ruler
|
|
|
View Toolbars Drawing
|
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: -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: -For all Windows versions of Microsoft Excel, you can simply hold down the “Ctrl” key on your keyboard and press ‘. This key is called the “grave accent” and is usually located to the right of the number 1 on most keyboards. Here are some other methods you can use. Select the “Formulas” tab.
Detailed explanation-4: -Answer: By default, Excel shows the results of formulas. To show the formulas instead of their results, press CTRL + ‘ (you can find this key above the tab key).
Detailed explanation-5: -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. You can also enter a value into the cell from the formula bar. It has three buttons (Enter, Cancel, and Insert a Function).