Question

George runs a mid-size accounting practice and recently upgraded to Excel 2016. 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 can George determine the best action to take using a Sales Data worksheet

Answer 1

Answer:

The options are missing, so I looked for a similar question and found them:

1. Copy and paste all his Sales data formulas with relative reference
2. Add an IF function formula to his Sales data worksheet
3. Add the Now function formula to his sales data worksheet
4. Copy and paste all his sales data formulas with absolute references

The correct answer is:

2. Add an IF function formula to his Sales data worksheet

Explanation:

The most popular worksheet is Excel, and the IF function in excel helps us to compare the actual value of a cell (or group of cells) and the value that we expected it would have.

In this case, George has decided to refurbish his office only IF his sale level increases above a certain point.