USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
^
|
|
|
+
|
|
|
-
|
|
|
/
|
Detailed explanation-1: -To refer to a cell or a range of cells in another worksheet, type the name of the target worksheet followed by an exclamation point (!) before the cell or range address.
Detailed explanation-2: -The exclamation mark means that the workbook is a macro-enabled workbook with extension . xlsm (a standard Excel 2007/2010 workbook cannot contain macros and has extension . xlsx).
Detailed explanation-3: -When entered as the reference of a Named range, it refers to range on the sheet the named range is used on. For example, create a named range MyName refering to =SUM(!B1:!K1)
Detailed explanation-4: -The “does not equal” operator Excel’s “does not equal” operator is simple: a pair of brackets pointing away from each other, like so: “<>". Whenever Excel sees this symbol in your formulas, it will assess whether the two statements on opposite sides of these brackets are equal to one another.
Detailed explanation-5: -Factorial: Denoted by the exclamation mark (!). Factorial means to multiply by decreasing positive integers. For example, 5! = 5 ∗ 4 ∗ 3 ∗ 2 ∗ 1 = 120.