DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS 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: -The symbol for division, or sharing into equal groups, is ÷. It’s called the division symbol.
Detailed explanation-3: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-4: -Use the multiplication sign (×), not the letter x, to indicate the mathematical operation. Use an asterisk (*) if you need to match the UI.