Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. You have a monthly income of 2000 that is stored in cell B3. Your rent expense is 450 that is stored in cell B6. Write a formula using an absolute cell reference that would return a value of 1550 in cell C6.
A) =$B$3-B6
B) =$B$4-B6
C) =B$3-B6
D) =$B$9-B6

Question

Quizplus · Accepted Answer

The formula =$B$3-B6 uses an absolute cell reference to cell B3, which means that the reference will not change when the formula is copied or moved to another location in the worksheet. This ensures that the formula will always subtract the value in cell B6 from the value in cell B3, which is the desired result.

Critical Thinking Questions Case 1-1 You Have Created a Simple