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

1 when are tests of simple main effects used and what do

1. When are tests of simple main effects used, and what do researchers learn from them? 2. Who developed the rationale and computations for the analysis of variance? 3. Under what two circumstances would you use a multiv ...

What is the relation between a companys operating risk and

What is the relation between a company's operating risk and its optimal capital structure? What is meant by the pecking order theory of capital structure? What are the implications of the Modigliani-Miller theory of capi ...

The centers for disease control and prevention released a

The Centers for Disease Control and Prevention released a report in 1998 that attributed part of the increase in youth smoking in the 1980s to the use of the cartoon character, Joe Camel, in cigarette advertising. Using ...

Milgram conducted his experiments on obedience in the days

Milgram conducted his experiments on obedience in the days before all research was scrutinized by an Institutional Review Board. Imagine, however, that Milgram had submitted his research proposal to an IRB of which you w ...

You are assigned a paper and excel backup on exxon company

You are assigned a paper and excel backup on EXXON company. You will utilize all the material we have covered to analyze and assess the corporate health of the company. I provide some leading questions to be answered in ...

If asset as beta is greater than asset bs beta does this

If asset A's beta is greater than asset B's beta, does this mean that asset A has more risk than asset B? Explain? What is the difference between the security market line and the capital market line? How should an invest ...

Refer to given problem the owner determines that if the

Refer to given problem. The owner determines that if the property were renovated instead of sold, after-tax cash flow over the next year would increase to $60,000 and the property could be sold after one year for $2.4 mi ...

1 distinguish among observational physiological and

1. Distinguish among observational, physiological, and self-report measures. 2. What do researchers interested in psychometrics study? 3. Why do researchers use converging operations? 4. Distinguish among nominal, ordina ...

What type of constraints may a client impose on a portfolio

What type of constraints may a client impose on a portfolio manager? If an investment in stock has a value of $3,000 at the beginning of the year and $3,500 at the end of the year, and paid a dividend of $250 at the end ...

1 according to readygov what are the three basic steps

1. According to Ready.Gov, what are the three basic steps people can take to prepare for any type of disaster? 2. What are the seven key elements that can be used to measure the comprehensive nature of an evacuation plan ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen