Question

write one example or mixed refernce​

Answer 1

Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell, for example in cell A1 if we want to refer to only A column the mixed reference would be $A1, to do this we need to

Answer 2

$\begin{gathered}{\underline{\underline{\maltese{\Huge{\textsf{\textbf{\red{Answer: }}}}}}}}\end{gathered}$

• A mixed reference is a reference that refers to a specific row or column. For example, $A1 or A$1. If you want to create a mixed reference- press the F4 key on the formula bar two or three times depending on whether you want to refer to row or column