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

question 93

Multiple Choice

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

Understand the dynamics and types of formal and informal communication networks within organizations.

Recognize the importance and application of an audience-centered approach in effective communication.

Identify and implement critical communication skills expected by employers.

Evaluate and apply emotional intelligence and the "you" attitude in interpersonal communication.

---

Definitions:

Accounts Receivable

Money owed to a company by its customers for goods or services that have been delivered or used but not yet paid for.

Bank Charges Expense

Costs incurred by an account holder for the bank's services, such as account maintenance fees, non-sufficient funds (NSF) fees, or transaction fees.

NSF

An abbreviation for "Non-Sufficient Funds," indicating that a cheque could not be honored due to insufficient funds in the account.