George Runs a Mid-Size Accounting Practice and Recently Upgraded to Excel

question 51

Multiple Choice

George runs a mid-size accounting practice and recently upgraded to Excel 2010.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?

• A)Copy and paste all his Sales data formulas with relative references
• B)Add an IF function formula to his Sales data worksheet
• C)Add the NOW function formula to his Sales data worksheet
• D)Copy and paste all his Sales data formulas with absolute references

---

Definitions:

Wheel Cylinders

Wheel cylinders are components in a drum brake system, responsible for exerting force onto the brake shoes to stop the vehicle.

Mechanical Force

A physical influence applied to an object that causes it to change its velocity, direction, or shape.

Dash-warning Light

A light or indicator located on a vehicle's dashboard designed to alert the driver about various vehicle conditions or malfunctions.

Air-over-hydraulic Brakes

Brake systems that use air pressure to enhance or actuate the hydraulic brake fluid pressure, combining both air and hydraulic systems' benefits.