Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

1. Open the excel file and click on the data worksheet. Use the SUMIF function to find out the total amount of sales in dollars (A/R Change) for each of the four types (Blue, Red, etc) This should match these totals.
August Sales in Dollars by Type
Blue $33,090.89
Green $36,701.39
Red $37,061.09
White $43,480.92
Total $150,334.29

2. Use the SUMIFS function to determine the amount of sales for each type of inventory (Blue, Red, Etc.) for a specific function. Please note that the length of your different ranges must be identical. Ranges have to go to row 6520 or longer.date during August 2010.

3. Use the Drop Down List feature and the SUMIFS function to determine the amount of dollar sales for each type of inventory (Blue, Red, etc.) for any customer for the month. ( Don't use pivot table for customer list use a range reference)

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927920

Have any Question? 


Related Questions in Basic Finance

A firm has common stock of 80 paid-in surplus of 160 total

A firm has common stock of 80, paid-in surplus of 160, total liabilities of 350, current assets of 420, and fixed assets of 630. What is the amount of the shareholders' equity?

How is the failure of an fi different from the failure of a

How is the failure of an FI different from the failure of a video rental store? What do these differences imply about the need for regulation?

After reading the article draft a two-page paper by

After reading the article, draft a two-page paper by explaining what you learned about accounting and finance. You can include any reflections related to the article; however, address in paragraph form at least the follo ...

Why might a sterilized foreign exchange market intervention

Why might a sterilized foreign exchange market intervention have a greater impact on the exchange rate in times of financial stress than in times of normal market conditions?

Module slp cash flowthis assignment requires word and excel

Module SLP CASH FLOW This assignment requires word and excel documents. Cash Flow Estimation and Capital Budgeting Applying Various Capital Budgeting Methodologies The objective of a firm is to maximize shareholder wealt ...

The final paper ought to show an understudys capacity to

The Final Paper ought to show an understudy's capacity to incorporate and orchestrate course ideas with chose readings to impart his/her comprehension of legal bookkeeping, extortion ideas, and their applications in asso ...

What is a currency boardis having a fixed exchange rate

What is a currency board? Is having a fixed exchange rate with a currency board that defends the fixed rate better for a country than having a fixed exchange rate and a standard central bank that defends the fixed rate?

When your governor took office 100000 children in your

When your governor took office, 100,000 children in your state were eligible for Medicaid and 200,000 children were not. Now, thanks to a large expansion in Medicaid, 150,000 children are eligible for Medicaid and 150,00 ...

Assignmentnote be sure to show all calculations to receive

Assignment NOTE: Be sure to show all calculations to receive credit and follow the Assignment Instructions. 1. BubbaBraggard is very excited because sales for his nursery and plant company are expected to double from $65 ...

Impact of the economy explain how the expected interest

Impact of the Economy : Explain how the expected interest rate in one year depends on your expectation of economic growth and inflation.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate