USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
(
|
|
|
>
|
|
|
-
|
|
|
=
|
Detailed explanation-1: -On the worksheet, click the cell in which we want to enter the formula. Type the = (equal sign) followed by the constants and operators that we want to use in the calculation. Q. Statement I: ‘’ symbol is used to insert a formula in a cell of a spreadsheet in Microsoft Excel.
Detailed explanation-2: -Place your cursor in the file at the spot where you want to insert the symbol. Go to Insert > Symbol. Pick a symbol, or choose More Symbols. Scroll up or down to find the symbol you want to insert.
Detailed explanation-3: -Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).
Detailed explanation-4: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-5: -The correct answer is Shift + F3. When you click the Insert Function button, Excel displays the Insert Function dialog box.