FUNDAMENTALS OF COMPUTER

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: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.

Detailed explanation-5: -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.