If the formula below is written in cell C4, = B$5then copied into cell C5.The formula in cell C5 will be: = Blank 1 Question 1  Blank 2 Question 1A B C D $A $B $C $D4 5 6 $4 $5 $6

The formula in cell C5 will be: = B$5

Explanation: In Excel, the dollar sign ($) in a cell reference affects only one thing: It tells Excel how to treat your references when you copy them. If you copy the formula (= B$5) to another location, the column reference (B) will change, but the row reference (5) will not because it is absolute (has a $sign in front of it). So, when you copy the formula from cell C4 to C5, the formula will still be (= B$5).