DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=8:4
|
|
|
8:4=
|
|
|
8/4=
|
|
|
=8/4
|
|
|
=8/4:4
|
Detailed explanation-1: -Divide numbers in a cell To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a cell, the cell displays 2. Important: Be sure to type an equal sign (=) in the cell before you type the numbers and the / operator; otherwise, Excel will interpret what you type as a date.
Detailed explanation-2: -To divide a value in cell A2 by 5: =A2/5. To divide cell A2 by cell B2: =A2/B2. To divide multiple cells successively, type cell references separated by the division symbol. For example, to divide the number in A2 by the number in B2, and then divide the result by the number in C2, use this formula: =A2/B2/C2.
Detailed explanation-3: -The correct answer is 0. The answer of the formula = 8/4/2-2/2 in excel is 0.