Question 8 • Mathematics for Data and Financial Literacy
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 plus 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 minus 20 comma 000, B5 remains the same, B6 formula remains is equal to cap b 4 minus cap b 5