2
practice testMultiple Choice

Practice Test

Question 2 • Financial Math

If GreenWave Technologies decides to invest an additional $⁢50,000 in equipment, how should you update the spreadsheet to calculate the new net worth? Assume total assets are in cell B1, total liabilities are in cell B2, and net worth is calculated in cell B3.

Answer
A
update B2 to is equal to 500 comma 000 minus 50 comma 000, B1 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
B
update B1 to is equal to 500 comma 000 plus 50 comma 000, B2 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
C
update B1 to is equal to 500 comma 000 minus 50 comma 000, B2 remains the same, B3 formula remains is equal to cap b 1 minus cap b 2
D
update B1 to is equal to 500 comma 000 plus 50 comma 000, B2 to is equal to 200 comma 000 plus 50 comma 000, B3 formula remains is equal to cap b 1 minus cap b 2
Previous
Next
If GreenWave Technologies decides to invest an…