FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Where do your formulas appear when you type them in a worksheet?

A	Name Box
B	Formula Bar
C	Search Box
D	Function Bar

Explanation:

Detailed explanation-1: -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: -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-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: -The formula bar displays information entered in the current or active cell. The contents of a cell can also be edited in the formula bar. The formula bar gets activated as soon as you type an equal sign in any cell or click anywhere within the bar.

There is 1 question to complete.