# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Choose the correct example:The column is absolute; the row is relative
 A =A1 B =\$A1 C =A\$1 D =\$A\$1
Explanation:

Detailed explanation-1: -Answer. Answer: The row and column portions of a relative reference are not preceded by a “\$” – for example, A1 is a relative reference to cell A1. If moved or copied, the reference changes by the same number of rows and coulmns as it was moved.

Detailed explanation-2: -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-3: -For example, A1 is a relative cell reference, and it would become absolute when you make it \$A\$1.

Detailed explanation-4: -A relative reference in Excel is a cell address without the \$ sign in the row and column coordinates, like A1. When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns.

There is 1 question to complete.