Critical Thinking QuestionsCase 3-1George 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 referencesc.Add the NOW function formula to his Sales data worksheetb.Add an IF function formula to his Sales data worksheetd.Copy and paste all his Sales data formulas with absolute references
What will be an ideal response?
Answer: B
You might also like to view...
Referring to the accompanying figure, which callout points to the option used to customize the animation?
A. D B. E C. F D. G
To set the page size and orientation for page size 8.5 X 14 with landscape orientation, the style property would be ____.
A. size: 14in 8.5in landscape; B. size: 8.5in 11in landscape; C. size: 11in 8in landscape; D. size: 8.5in 14in landscape;
Connects two tables together by their common field in the Relationships window.
What will be an ideal response?
_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
A. Click B. Press C. Double-click D. Triple-click