1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs
        
             
        
        
        
Answer:
2. (i) demand-side; (ii) both; (iii) supply-side; (iv) supply-side; (v) both
Explanation:
a. $1,000 per person tax reduction  ⇒ focus on aggregate demand (more money for consumers to spend)
b. a 5% reduction in all tax rates  ⇒ focus on both aggregate demand and supply (more money for consumers and suppliers)
c. Pell Grants, which are government subsidies for college education  ⇒ focus on aggregate supply (more money for suppliers of college education)
d. government-sponsored prizes for new scientific discoveries ⇒ focus on aggregate supply (more money for suppliers of new scientific discoveries) 
e. an increase in unemployment compensation  ⇒ focus on both aggregate demand and supply (more money for consumers resulting in higher prices and lower output)
 
        
             
        
        
        
Answer:
A disadvantage of the corporate form of business entity is corporations are subject to more governmental regulations. 
 
        
             
        
        
        
Not 100% sure but I would say the second one but don't hold me to it.  Go with your gut feeling. 
        
             
        
        
        
Answer:
The answer is given below;
Explanation:
The adjusting entry will be;
Income Statement             Dr.$5,000
Inventory                             Cr.$5,000
As the NRV is less than cost,therefore difference amount will be charged to profit and loss account.