FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.