FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the MS Excel spreadsheet, to turn the Formula bar on and off, we use which of the following menu commands?
A
View  Formula bar
B
View  Toolbars  Standard
C
View  Ruler
D
View  Toolbars  Drawing
Explanation: 

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: -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.

There is 1 question to complete.