DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
It is known that cell A1 = 6, cell B1 = 3, cell C1 = 5, cell D1 = 2. If you input these numbers into a formula and the number is 20, 5 then the correct formula is ____
|
|
=A1*B1*C1*D1
|
|
|
=A1+B1*C1/D1
|
|
|
=A1*B1+C1/D1
|
|
|
=A1/B1*C1+D1
|
|
|
=A1^B1*C1+D1
|
Explanation:
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: -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).
There is 1 question to complete.