FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION 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]

In excel cells, the display of formulas / formulas can be displayed, the question is, are the settings for displaying formulas in cells in the menu?

A	file
B	insert
C	formula
D	view

Explanation:

Detailed explanation-1: -Click on Formulas and then click on Show Formulas to switch between displaying formulas and results.

Detailed explanation-2: -To show formulas in Excel, you can click on the Formulas tab and then click Show Formulas. This will show all formulas in the Excel worksheet.

Detailed explanation-3: -In Microsoft Excel, if you enter a formula that links one cell to a cell that is formatted with the Text number format, the cell that contains the link is also formatted as text. If you then edit the formula in the linked cell, the formula is displayed in the cell rather than the value that is returned by the formula.

Detailed explanation-4: -What is a formula bar in Excel? 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.

There is 1 question to complete.