Question: When a user types = $ C $ 6 in a cell, what does that mean? Select one: A . The value will stay constant,

When a user types =$C$6 in a cell, what does that mean?
Select one:
A. The value will stay constant, referred to as "absolute reference".
B. The cell will always show as a dollar value since the user specifically referenced the dollar sign in its cell reference.
C. The cell will reflect the text "C6" since it has a dollar sign before each column and row listed.
D. The user is making a relative cell reference and that if the formula is copied and pasted elsewhere that the cell will shift as appropriate.
 When a user types =$C$6 in a cell, what does that

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!