Refer to the exhibit. A data analyst wants to create a formula in Microsoft Excel that will automatically calculate the net revenue from the sales of dining sets. Which formula inserted in cell F2 will accomplish this?
- =(C2*(B2-D2)*E2)
- =(B2*C2)-(D2*C2)*E2
- =B2*C2-D2*E2
- =B2-D2+C2*E2
| Explanation & Hint:
The correct formula is =(C2*(B2-D2)*E2) and will yield a net loss in revenue amounting to $580.10. |