Question

Which of the following is not a type of cell references in MS Excel. *
•Combined Reference
•Absolute Refrence
•Relative Reference
•Mixed Reference​

Answer 1

Answer:

relative reference is right answer

Answer 2

Answer:

Combined Reference is not a type of cell references in MS Excel.

Explanation:

There are three types of cell references in MS Excel.

1. Relative cell references: It doesn’t contain dollar signs before a Row name or a Column Name, e.g. D4.

2. Absolute cell references: It contains dollar signs before a Row name and a Column Name, e.g. $D$4.

3. Mixed cell references:  It contains dollar signs either before a Row name or before a Column Name, e.g. $D4, B$7.