6
QuizMultiple Choice

Quiz — Quiz

Question 6 • Quiz

GreenWave Technologies receives an unexpected bill of $⁢20,000 How should you update the spreadsheet to calculate the new net profit? Assume revenue is in cell B4, expenses are in cell B5, and net profit is calculated in cell B6.

Answer
A
update B4 to is equal to 600 comma 000 minus 20 comma 000, B5 remains the same, B6 formula remains is equal to cap b 4 minus cap b 5
B
update B5 to is equal to 400 comma 000 plus 20 comma 000, B4 remains the same, B6 formula remains is equal to cap b 4 minus cap b 5
C
update B5 to is equal to 400 comma 000 minus 20 comma 000, B4 remains the same, B6 formula remains is equal to cap b 4 minus cap b 5
D
update B4 to is equal to 600 comma 000 plus 20 comma 000, B5 remains the same, B6 formula remains =is equal to cap b 4 minus cap b 5

Explanation

An unexpected bill increases expenses by $20,000, so update B5 from $400,000 to $400,000 + $20,000 = $420,000. Keep revenue in B4 unchanged, and leave the net profit formula in B6 as =B4-B5. Therefore, choice B is correct.

AI-written and checked against the verified answer.

Previous
Next