# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
 A true B false C Either A or B D None of the above
Explanation:

Detailed explanation-1: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the \$ sign before the row and column coordinates makes an absolute cell reference that won’t change.

Detailed explanation-2: -A cell reference with only one dollar sign before either the column of the row is called mixed cell reference.

Detailed explanation-3: -A cell reference with only one dollar sign before either the column or the row is called a MIXED CELL REFERNCE.

Detailed explanation-4: -Absolute cell references In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “\$” – for example, \$A\$1 is an absolute reference to cell A1. Wherever the formula is copied or moved, it always refers to cell A1.

Detailed explanation-5: -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.

There is 1 question to complete.