Refer to the spreadsheet. Customers who purchase more than $1,000 of equipment receive a discount of $10 on their Initial Total, as well as a free mouse. Which of the following formulas can be used to display the message "Free Mouse!" in K4, and can be copied down?Choose carefully! If you include an incorrect response, you will receive no marks for this question.

Question

BlackTom AI · Accepted Answer

The IF function takes the form IF(condition, value_if_true, value_if_false). To show "Free Mouse!" when the Initial Total in column I is greater than the $1,000 threshold in B2, and have that formula copy correctly down the column, you must:
1) test I4 > $B$2, and 2) return the fixed cell containing the label "Free Mouse!" ($C$2) when true, otherwise return "Thank you!".

Step-by-step reasoning:
1. Condition: I4>$B$2 — this checks whether the Initial Total in the current row (I4) exceeds the threshold in B2. The dollar signs lock the reference to the single threshold cell so copying the formula down still checks against $B$2.
2. True result: $C$2 — this points to the single cell that contains the text “Free Mouse!”; using an absolute reference ensures every copied formula pulls the same message.
3. False result: "Thank you!" — a literal string that must be enclosed in quotes.

Evaluate two example rows:
- Mandy Tang (I4 = $875): 875 > 1000 is FALSE → IF returns "Thank you!".
- Rocco Shaw (I5 = $2,803): 2803 > 1000 is TRUE → IF returns the text in $C$2 ("Free Mouse!").

Why option (a) is correct:
=IF(I4>$B$2,$C$2,"Thank you!") exactly implements the condition, returns the header cell with the Free Mouse text when true, and uses absolute references so it can be copied down.

Why the other options are incorrect:
- (b) uses the reversed test (I4<=$B$2) so the logical roles are inverted and is less direct for the stated requirement (and may rely on returning $C$2 as the false branch — ambiguous here).
- (c) omits the required quotes around the literal "Thank you!" (syntax error) and does not properly lock the threshold cell.
- (d) uses equality (I4=$B$2), which only awards a free mouse when the total equals exactly $1,000 rather than when it is greater.

Final confirmation: the correct formula is option a: =IF(I4>$B$2,$C$2,"Thank you!").

类似问题

How should you include a parameter or fixed variable in a cell operation or function?

Refer to the included Bike Safety Patrol Budget Spreadsheet. Cell D4 contains the total cost of purchasing T-shirts. The number purchased is in cell C4 and the cost per T-shirt is in cell B4. What formula accomplishes this task? Type the formula with NO spaces.

Ling has created the following spreadsheet to calculate the amount her travel costs each week. Every day Ling travels to university it costs her $10.00. Cell D2 contains a formula using cell referencing. The formula entered in D2 is

Ling has created the following spreadsheet to calculate the amount her travel costs each week. Every day Ling travels to university it costs her $10.00. Cell D2 contains a formula using cell referencing. The formula entered in D2 is

Ling has created the following spreadsheet to calculate the amount her travel costs each week. Every day Ling travels to university it costs her $10.00. Cell D2 contains a formula using cell referencing. The formula entered in D2 is

What would be the correct syntax to reference F19 instead of "hard coding" 3, the criterion for a productive day, in your formula for Exercise 1?

Refer to the screen shot. Which of the following formulas will give the same result as shown in cell F5?Choose all that apply, but choose carefully! If any that you choose are incorrect, your whole answer will be incorrect.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单