USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=A1*B1*C1*D1
|
|
|
=A1+B1*C1/D1
|
|
|
=A1*B1+C1/D1
|
|
|
=A1/B1*C1+D1
|
|
|
=A1^B1*C1+D1
|
Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -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-3: -The range reference for cells A1 through A5 and cells F1 through G5 is: A1:A5; F1:G5. 12. To force text that extends beyond a cell’s border to fit within the cell, make the cell with truncated text the active cell, and then click the Wrap Text button in the Alignment group on the Home tab.
Detailed explanation-4: -Examples of simple formulas =A1+A2+A3 this Excel formula adds the contents of the three cells specified (see the SUM function for adding multiple numbers).