# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is mixed cell reference with a fixed row address?
 A G\$9 B \$K356 C \$F\$8 D None of the above
Explanation:

Detailed explanation-1: -Answer. Answer: A mixed reference is a reference that refers to a specific row or column. For example, \$A1 or A\$1.

Detailed explanation-2: -A mixed reference in Excel is a type of cell reference different from the other two absolute and relative. We only refer to the cell’s column or row in the mixed cell reference. So, for example, in cell A1 if we want to refer to only the A column, the mixed reference would be \$A1.

Detailed explanation-3: -Mixed reference in Excel means only part of the reference is fixed, either the row or the column, and the other part is relative. Unlike absolute references, only one \$ (dollar sign) is applied, either in front of the column or row number.

Detailed explanation-4: -Mixed Referencing is a combination of Relative and Absolute reference. In this type of reference, either row or column has to remain fixed. =\$A1+A\$2 is an example of Mixed Referencing. 10 Likes.

Detailed explanation-5: -\$A1\$B2 is an example of mixed referencing in spreadsheet software. Numbers entered into a cell are automatically right aligned. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5; 60) will display 20.

There is 1 question to complete.