91.8k views
0 votes
Which sign or symbol will you use to lock cells for absolute cell reference?

A.
ampersand
B.
asterisk
C.
dollar sign
D.
exclamation mark

User Aaz
by
4.8k points

2 Answers

4 votes

Answer:

C. dollar sign

Step-by-step explanation:

User Greg Buchholz
by
4.9k points
6 votes

Answer:

Option C. dollar sign is the correct answer

Step-by-step explanation:

There are two types of referencing styles used in MS excel.

Relative and absolute.

Out of these two, absolute referencing is used where we don't want the cell addresses to change when the formula with cell reference is copied. Dollar sign is with the row and column number to write an absolute cell reference.

An absolute cell reference for cell C5 is written as:

$C$5

Hence,

Option C. dollar sign is the correct answer

User HariHaraSudhan
by
4.9k points