In the spreadsheet, if the revenue is in cell B4 and the expenses are in cell B5, which formula should be used to calculate the net profit in cell B6?
Answer
A
is equal to cap b 4 plus cap b 5
B
is equal to cap b 4 minus cap b 5
C
is equal to SUM times open paren cap b 4 close paren
D
is equal to cap b 5 minus cap b 4
Explanation
Net profit is calculated by subtracting expenses from revenue. With revenue in B4 and expenses in B5, enter =B4-B5 in cell B6. This corresponds to “is equal to B4 minus B5.”
AI-written and checked against the verified answer.