Case 7-3 Juan Tells You That Your Work in Excel Will Go

question 41

Multiple Choice

Case 7-3
Juan tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses.You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result.Juan offers to help you.
-Which of the following is an example of a valid defined name Juan can provide to you?

• A).FY2010
• B)F-Y2010
• C)FY2010
• D)FiscalYear2010

Understand the acquisition method of accounting for business combinations.

Calculate the total consolidated net assets after a business combination.

Identify and compute fair values adjustments in business combinations.

Determine the consolidated financial statement figures such as revenues, common stock, and equipment after a business combination.

---

Definitions:

Investment

The action or process of allocating resources, usually money, in order to generate income or profit.

Inventory Computerization

The use of computer systems and software to manage and track product inventories in businesses.

Net Investment

The overall expense incurred on new capital assets, reduced by the depreciation value of the existing capital assets.

Gross Investment

The total amount spent on new capital assets before accounting for depreciation, representing investment in expanding productive capacity.