# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### 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.