Question

Which of the following characters is used to create an absolute address in MS-Excel?

A Dollar ($) Correct Answer Incorrect Answer
B Ampersand (&) Correct Answer Incorrect Answer
C Percent (%) Correct Answer Incorrect Answer
D Hash (#) Correct Answer Incorrect Answer

Solution

Absolute reference in excel is used when we want to fix the position of the selected cell in any formula so that its value will not change whenever we are changing the cell or copying the formula to other cells or sheets. This is done by putting the dollar ("$") sign before and after the column name of the selected cell. Or else, we can type the F4 function key, which will automatically cover the column alphabet with the dollar.

Practice Next

Relevant for Exams:

×
×