Answer:
An absolute cell reference is a cell address that contain a dollar sign $ in row and column coordinate or both. We use absolute reference to keep row and column constant
Example: C5*$C$2
The reference to C2 is absolute and will not change when copied.
Answer:
The Data Entry is Restricted to Specific Fields, Reducing Errors
Explanation:
Internet assigned numbers authority (IANA for short).
