FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131. The SUM formula automatically updates with the insertion or deletion of a value.

Detailed explanation-2: -=CONCATENATE(A2, B2). The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2. If you have more than two columns you would like to combine, then simply add a comma after each cell.

Detailed explanation-3: -For example, to add together cells A1 and B1, move to C1 (or wherever you want the result of the calculation to appear) and type the =. Then use the mouse to click in A1, type the +, click in B1, and hit the enter key.

Detailed explanation-4: -Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk(*), or forward slash (/) signs. Let’s take an example of a simple formula. On the worksheet, click the cell in which you want to enter the formula.