DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
+
|
|
-
|
|
/
|
|
*
|
|
:
|
Detailed explanation-1: -The four important terms used in the division operation are dividend, divisor, quotient and remainder. The formula to calculate the division of two numbers is: Dividend ÷ Divisor = Quotient + Remainder. The remainder is the leftover number in the division operation.
Detailed explanation-2: -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-3: -Consider a simple example of 6 being divided by 2 gives 3. It can be mathematically written as. 6 ÷ 2 = 3. Here the remainder is 0 as 6 completely divides 2 and the quotient is 3. Dividend = (Divisor × Quotient) + Remainder.
Detailed explanation-4: -Division is represented by the “÷“ symbol.
Detailed explanation-5: -The number which is divided is called the dividend. The number which divides is called the divisor. The number which is the result of the division is called the quotient. If there is any number left over, it is called the remainder.