# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A cell reference that adjusts to a new location when copied or moved
 A Mixed B Absolute C Relative D Vlookup
Explanation:

Detailed explanation-1: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “\$” before the column letter if you want that to always stay the same.

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

Detailed explanation-3: -These cell references that adjust itself when the cell is copied are called relative cell references in Excel.

Detailed explanation-4: -Relative cell references contain no dollar signs (i.e., A1). Mixed cell references have dollar signs attached to either the letter or the number in a reference but not both (i.e., \$A1 or A\$1). Absolute cell references have dollar signs attached to each letter or number in a reference (i.e., \$A\$1).

There is 1 question to complete.