Critical Thinking Questions Case 3-2 George Runs a Mid-Size Accounting

Multiple Choice

Critical Thinking Questions Case 3-2 George runs a mid-size accounting practice. He has recently upgraded to Excel for some aspects of his business. He expects sales to grow in the next few months during 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 software upgrade for the Receptionist. Otherwise, George will just purchase the desk and chair. How should George determine this in the worksheet?

A) use a relative reference
B) use the IF function
C) use an absolute reference
D) use the NOW function