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 $$ 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 C 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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
