DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
^
|
|
|
+
|
|
|
-
|
|
|
/
|
Detailed explanation-1: -In most cases, you would see the exclamation mark is used before cell references and after sheet names in formulas. This delimiter (!) is employed when the formula from one sheet uses a cell reference from a separate spreadsheet.
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 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.