DSSSB · Computer

Consider the statements about MS Excel cell addressing: 1. Absolute cell addressing is preceded by the column letter and row number with a dollar sign ($), such as $A$1. 2. The reference with relative cell address changes the formula when copied to another cell. Which option is correct?

  1. neither 1 nor 2
  2. both 1 and 2
  3. only 2
  4. only 1
Answer and detailed solution are available in the protected study screen.
Register or login to attempt