DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
/
|
|
|
[
|
|
|
-
|
|
|
*
|
Detailed explanation-1: -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: -Division Math Formula The formula to calculate the division of two numbers is: Dividend รท Divisor = Quotient + Remainder. The remainder is the leftover number in the division operation. If 46 is divided by 5, we get the quotient as 9 and the remainder 1.
Detailed explanation-3: -You can also suppress this error by nesting your division operation inside the IFERROR function. Again, using A2/A3, you can use =IFERROR(A2/A3, 0). This tells Excel if your formula evaluates to an error, then return 0, otherwise return the result of the formula.
Detailed explanation-4: -Divide Numbers With Paste Special Select the cells which contain the amounts that you want to divide. In the screen shot below, cells C2:C11 are selected. In the Options section, click Divide, then click OK. Each of the selected numbers is automatically divided by 1000.