Question

Q10.What is mixed reference and how to apply it?​

Answer 1

Create a Mixed Reference

1. Click a cell where you want to enter a formula.

2. Type = (an equal sign) to begin the formula.

3.Select the cells you want to use and then complete the formula.

4.Click the insertion point in the formula bar, and then type $ before the column or row you want to make absolute.

Answer 2

$\red{\sf{what \: is \: mixed \: reference}}$

》An mixed reference in Excel is a reference where part of the reference is absolute and part is relative