George runs a mid size accounting practice George runs a mid-size accounting pra

Question

George runs a mid size accounting practice George runs a mid-size accounting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and can software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet? Copy and paste all his Sales data formulas with relative reference Add an IF function formula to his Sales data worksheet Add the Now function formula to his sales data worksheet Copy and paste all his sales data formulas with absolute references

Explanation / Answer

Case 1:
If sale reach certain amount by the end of April, George will purchase a desk, chair
computer and software upgrade for the receptionist. Otherwise, George will just purchase
the desk and chair. How can George determine the best action to take using a Sale Data
worksheet?
b. Add an IF function formula to his Sales data worksheet. And based on the result,
his decision will be made.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.