Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which reference would you use in a grid formula to always read the row labels in column A while moving across columns?

  1. A A2
  2. B $A2
  3. C A$2
  4. D $A$2
Answer

$A2

Locking the column but not the row lets one formula be filled across an entire two-dimensional grid, such as a rate matrix.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as