Question

which two types of cell reference is mixed cell reference a combination of ?

​

Answer 1

Explanation:

A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row.

Answer 2

Explanation:

A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row. For example, $A1 is absolute for column A and relative for row 1, and A$1 is absolute for row 1 and relative for column A. If you copy or fill the formula across rows or down columns, the relative references adjust, and the absolute ones don’t adjust.

Create a Mixed Reference

yellow-01.jpg Click a cell where you want to enter a formula.

yellow-02.jpg Type = (an equal sign) to begin the formula.

yellow-03.jpg Select the cells you want to use and then complete the formula.

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

yellow-05.jpg Click the Enter button on the formula bar, or press Enter.