FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Cell names are ____ cell references.
A
absolute
B
mixed
C
relative
D
formatted
Explanation: 

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.

Detailed explanation-3: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.

Detailed explanation-4: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-5: -By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.

There is 1 question to complete.