DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
absolute
|
|
mixed
|
|
relative
|
|
formatted
|
Detailed explanation-1: -In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other. A dollar symbol ($) is used before the coordinates to correct them. For instance, $D$2 is an absolute reference to cell D2.
Detailed explanation-2: -By default, named ranges behave like absolute references and don’t change when you copy formulas. In addition, they make your formulas easier to read.
Detailed explanation-3: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Detailed explanation-4: -You can use named cells or cell references to specify filter criteria and other field values in a query definition form. For example, if a worksheet cell contains an account code, you can insert a reference to that cell in a query definition instead of specifying the account code itself.