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